Functions in order of    date added  function name  comments  rating

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

Helps building naming independent sql queries using # wildcards.

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

sql.in.clause ( _list ; _dataType )

Builds the IN clause of a SELECT query

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

sql2FM.dataType ( _type ; _data )

Translates SQL data into FileMaker

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

fm2sql.dataType ( _data ; _type )

Translates FileMaker Data into SQL

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

time.DaylightSavings ( _countryCode ; _timeStamp ; _stateCode )

Type of result: boolean True if the timestamp is during daylight savings, False otherwise. Parameters: _timeStamp : if not defined, current host timestamp will be used. _countryCode : the ISO short code (2 letters) _stateCode (only for countries with

    By Fabrice   (0 comments Posted 29 September 2013   Rating:  unrated

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

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

text.trim ( _text )

Removes leading and trailing carriage returns, line feeds, vertical tabs, blanks...

    By Fabrice   (5 comments Posted 20 April 2013   Rating:  5.0

FindIndex ( _value ; _array ; _startIndex ; _occurrence )

Finds the index of the value in the array

    By Andries Heylen   (2 comments Posted 29 March 2013   Rating:  4.0

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

FieldAndContentList ( TagValue ; TagField ; NotContain ; Contain ; AddFieldList ; TypeField ; EmptyValue )

returns field names and contents of all the field are on a layout (repeatingField and related records included)

    By Agnès   (0 comments Posted 12 March 2013   Rating:  unrated

SqlNumber ( number )

Convert a filemaker number-value into a SQL-numbervalue

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

TrimAll_CR ( Text )

All redundant returns will be removed. Leading, trailing and the extra ones between lines.

    By menno   (0 comments Posted 25 February 2013   Rating:  unrated

Trim_CR ( Text )

Remove redundant leading and trailing carrige-returns

    By menno   (0 comments Posted 25 February 2013   Rating:  unrated

WeekFiscalToDate ( Firstweekday ; WeeknrOfYear ; Yearnr )

Calculate date from the given fiscal weeknumber in the given year at the given Firstweekday

    By menno   (0 comments Posted 25 February 2013   Rating:  unrated

 

« Previous 1 2 3 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)