Displaying functions by Daniel Smith

GetAsSqlDate ( dateFromSqlResult )

Returns date parsed from text in the format of "YYYY-MM-DD".

    By Daniel Smith   (0 comments Posted 6 December 2012   Rating:  5.0

SQLDate ( theDate )

Convert a date for use in an SQL Query.

    By Daniel Smith   (0 comments Posted 6 February 2013   Rating:  unrated

SQLField ( fieldOrFieldName )

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

    By Daniel Smith   (0 comments Posted 8 February 2013   Rating:  unrated

SQLQuote ( text )

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

    By Daniel Smith   (0 comments Posted 8 February 2013   Rating:  unrated

SQLTable ( fieldForTableNameOrTableName )

Quote a table name for use in a FileMaker SQL statement. Prevent hard-coding it's value.

    By Daniel Smith   (0 comments Posted 14 November 2012   Rating:  unrated

SQLTableAndField ( fieldForTableNameOrTableName )

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

    By Daniel Smith   (0 comments Posted 8 February 2015   Rating:  unrated

SQLTime ( theTime )

Convert a time for use in an SQL Query.

    By Daniel Smith   (0 comments Posted 8 February 2013   Rating:  unrated

SQLTimestamp ( theTimestamp )

Convert a timestamp for use in an SQL Query.

    By Daniel Smith   (0 comments Posted 8 February 2013   Rating:  unrated

 

 

 

 

 

 

 

Top Tags

Text Parsing  (33)
List  (32)
Date  (28)
XML  (26)
Format  (23)
Sql  (22)
Dev  (20)
Debug  (17)

 

Layout  (15)
Interface  (15)
Text  (14)
Filter  (12)
Variables  (12)
Layout Objects  (11)
Design  (10)
Array  (8)