Functions Reference

Chapter 7
|
Get functions 105
Example
Returns 0 if the record has not been modified since it was created.
If changes are made to four fields and all four fields are committed together, the result
increments by one. If changes are made to four fields and each change is committed
separately, the result increments by four.
Get(RecordNumber)
Format
Get(RecordNumber)
Parameter
None
Data type returned
number
Description
Returns the number of the current record in the current found set. This value is determined
by the relative place of the record in the found set, and changes depending on the find
criteria and the sort order.
Notes
• To return a value that uniquely and permanently identifies a record in this table, use
Get(RecordID).
• If you specify the context for the current calculation, this function will be evaluated
based on that context; otherwise, it will be evaluated based on the context of the
current window.
• See FileMaker Pro help for information about running scripts in client/server and
peer-to-peer environments.
Example
Returns 3 when the current record is the third record in a found set.
Get(RecordOpenCount)
Format
Get(RecordOpenCount)
Parameter
None