Monkeybread Software - MBS FileMaker Plugin: Dictionary.AddSQLRecord

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 9.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 10.6 Statistic FMM Blog

Dictionary.AddSQLRecord

Adds values from a record to dictionary via SQL.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
Dictionary FMSQL	7.4	Yes	Yes	Yes	Yes	Yes

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

Parameters

Parameter Description Example Flags

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. "FirstName¶LastName¶Company"

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, pass here parameters. One parameter to this function for each parameter you want to pass to the SQL statement. 123 Optional

Parameter	Description	Example	Flags
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.	"FirstName¶LastName¶Company"
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, pass here parameters. One parameter to this function for each parameter you want to pass to the SQL statement.	123	Optional

Result

Returns OK or error.

Description

Adds values from a record to dictionary via SQL.
From the result set, the first record is used for values and given key list for the keys.
Returns error in case of SQL error with error message.
As we only use first record, you can use FETCH FIRST 1 ROWS ONLY in the SQL command to only query first record.

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

Examples

Query record and get JSON:

Set Variable [ $dic ; Value: MBS("Dictionary.Create") ]
Set Variable [ $r ; Value: MBS( "Dictionary.AddSQLRecord"; $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 ) ]

Blog Entries

MBS FileMaker Plugin, version 7.4pr8

Release notes

Version 7.4
- Added Dictionary.AddSQLRecord(s) function.

Created 21st September 2017, last changed 20th February 2018

Dictionary.AddSQL - Dictionary.AddSQLRecords

Feedback: Report problem or ask question.