| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Component: Dictionary
Key/Value map to store values. An assoziative array preserving data types.
| Version | macOS | Windows | Linux | Server | iOS SDK |
| 5.0 / 14.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
| Item | Details |
|---|---|
| CF New in 14.1 Shorter version for FM.CF. | All 14.1 |
| Dictionary.AddDictionary Adds entries from other dictionary to current one. | All 11.1 |
| Dictionary.AddSQL Adds values to a dictionary via SQL. | All 5.1 |
| Dictionary.AddSQLRecord Adds values from a record to dictionary via SQL. | All 7.4 |
| Dictionary.AddSQLRecords Adds values from a record to dictionary via SQL. | All 7.4 |
| Dictionary.Clear Clears the dictionary content. | All 5.0 |
| Dictionary.Clone Creates a copy of the dictionary. | All 6.1 |
| Dictionary.Count Returns number of keys in the dictionary. | All 5.0 |
| Dictionary.Create Creates a new dictionary. | All 5.0 |
| Dictionary.CreateNamed Creates a new dictionary with desired key. | All 8.1 |
| Dictionary.Deserialize Restores a serialized dictionary. | All 5.2 |
| Dictionary.FromJSON Creates dictionary from JSON. | All 11.1 |
| Dictionary.HasKey Checks if the given key exists in dictionary. | All 5.0 |
| Dictionary.HasKeys New in 14.2 Checks if the given keys exist in dictionary. | All 14.2 |
| Dictionary.KeyAtIndex Returns key with given index. | All 5.0 |
| Dictionary.Keys Returns list with all keys. | All 5.0 |
| Dictionary.KeysWithPostfix Returns list with all keys matching postfix. | All 11.4 |
| Dictionary.KeysWithPrefix Returns list with all keys matching prefix. | All 11.4 |
| Dictionary.List Returns list of all dictionary IDs. | All 5.2 |
| Dictionary.Lookup Looks up value for the key. | All 12.1 |
| Dictionary.Release Releases dictionary and all memory used. | All 5.0 |
| Dictionary.ReleaseAll Releases all dictionaries. | All 10.5 |
| Dictionary.RemoveKey Removes value with given key. | All 5.0 |
| Dictionary.Serialize Serialized a dictionary as a text. | All 5.2 |
| Dictionary.SetList Fills dictionary with keys and values form a list. | All 6.2 |
| Dictionary.SetQuickList Fills dictionary with keys and values form a quick list. | All 7.1 |
| Dictionary.SetValueForKey Stores value for given key. | All 5.0 |
| Dictionary.SetVariables Creates variables with given keys and values from dictionary. | All 5.1 |
| Dictionary.ToJSON Returns JSON representation of dictionary for data exchange. | All 6.1 |
| Dictionary.ToMatrix Converts dictionary to a matrix. | All 13.2 |
| Dictionary.ToText Returns text representation of dictionary for data exchange. | All 6.1 |
| Dictionary.ToXML Returns XML representation of dictionary for data exchange. | All 6.1 |
| Dictionary.ValueForKey Queries value for the key. | All 5.0 |
| Dictionary.ValueTypeForKey Queries data type of the value for the key. | All 5.1 |
| Dictionary.Values Returns list with all values as text. | All 5.1 |
| FM.CF Calls a custom function given the name with FileMaker values. | All 11.3 |
36 functions shown.
These functions require a license (92%).
Release notes
- Version 13.2
- Added Dictionary.ToMatrix function.
- Added root name parameter to Dictionary.ToXML function.
- Fixed a possible memory leak in Dictionary.AddSQL function.
- Version 12.1
- Added Dictionary.Lookup function.
- Version 12.0
- Fixed JSON functions to return NULL for numbers with no content, e.g. empty text. This affects JSON.CreateNumber, Dictionary.ToJSON, FM.SQL.JSONColumn, FM.SQL.JSONRecord and FM.SQL.JSONRecords functions.
- Version 11.4
- Added Dictionary.KeysWithPostfix and Dictionary.KeysWithPrefix functions.
- Improved Dictionary.SetVariables to not allow invalid variable names.
- Version 11.3
- Added FM.CF function to run custom functions defined in a database table and managed via Dictionary functions.
- Version 11.1
- Added Dictionary.AddDictionary and Dictionary.FromJSON functions.
- Version 11.0
- Fixed issue with FM.SQL.JSONRecord, FM.SQL.JSONRecords and Dictionary.ToJSON where long numbers where truncated to double precision.
- Version 10.5
- Added AVExport.ReleaseAll, AVRecorder.ReleaseAll, CoreML.ReleaseAll, DNSLookup.ReleaseAll, Dictionary.ReleaseAll, FM.SQL.ReleaseAll, JS.ReleaseAll, JavaScript.ReleaseAll, LDAP.ReleaseAll, PDFKit.ReleaseAll, PKCS12.ReleaseAll, PKCS7.ReleaseAll, PKey.ReleaseAll, SSH.ReleaseAll, WinSendMail.ReleaseAll, WindowsML.ReleaseAll, WordFile.ReleaseAll, and X509.ReleaseAll.
- Version 8.2
- Fixed Dictionary.Deserialize to decode empty timestamps and dates as empty values instead of 00/00/0000.
Blog Entries
- New in MBS FileMaker Plugin 12.1
- MBS FileMaker Plugin, version 11.3pr3
- MBS FileMaker Plugin 11.1
- MBS FileMaker Plugin v8.1 with 5100 Functions In One Plugin
- MBS FileMaker Plugin 8.1
- Data structures in FileMaker with MBS Plugins
- The power of global variables
- MBS FileMaker Plug-in 6.1 for OS X/Windows
- SQLite in memory databases
- MBS FileMaker Plugin 5.1 for OS X/Windows
FileMaker Magazin
Example Databases
