Functions Reference

Chapter 4
|
Design functions 47
ScriptNames
Format
ScriptNames(fileName)
Parameter
fileName - the name of an open database file (local or remote).
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
text
Description
Returns a list of the names of all scripts in fileName, separated by carriage returns.
Example
ScriptNames(“Customers”) returns a list of all the scripts in the Customers database file.
TableIDs
Format
TableIDs(fileName)
Parameter
fileName - the name of an open database file (local or remote).
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
text
Description
Returns a list of all table IDs in fileName, separated by carriage returns.
Note Each table ID is unique. Also, the ID is independent of when you create each table:
the first table could have the smallest, middle, or largest value.
Example
TableIDs(“University Database”) returns
1065089
1065090
for the University Database database file if two tables have been defined for the file.