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:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
10.6
Statistic
FMM
Blog
ListDialog.AddSQL
Adds items via SQL statement.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| ListDialog | 5.1 | Yes | Yes | No | No | No |
MBS( "ListDialog.AddSQL"; SQL Statement; FileName { ; Params } ) More
Parameters
| 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 |
Result
Returns number of items added or error.
Description
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.
Examples
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.ClearColumnHeaders
Feedback: Report problem or ask question.
Links
MBS Xojo blog
