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:
10.1
10.2
10.3
10.4
10.5
11.0
11.1
11.2
11.3
11.4
Statistic
FMM
Blog
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... | Optional, 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.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 ) ]
Created 23th September 2017, last changed 5th June 2021
Dictionary.AddSQLRecord - Dictionary.Clear
Feedback: Report problem or ask question.