_XOnDAO2_FieldInfo_VIs.vi

Description



FAttributes


Connector Pane

FAttributes


Controls and Indicators

cu32

Attributes in

c1denum

FAttributes in

iu32

Attributes

i1denum

FAttributes

FIDeleteFI

This function is the destructor of Handle of the Field Info.

Parameters

FIHandle Handle of the Field Info (input)

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIDeleteFI


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FIGetAllowZeroLength

This function reads a value that indicates whether a zero-length string ("") is a valid setting for the Value property of the Field object with a Text or Memo data type.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

ZeroLenOut Is True if the Field object accepts a zero-length string as its Value property; the default value is False

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIGetAllowZeroLength


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ibool

ZeroLenOut

FIGetAttributes

This function reads the Field-Attributes.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

AttributesOut Specifies characteristics of a field object contained by a tabledef, recordset, querydef, or index object. The value returned can be a sum of these constants, created with the bitwise-OR operator:

dbAutoIncrField = 16 The field value for new records is automatically incremented to a unique Long integer that can't be changed (in a Microsoft Jet workspace, supported only for Microsoft Jet database(.mdb) tables).

dbDescending = 1 The field is sorted in descending (Z to A or 100 to 0) order; this option applies only to a Field object in a Fields collection of an Index object. If you omit this constant, the field is sorted in ascending (A to Z or 0 to 100) order. This is the default value for Index and TableDef fields (Microsoft Jet workspaces only).

dbFixedField = 1 The field size is fixed (default for Numeric fields).

dbHyperlinkField = 32768 The field contains hyperlink information (Memo fields only).

dbSystemField = 8192 The field stores replication information for replicas; you can't delete this type of field (Microsoft Jet workspaces only).

dbUpdatableField = 32 The field value can be changed.

dbVariableField = 2 The field size is variable (Text fields only).

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIGetAttributes


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

iu32

Attributes

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FIGetCollatingOrder

This function reads the Field-Attributes.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

Result Specifies characteristics of a field object contained by a tabledef, recordset, querydef,

or index object. The value returned can be a sum of these constants, created with the

bitwise-OR operator:

1 The field size is fixed (default for Numeric fields).

2 The field size is variable (Text fields only).

16 The field value for new records is automatically incremented to a unique long

integer that cannot be changed. Only supported for Microsoft Jet database

tables.

32 The field value can be changed.

1 The field is sorted in descending (ZA or 1000) order (applies only to a field

object in a Fields collection of an index object; in MFC, index objects are

themselves contained in tabledef objects). If you omit this constant, the field is

sorted in ascending (AZ or 0100) order (default).

XOn Software GmbH


Connector Pane

FIGetCollatingOrder


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

iu32

Result

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FIGetDefaultValue

This function reads the default value of a Field object.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

DefaultValueOut Is a String data type that can contain a maximum of 255 characters. It can be either text or an expression. If the property setting is an expression, it can't contain user-defined functions, Microsoft Jet database engine SQL aggregate functions, or references to queries, forms, or other Field objects.

nLen Maximal length of DefaultValueOut

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIGetDefaultValue


Controls and Indicators

cdlrn

FIHandle in

cu32

Length

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

istr

DefaultValueOut

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FIGetForeignName

This function reads the name of the Field object in a foreign table that corresponds to a field in a primary table for a relationship.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

ForeignNameOut The name of a Field in the associated TableDef object's Fields collection

nLen Maximal length of ForeignNameOut

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIGetForeignName


Controls and Indicators

cdlrn

FIHandle in

cu32

Length

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

istr

ForeignNameOut

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FIGetName

This function reads the name of a field.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

NameOut Name of the field

nLen Maximal length of NameOut

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIGetName


Controls and Indicators

cdlrn

FIHandle in

cu32

Length

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

istr

FieldName

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FIGetOrdinalPosition

This function reads the relative position of a Field within a Fields collection.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

OrdinalPositionOut Is an Integer that specifies the numeric order of fields. The default is 0.

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIGetOrdinalPosition


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

iu32

OrdinalPositionOut

ii32

FRresult

FIGetRequired

This function reads a value that indicates whether a Field object requires a non-Null value or whether all the fields must have a value.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

RequreOut Is a Boolean that is True if a field can't contain a Null value.

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIGetRequired


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ibool

RequreOut

FIGetSize

This function reads the size of a field.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

SizeOut Size for fields (other than Memo type fields) that contain character data, the Size indicates the maximum number of characters that the field can hold. For numeric fields, the Size indicates how many bytes of storage are required.

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

Result Size of the field

