Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Adds items via SQL statement.

Component Version macOS Windows Linux Server iOS SDK
ListDialog 5.1 ✅ Yes ✅ Yes ❌ No ❌ No ❌ No
MBS( "ListDialog.AddSQL"; SQL Statement; FileName { ; Params... } )   More


Parameter Description Example Flags
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 number of items added or error.


Adds items via SQL statement.
First field from SQL result is used as text, second as tag and third as header flag.
Tag and header columns are optional.

This function takes variable number of parameters. Pass as much parameters as needed separated by the semicolon in FileMaker.
Please repeat Params parameter as often as you need.


Add items:

MBS("ListDialog.AddSQL"; "select Text, Tag, Header from Liste")

Blog Entries

This function checks for a license.

Created 21st March 2015, last changed 5th June 2021

ListDialog.AddItemsToList - ListDialog.ClearColumnHeaders