Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is table a part of DBC
Message
De
20/01/1999 01:12:53
 
 
À
19/01/1999 22:23:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00177878
Message ID:
00177892
Vues:
36
Places the names of named connections, relations, tables, or SQL views in the current database into a variable array.

Syntax

ADBOBJECTS(ArrayName, cSetting)

Returns

Numeric

Arguments

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.

Remarks

A database must be open and current when ADBOBJECTS( ) is issued; otherwise Visual FoxPro generates an error message.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform