ADBOBJECTS( ) Function

JavaScript Editor js editor     Web development 



Main Page

Places the names of named connections, relations, tables, or SQL views in the current database into a variable array.

ADBOBJECTS(ArrayName, cSetting)

Parameters

ArrayName


Specifies the name of the array in which the names are placed. If the array you specify doesn't exist, Visual FoxPro automatically creates the array. If the array exists and isn't large enough to contain all the names, Visual FoxPro automatically increases the size of the array to accommodate the names. If the array is larger than necessary, Visual FoxPro truncates the array. If the array exists and ADBOBJECTS(В ) returns 0 because no names are found, the array remains unchanged. If the array doesn't exist, and ADBOBJECTS(В ) returns 0, the array is not created. A one-dimensional array is created when you specify CONNECTION, TABLE, or VIEW for cSetting. Each row in the one-dimensional array contains the name of a connection, table, or view in the database. A two-dimensional array is created when you specify RELATION for cSetting. Each row in the two-dimensional array corresponds to a relationship in the database. The first column in an array row contains the name of the child table and the second column in an array row contains the name of the parent table. The third column contains the name of the index tag for the child table and the fourth column contains the name of the index tag for the parent table. The fifth column in an array row contains referential integrity information. This column is empty if the relation has no referential integrity rules. If the relationship does have referential integrity rules, the column contains characters corresponding to the type of referential integrity rules for updates, deletions, and insertions. The first character indicates the type of update rule, the second character indicates the type of deletion rule, and the third character indicates the type of insertion rule. Possible values for updates and deletions are "C" for cascade, "R" for restrict, and "I" for ignore. Possible values for insertions are "R" for restrict, and "I" for ignore. For example, if a relation has cascaded updates, restricted deletions, and ignores insertion referential integrity rules, the column contains "CRI".
cSetting


Specifies the names to place in the variable array. The following table lists the values for cSetting and the corresponding names placed in the array:

cSetting Names

CONNECTION

Connection names

RELATION

Table relationships

TABLE

Table names

VIEW

View names

The CONNECTION, RELATION, TABLE, and VIEW settings cannot be abbreviated.

Return Value

Numeric

Remarks

A database must be open and current when ADBOBJECTS(В ) is issued; otherwise Visual FoxPro generates an error message.

Example

The following example opens the testdata database and uses ADBOBJECTS(В ) to create an array named gaTables containing names of tables in the database. The tables names are then displayed.

В Copy Code
* Close any open databases
CLOSE DATABASES

* Clear desktop to prepare for displaying the array
CLEAR

* Open sample testdata database
OPEN DATABASE (HOME(2) + 'Data\testdata')

* Function call with cSetting for table names
=ADBOBJECTS(gaTables, "TABLE")

* Displays array gaTables created by ADBOBJECTS( ) function
DISPLAY MEMORY LIKE gaTables

See Also



JavaScript Editor js editor     Web development