XOn Software GmbH


Connector Pane

FIGetSize


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

iu32

SizeOut

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FIGetSourceField

This function reads the name of the field that is the original source of the data for a Field object.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

SourceFieldOut The name of the field that is the source of data

nLen Maximal length of SourceFieldOut

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIGetSourceField


Controls and Indicators

cdlrn

FIHandle in

cu32

Length

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

istr

SourceFieldOut

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FIGetSourceTable

This function reads the name of the table that is the original source of the data for a Field object.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

SourceTableOut The name of ther table that is the source of data

nLen Maximal length of SourceTableOut

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIGetSourceTable


Controls and Indicators

cdlrn

FIHandle in

cu32

Length

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

istr

SourceTableOut

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FIGetType

This function reads the Type of a field.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

Result Type of the field - can be one of follwing:

Value Size (bytes) Description

1 1 byte BOOL

2 1 BYTE

3 2 int

4 4 long

5 8 Currency (COleCurrency)

6 4 float

7 8 double

8 8 Date/Time (COleDateTime)

10 1255 Text (CString)

11 0 Long Binary (OLE Object), CLongBinary or CByteArray

12 0 Memo (CString)

XOn Software GmbH


Connector Pane

FIGetType


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ienum

FI Type

FIGetValidationRule

This function reads a value that validates the data in a field

as it's changed or added to a table.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

ValidationRuleOut Is a String that describes a comparison in the form of an SQL WHERE clause without the WHERE reserved word

nLen Maximal length of ValidationRuleOut

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIGetValidationRule


Controls and Indicators

cdlrn

FIHandle in

cu32

Length

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

istr

ValidationRuleOut

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FIGetValidationText

This function reads the text of the message that your application displays if the value of a Field object doesn't satisfy the validation rule specified by the ValidationRule property setting.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

ValidationTextOut The text displayed if a user tries to enter an invalid value for a field

nLen Maximal length of ValidationTextOut

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FIGetValidationText


Controls and Indicators

cdlrn

FIHandle in

cu32

Length

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

ii32

FResult

idlrn

FIHandle out

istr

ValidationTextOut

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FINewFI

This function is the constructor of the DatabaseInfo Handle.

Parameters

DIHandle Handle of the DatabaseInfo (Output)

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FINewFI


Controls and Indicators

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetAllowZeroLength

This function sets a value that indicates whether a zero-length string ("") is a valid setting for the Value property of the Field object with a Text or Memo data type.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

AllowZeroLength The value is True if the Field object accepts a zero-length string as its Value property; the default value is False

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetAllowZeroLength


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cbool

AllowZeroLength

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetAttributes

This function sets the Field-Attributes.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

Attributes - specifies characteristics of a field object contained by a tabledef, recordset, querydef, or index object. The value returned can be a sum of these constants, created with the bitwise-OR operator:

dbAutoIncrField = 16 The field value for new records is automatically incremented to a unique Long integer that can't be changed (in a Microsoft Jet workspace, supported only for Microsoft Jet database(.mdb) tables).

dbDescending = 1 The field is sorted in descending (Z to A or 100 to 0) order; this option applies only to a Field object in a Fields collection of an Index object. If you omit this constant, the field is sorted in ascending (A to Z or 0 to 100) order. This is the default value for Index and TableDef fields (Microsoft Jet workspaces only).

dbFixedField = 1 The field size is fixed (default for Numeric fields).

dbHyperlinkField = 32768 The field contains hyperlink information (Memo fields only).

dbSystemField = 8192 The field stores replication information for replicas; you can't delete this type of field (Microsoft Jet workspaces only).

dbUpdatableField = 32 The field value can be changed.

dbVariableField = 2 The field size is variable (Text fields only).

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetAttributes


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cu32

Attributes

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetCollatingOrder

This function sets a value that specifies the sequence of the sort order in text for string comparison or sorting.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

CollatingOrder Can be one of the following values:

dbSortGeneral = 1033 General (English, French, German, Portuguese, Italian, and Modern Spanish)

dbSortArabic = 1025 Arabic

dbSortChineseSimplified = 2052 Simplified Chinese

dbSortChineseTraditional = 1028 Traditional Chinese

dbSortCyrillic = 1049 Russian

dbSortCzech = 1029 Czech

dbSortDutch = 1043 Dutch

dbSortGreek = 1032 Greek

dbSortHebrew = 1037 Hebrew

dbSortHungarian = 1038 Hungarian

dbSortIcelandic = 1039 Icelandic

dbSortJapanese = 1041 Japanese

