Displaying all functions tagged with sql

FM.baseTable ( _tableName )

Returns the base table name of a table occurrence

    By Fabrice   (0 comments Posted 5 April 2012   Rating:  unrated
    Tag:    sql

fm.field.list ( _omit.string.list ; _begin.string.list )

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

    By Fabrice   (0 comments Posted 30 August 2013   Rating:  unrated
    Tag:    Sql

FM.table.info ( _tableName )

Returns table occurrence information as XML

    By Fabrice   (0 comments Posted 5 April 2012   Rating:  unrated
    Tag:    sql

fm.table.list.unique

Returns a list of table occurrences with 1 item per Base table

    By Fabrice   (0 comments Posted 19 July 2013   Rating:  unrated
    Tag:    sql

fm2sql.dataType ( _data ; _type )

Translates FileMaker Data into SQL

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

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

hierarchy ( _id.list ; _primaryKey ; _parentKey ; _direction ; _numberOfLevels )

returns the list of 'ancestors' or 'descendents' in a recursive data structure (tree view)

    By Fabrice   (0 comments Posted 27 March 2013   Rating:  5.0
    Tag:    Sql

ListLocalFQFieldNames

Returns list of all Field Names for all LOCAL Tables in the current FileMaker Pro v12 file.

    By Kris Musshorn   (0 comments Posted 11 February 2015   Rating:  unrated
    Tag:    SQL

sql.debug ( _executeSQL )

Helps you to debug your sql function in the data viewer

    By Andries Heylen   (8 comments Posted 28 July 2012   Rating:  5.0
    Tag:    Sql

sql.getField ( fullyQualifiedFieldObject )

Gets the name of a field from a fully-qualified field object.

    By Cristos L-C   (0 comments Posted 25 February 2016   Rating:  unrated
    Tag:    sql

sql.getTable ( fullyQualfieidFieldObject )

Gets the name of a table from a fully-qualified field object. Useful for protecting against field renaming.

    By Cristos L-C   (0 comments Posted 25 February 2016   Rating:  unrated
    Tag:    sql

sql.in.clause ( _list ; _dataType )

Builds the IN clause of a SELECT query

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

sql.match ( _match ; _matchFieldName ; _requestedFieldName )

makes writing a _VERY_ simple and standard sql query easier and naming independent.

    By Fabrice   (0 comments Posted 11 April 2012   Rating:  unrated
    Tag:    Sql

sql.query.builder ( _query ; _param.list )

Helps building naming independent sql queries using # wildcards.

    By Fabrice   (0 comments Posted 5 December 2013   Rating:  unrated
    Tag:    Sql

sql.ts2FMdate ( _TS )

converts a Timestamp returned by ExecuteSQL function (type text) into a valid FileMaker date.

    By Fabrice   (0 comments Posted 4 May 2012   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)