Functions Reference

Chapter 4
|
Design functions 43
DatabaseNames
Format
DatabaseNames
Parameter
None
Data type returned
text
Description
Returns a list of the names of all database files open on the computer, separated by
carriage returns. The names do not include file extensions.
Note If your database is hosted on another computer, DatabaseNames returns a list of
the names of local client and remote database files open only on the client computer.
Example
To determine whether “Customers” is one of the files currently open, use the
DatabaseNames function with the Position function in the formula:
Position(DatabaseNames;”Customers”;1;1). If the formula returns a value
greater than 0, then Customers is open.
FieldBounds
Format
FieldBounds(fileName;layoutName;fieldName)
Parameters
fileName - the name of an open database file
(local or remote).
layoutName - the name of a layout
in the specified database file.
fieldName - the name of a field
on the specified layout.
Important See “Design functions” on page 41 for information about literal text parameters.
Data type returned
text