FileMaker 系统内提供了大量的函数,其中有一大类称为 Design,顾名思义就是设计用函数。
官方的说法:
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.
也就是说,Design funciton 是用于提取数据库设计信息的工具。这对于快速获取一个不熟悉的数据库非常有用。我们甚至可以使用数据库保存这些函数返回的信息,用于追踪数据库设计的变化或撰写开发日志,乃至开发完整的 FileMaker 开发日志系统。
我们先来看看这类函数都有哪些。
DatabaseNames: A list of the names of all files open on the computer.
FieldBounds: The location, in points, of each field boundary and the field’s rotation in degrees.
FieldComment: The specified field’s comment.
FieldIDs: A list of all field IDs in fileName and layoutName.
FieldNames: A list of the names of all fields on layoutName in fileName.
FieldRepetitions: The number and orientation of repetitions of a repeating field as formatted on a layout.
FieldStyle: The field formatting applied to fieldName on layoutName in fileName.
FieldType: Information about fieldName.
GetNextSerialValue: The next serial number of fieldName in fileName.
LayoutIDs: A list of all layout IDs in fileName.
LayoutNames: A list of the names of all layouts in fileName.
LayoutObjectNames: A list of the names of all named objects on layoutName in fileName.
RelationInfo: A list of four values for each relationship directly related to tableName.
ScriptIDs: A list of all script IDs in fileName.
ScriptNames: A list of the names of all scripts in fileName.
TableIDs: A list of all table IDs in fileName.
TableNames: A list of all table occurrences in the relationships graph for fileName.
Get(LayoutTableName)
1 | /* copyright Ulf Carlsson, ulf.carlsson@studentlitteratur.se, free to use if this row is here |