Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.4   7.5   8.0   8.1   8.2   8.3   8.4   8.5   9.0   9.1    Statistic  


Adds items via SQL statement.

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


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


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.


Add items:

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

Blog Entries

Created 21st March 2015, last changed 12nd August 2016

ListDialog.AddItemsToList   -   ListDialog.ClearList

Feedback: Report problem or ask question.

MBS FileMaker blog