dbSortKorean = 1042 Korean

dbSortNeutral = 1024 Neutral

dbSortNorwdan = 1030 Norwegian or Danish

dbSortPDXIntl = 1033 International

dbSortPDXNor = 1030 Paradox Norwegian or Danish

dbSortPDXSwe = 1053 Paradox Swedish or Finnish

dbSortPolish = 1045 Polish

dbSortSlovenian = 1060 Slovenian

dbSortSpanish = 1034 Spanish

dbSortSwedFin = 1053 Swedish or Finnish

dbSortThai = 1054 Thai

dbSortTurkish = 1055 Turkish

dbSortUndefined = -1 Undefined or unknown

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetCollatingOrder


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cu32

CollatingOrder

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetDefaultValue

This function sets the default value of a Field object.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

DefaultValue Is a String data type that can contain a maximum of 255 characters. It can be either text or an expression. If the property setting is an expression, it can't contain user-defined functions, Microsoft Jet database engine SQL aggregate functions, or references to queries, forms, or other Field objects.

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetDefaultValue


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cstr

DefaultValue

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetForeignName

This function sets the name of the Field object in a foreign table that corresponds to a field in a primary table for a relationship.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

ForeignName The name of a Field in the associated TableDef object's Fields collection

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetForeignName


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cstr

ForeignName

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetName

This function sets the name of a field.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

Name Of the field.The name must start with a letter.It can include numbers and underscore characters ( _ ) but can't include punctuation or spaces.

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetName


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cstr

Name

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetOrdinalPosition

This function sets the relative position of a Field within a Fields collection.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

OrdinalPosition Specifies the numeric order of fields. The default is 0.

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetOrdinalPosition


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cu32

OrdinalPosition

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetRequired

This function sets a value that indicates whether a Field object requires a non-Null value or whether all the fields in an Index object must have a value.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

Required Is a Boolean that is True if a field can't contain a Null value.

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetRequired


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cbool

Required

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetSize

This function sets the maximum size, in bytes, of a Field object.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

Size For fields (other than Memo type fields) that contain character data, the Size indicates the maximum number of characters that the field can hold. For numeric fields, the Size indicates how many bytes of storage are required.

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetSize


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cu32

Size

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetSourceField

This function sets the name of the field that is the original source of the data for a Field object.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

SourceField The name of the field that is the source of data

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetSourceField


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cstr

SourceField

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetSourceTable

This function sets the name of the table that is the original source of the data for a Field object.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

SourceTable The name of ther table that is the source of data

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetSourceTable


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cstr

SourceTable

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetType

This function sets the Type of a field.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

Type of the field - can be one of follwing:

Value Size (bytes) Description

1 1 byte BOOL

2 1 BYTE

3 2 int

4 4 long

5 8 Currency (COleCurrency)

6 4 float

7 8 double

8 8 Date/Time (COleDateTime)

10 1255 Text (CString)

11 0 Long Binary (OLE Object), CLongBinary or CByteArray

12 0 Memo (CString)

XOn Software GmbH


Connector Pane

FISetType


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cenum

Type

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetValidationRule

This function sets a value that validates the data in a field

as it's changed or added to a table.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

ValidationRule Is a String that describes a comparison in the form of an SQL WHERE clause

without the WHERE reserved word

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetValidationRule


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cstr

ValidationRule

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.


FISetValidationText

This function sets the text of the message that your application displays if the value of a Field object doesn't satisfy the validation rule specified by the ValidationRule property setting.

Parameters

FIHandle in Handle of the Field Info (input)

FIHandle out Handle of the Field Info (output)

ValidationText The text displayed if a user tries to enter an invalid value for a field

error in - a cluster describing the error state before executing the current VI. If the error state is TRUE, the VI will just pass the error cluster and incoming handle, no operation will happen.

error out - a cluster that describes the error status after this VI executes. If the error status is TRUE, an error occured. The DAO Error message (AKA source) is combined from the DAO-dll-call, and, where available, additional input-parameters. The DAO Error codes are always defined as:

-1 Handle not initialized

-2 Error

XOn Software GmbH


Connector Pane

FISetValidationText


Controls and Indicators

cdlrn

FIHandle in

cclst

error in (no error)

The error in cluster can accept error information wired from VIs previously called. Use this information to decide if any functionality should be bypassed in the event of errors from other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.

cstr

ValidationText

ii32

FResult

idlrn

FIHandle out

iclst

error out

The error out cluster passes error or warning information out of a VI to be used by other VIs.

The pop-up option Explain Error (or Explain Warning) gives more information about the error displayed.