SQLTableAndField ( ) Quote a table and field name for use in a FileMaker SQL statement. Prevent hard-coding it's value.

Posted 8 February 2015      Rating 0.0     0 Comments

SQLTimestamp ( ) Convert a timestamp for use in an SQL Query.

Posted 8 February 2013      Rating 0.0     0 Comments

SQLTime ( ) Convert a time for use in an SQL Query.

Posted 8 February 2013      Rating 0.0     0 Comments

SQLQuote ( ) Wrap text in single quotes, for use with SQL queries. The purpose of the Substitute is to "escape" any internally embedded apostrophes, e.g., O'Malley becomes 'O''Malley', which SQL will convert into O'Malley

Posted 8 February 2013      Rating 0.0     0 Comments

SQLField ( ) Quote a field name for use in a FileMaker SQL statement. Prevent hard-coding it's value.

Posted 8 February 2013      Rating 0.0     0 Comments

+ View all