Monkeybread Software - MBS FileMaker Plugin: QuickList.AddSQL

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

QuickList.AddSQL

Adds values to a quick list via SQL.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
List	5.1	Yes	Yes	Yes	Yes	Yes

MBS( "QuickList.AddSQL"; ListRef; SQL Statement; FileName { ; Params } ) More

Parameters

Parameter Description Example Flags

ListRef The reference to the list returned from QuickList.New function. $List

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

Parameter	Description	Example	Flags
ListRef	The reference to the list returned from QuickList.New function.	$List
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 values to a quick list via SQL.
All values in the result set are added as text to the list.
Returns error in case of SQL error with error message.

This function is currently only supported for FileMaker 11 and newer. If you need it for older versions, please contact us.

Examples

Fill a list and return it:

# create new list
$list = MBS("QuickList.New")
# add values via SQL
MBS("QuickList.AddSQL"; $list; "SELECT TextField FROM \"Test Table\"")
# query list content for displaying
$text = MBS("QuickList.GetList"; $list)
# and free it
MBS("QuickList.Free"; $list )

Add values based on SQL query in current file and one parameter:

MBS("QuickList.AddSQL"; "12002"; "SELECT TextField FROM \"Test Table\" WHERE NumberField>?"; Get(Filename); 1 )

Run query with quoted names and parameters for value:

Set Variable [ $Text ; Value: MBS("QuickList.AddSQL"; $ListNum; "SELECT \"MyField\" from \"MyTable\" Where \"SomeField\" = ?"; Get(FileName); "xyz") ]

Blog Entries

MBS FileMaker Plugin, version 5.1pr1

Created 12nd March 2015, last changed 17th June 2018

QuickList.AddQuickList - QuickList.AddValue