_XOnDAO2_TabledefinitionInfo_VIs.vi

Description



TIDeleteTI


Connector Pane

TIDeleteTI


Controls and Indicators

cdlrn

TIHandle out

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.


TIGetAllInfos


Connector Pane

TIGetAllInfos


Controls and Indicators

cdlrn

DBHandle 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.

ci32

TDDefCount

idlrn

DBHandle out

i1dclst

TableDefInfos

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.


TIGetAttributes


Connector Pane

TIGetAttributes


Controls and Indicators

cdlrn

TIHandle 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

TIHandle 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.


TIGetConnect

Provides information about the source of an open database. You can check this property by calling the GetConnect function of your CDaoTableDef object.

For a CDaoTableDef object that represents an attached table, the string object consists of one or two parts (a database type specifier and a path to the database).

The path as shown in the table below is the full path for the directory containing the database files and must be preceded by the identifier "DATABASE=". In some cases (as with Microsoft Jet, Btrieve, and Microsoft Excel databases), a specific filename is included in the database path argument.

The following table shows possible database types and their corresponding database specifiers and paths:

Database type Specifier Path

Database using the Jet database engine ";" "drive:\\path\\filename.MDB"

dBASE III "dBASE III;" "drive:\\path"

dBASE IV "dBASE IV;" "drive:\\path"

Paradox 3.x "Paradox 3.x;" "drive:\\path"

Paradox 4.x "Paradox 4.x;" "drive:\\path"

Btrieve "Btrieve;" "drive:\\path\\filename.DDF"

FoxPro 2.0 "FoxPro 2.0;" "drive:\\path"

FoxPro 2.5 "FoxPro 2.5;" "drive:\\path"

FoxPro 2.6 "FoxPro 2.6;" "drive:\\path"

Excel 3.0 "Excel 3.0;" "drive:\\path\\filename.XLS"

Excel 4.0 "Excel 4.0;" "drive:\\path\\filename.XLS"

Excel 5.0 "Excel 5.0;" "drive:\\path\\filename.XLS"

Text "Text;" "drive:\\path"

ODBC "ODBC;

DATABASE=defaultdatabase;

UID=user;PWD=password;

DSN=datasourcename;

LOGINTIMEOUT=seconds" (This may not be a complete connection string for all servers; it is just an example. It is very important not to have spaces between the parameters.) None

Parameters

TIHandle in Handle of the Table Def Info (input)

TIHandle out Handle of the Table Def Info (output)

pBuf String

nLen Int

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

TIGetConnect


Controls and Indicators

cdlrn

TIHandle 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

TIHandle out

istr

ConnectionString

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.


TIGetDateCreated

The date and time the table was created. To directly retrieve the date the table was created, call the GetDateCreated function of the CDaoTableDef object associated with the table. See Comments below for more information. For related information, see the topic DateCreated, LastUpdated Properties in DAO Help

Parameters

TIHandle in - Handle of the Table Def Info (input)

TIHandle out - Handle of the Table Def Info (output)

Result DateLastUpdated (use OVFormatDateTime to get the Date)

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

TIGetDateCreated


Controls and Indicators

cdlrn

TIHandle 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

TIHandle out

idbl

DateCreated

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.


TIGetDateLastUpdated

The date and time of the most recent change made to the design of the table. To directly retrieve the date the table was last updated, call the GetDateLastUpdated function of the CDaoTableDef object associated with the table. See Comments below for more information.

Parameters

TIHandle in - Handle of the Table Def Info (input)

TIHandle out - Handle of the Table Def Info (output)

Result DateLastUpdated (use OVFormatDateTime to get the Date)

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

TIGetDateLastUpdated


Controls and Indicators

cdlrn

TIHandle 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

TIHandle out

idbl

DateLastUpdated

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.


TIGetName


Connector Pane

TIGetName


Controls and Indicators

cdlrn

TIHandle 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

TIHandle out

istr

TableName

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.


TIGetRecordCount


Connector Pane

TIGetRecordCount


Controls and Indicators

cdlrn

TIHandle 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

TIHandle out

iu32

RecordCount

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.


TIGetSrcTableName


Connector Pane

TIGetSrcTableName


Controls and Indicators

cdlrn

TIHandle 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

TIHandle out

istr

SrcTableName

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.


TIGetUpdatable


Connector Pane

TIGetUpdatable


Controls and Indicators

cdlrn

TIHandle 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

TIHandle out

ibool

Updateable

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.


TIGetValidationRule


Connector Pane

TIGetValidationRule


Controls and Indicators

cdlrn

TIHandle 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

TIHandle out

istr

ValidationRule

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.


TIGetValidationText


Connector Pane

TIGetValidationText


Controls and Indicators

cdlrn

TIHandle 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

TIHandle out

istr

ValidationText

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.


TINewTI


Connector Pane

TINewTI


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

TIHandle 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.