Returns the base table name of a table occurrence
returns a list of full filed names in all tables of the current file, starting with the _begin.string and omitting field beginning with one of the values in _omit.string.list
Returns table occurrence information as XML
Returns a list of table occurrences with 1 item per Base table
Translates FileMaker Data into SQL
Returns date parsed from text in the format of "YYYY-MM-DD".
returns the list of 'ancestors' or 'descendents' in a recursive data structure (tree view)
Returns list of all Field Names for all LOCAL Tables in the current FileMaker Pro v12 file.
Helps you to debug your sql function in the data viewer
Gets the name of a field from a fully-qualified field object.
Gets the name of a table from a fully-qualified field object. Useful for protecting against field renaming.
Builds the IN clause of a SELECT query
makes writing a _VERY_ simple and standard sql query easier and naming independent.
Helps building naming independent sql queries using # wildcards.
converts a Timestamp returned by ExecuteSQL function (type text) into a valid FileMaker date.