Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
Adds values from a record to dictionary via SQL.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
Dictionary FMSQL | 7.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
DictionaryRef | The reference number to the dictionary. | $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... | Pass here parameters. One parameter to this function for each parameter you want to pass to the SQL statement. |
123 | Optional |
Returns OK or error.
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 ) ]
This function checks for a license.
Created 21st September 2017, last changed 5th June 2021