Displaying all functions tagged with sql

sql2FM.dataType ( _type ; _data )

Translates SQL data into FileMaker

    By Fabrice   (0 comments Posted 30 September 2013   Rating:  5.0
    Tag:    Sql

SQLDate ( theDate )

Convert a date for use in an SQL Query.

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

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
    Tag:    Sql

SqlNumber ( number )

Convert a filemaker number-value into a SQL-numbervalue

    By menno   (0 comments Posted 25 February 2013   Rating:  5.0
    Tag:    Sql

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
    Tag:    Sql

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
    Tag:    Sql

SQLTime ( theTime )

Convert a time for use in an SQL Query.

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

 

« Previous 1 2 Next »

 

 

 

 

 

 

Top Tags

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

 

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