Functions in order of    date added  function name  comments  rating

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

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

SQLDate ( theDate )

Convert a date for use in an SQL Query.

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

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

DoubleInList ( _values )

Returns values existing more than once in a list

    By Tanguy Colles   (5 comments Posted 22 November 2012   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

setDocumentPath ( filename ; extension )

Gets de documents path for Mac and PC

    By Diego D'Alessio (solfilemaker)   (0 comments Posted 20 October 2012   Rating:  unrated

CompletionDate ( StartDate ; WorkingDays ; HolidayList )

Returns a date that is "n" working days from StartDate.

    By Daniele Raybaudi   (2 comments Posted 14 October 2012   Rating:  unrated

FileMakerFileFormat

Returns the file name extension or file suffix for the active version of FileMaker Pro or FileMaker Pro Advanced

    By DamonCasey   (0 comments Posted 20 September 2012   Rating:  unrated

GetValueIndex ( valueList ; valueString ; matchCase ; occurrence )

Retrieve the index of the matching valueString in the valueList with optional case-sensitivity and occurrence restrictions.

    By Lewis Lorenz   (0 comments Posted 4 August 2012   Rating:  unrated

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

DateCalculation ( Days ; Months ; Years ; From )

Add years, months and/or days values to a source date to get a new date.

    By dawolfe   (1 comments Posted 3 July 2012   Rating:  unrated

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

ListBaseTables

Returns list of all unique underlying Base Tables for all Table Occurrences in the current FileMaker Pro v12 file

    By Andrew Duncan   (0 comments Posted 3 May 2012   Rating:  unrated

ErrorDescription ( errorNumber )

Returns the English description for the error number returned by the Get(LastError) function. Updated for FileMaker Pro v12.

    By Andrew Duncan   (0 comments Posted 3 May 2012   Rating:  unrated

 

« Previous 1 2 ... 4 5 6 7 8 ... 21 22 Next »

 

 

 

 

 

 

Top Tags

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

 

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