ADBObjects()
This function is really a whole bunch of different functions in one. It creates an array containing information about a database, but there are four different types of information that can be put in the array: tables, views, connections or relations. Unlike other functions returning status information, ADBObjects() only works on the current database; you can't tell it which database to look at. Usage | nObjectCount = ADBOBJECTS( ArrayName, cInfoType ) |
Parameter | Value | Meaning |
ArrayName | Name | The array into which database information is dumped. |
cInfoType | "TABLE" | Put a list of tables in the database into the array. |
"VIEW" | Put a list of views in the database into the array. | |
"CONNECTION" | Put a list of named connections in the database into the array. | |
"RELATION" | Put a list of persistent relations in the database into the array. | |
nObjectCount | Positive number | The number of rows in the array (= the number of items of the specified type). |
0 | No items of the specified type were found. |
Column | Meaning |
1 | Child table. |
2 | Parent table. |
3 | The tag the relation is based on in the child table. |
4 | The tag the relation is based on in the parent table. |
5 | The referential integrity constraints on the relation in the order Update, Delete, Insert. For each type of integrity, there are three possible values: |
Example | OPEN DATABASE TasTrade * create arrays of tables, views, connections, and relations nTableCount = ADBObjects(aTables,"Table") nViewCount = ADBObjects(aViews,"View") nConnCount = ADBObjects(aConns,"Connection") nRelCount = ADBObjects(aRels,"Relation") * now look at all the info DISPLAY MEMORY LIKE a* |
See Also | ADatabases(), Array Manipulation, DBGetProp(), Key(), Open Database, Relation(), Set Database, Tag(), Target() |
View Updates
Copyright © 2002 by Tamar E. Granor, Ted Roche, Doug Hennig, and Della Martin. All Rights Reserved.