Returns the file name extension or file suffix for the active version of FileMaker Pro or FileMaker Pro Advanced
Retrieve the index of the matching valueString in the valueList with optional case-sensitivity and occurrence restrictions.
Helps you to debug your sql function in the data viewer
Add years, months and/or days values to a source date to get a new date.
converts a Timestamp returned by ExecuteSQL function (type text) into a valid FileMaker date.
Returns list of all unique underlying Base Tables for all Table Occurrences in the current FileMaker Pro v12 file
Returns the English description for the error number returned by the Get(LastError) function. Updated for FileMaker Pro v12.
return valid date as number of days since 0001-01-01 or nothing if invalid
makes writing a _VERY_ simple and standard sql query easier and naming independent.
Returns the base table name of a table occurrence
Returns table occurrence information as XML
Converts : - an Excel column header into a number (BR -> 70) - a number into an Excel column header (70 -> BR) Limited to ZZ (702)
A generic way to exit (nested) loops
Clears all variables declared by xml2var.
Last ID obtained from value list