Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5   8.0    Statistic  


Adds values from a record to dictionary via SQL.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
Dictionary 7.4 Yes Yes Yes Yes Yes

MBS( "Dictionary.AddSQLRecords"; DictionaryRef; Keys; SQL Statement; FileName { ; Params } )


Parameter Description Example value
DictionaryRef The reference number to the dictionary as returned by Dictionary.Create function. $dic
Keys The list of keys for the dictionary.
Could be the same as the field list.
SQL Statement SQL Statement as a Text string
FileName The target database name. Can be empty to not limit query to one database. ""
Params Optional
Optional, pass here parameters. One parameter to this function for each parameter you want to pass to the SQL statement.


Returns OK or error.


Adds values from a record to dictionary via SQL.
From the result set, the records are used for values and given key list for the keys.
If you have multiple records, you get all values collected per field in a list.
Returns error in case of SQL error with error message.

This function is currently only supported for FileMaker 11 and newer. If you need it for older versions, please contact us.


Query record and get JSON:

Set Variable [ $dic ; Value: MBS("Dictionary.Create") ]
Set Variable [ $r ; Value: MBS( "Dictionary.AddSQLRecords"; $dic; "Vorname¶Nachname¶Firma"; "SELECT Vorname, Nachname, Firma FROM Kontakte"; "Kontakte") ]
Set Variable [ $json ; Value: MBS( "Dictionary.ToJSON"; $dic ) ]
Set Variable [ $r ; Value: MBS( "Dictionary.Release"; $dic ) ]

See also

Dictionary.AddSQLRecord   -   Dictionary.Clear

Feedback: Report problem or ask question.

MBS FileMaker Plugins