Functions Reference

Chapter 4
|
Design functions 35
Chapter 4
Design functions
Design functions return information about the structure of open database files. For
example, you could determine the names of all the layouts or fields in an open database
file.
Note FileMaker Pro limits the information returned by a design function, according to the
privilege set in effect when the function evaluates a database file. See FileMaker Pro Help
for more information about granting access to database files.
Design function parameters can be any of the following:
• filenames such as "Customer" or literal text such as "Jack"
• field such as layoutName
• other functions such as Left(text;number)
Important Literal text parameters such as filenames and layout names must be enclosed
in quotation marks. Use quotation marks around field names to indicate the literal string
is the parameter (omit quotation marks to indicate the value stored in the field is the
parameter). You can use spaces before or after the parentheses that enclose parameters,
but spaces are not necessary. Use a semicolon between parameters when a function
requires more than one parameter.
Click a function name for details.
This function Returns
DatabaseNames,
page 36
A list of the names of all database files open on the computer (including files
opened as a client
), separated by carriage returns.
FieldBounds, page
37
The location of each side of the specified field and its rotation in degrees.
FieldComment,
page 38
The specified field’s comment.
FieldIDs, page 39 A list of all field IDs in the specified database file and layout, separated by carriage
returns.
FieldNames, page
39
A list of the names of all fields on the specified layout, separated by carriage
returns.
FieldRepetitions,
page 40
The number of repetitions of the specified field as it is formatted on the specified
layout (which could be different from the number of repetitions specified when the
field was defined), and the orientation of the field repetitions (horizontal or vertical)
on the layout.
FieldStyle, page 41 The formatting applied to the specified field on the specified layout.
FieldType, page 41 Information about the specified field.
GetNextSerialValue,
page 42
The next serial number for the specified field in the specified database file.
LayoutIDs, page 43 A list of all layout IDs in the specified database file, separated by carriage returns.