Monkeybread Software - MBS Filemaker Plugin: FM.ExecuteSQLOnIdle

All functions Mac OS X Windows Crossplatform Components New in version: 1.0 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 2.0

FM.ExecuteSQLOnIdle

Component: FM
Mac OS X: Works
Windows: Works

MBS( "FM.ExecuteSQLOnIdle" ; SQL Statement; Column Delimiter; Record Delimiter )

Parameters

Parameter Description Example value

SQL Statement the SQL statement

Column Delimiter Optional column delimiter

Record Delimiter Optional record delimiter

Parameter	Description	Example value
SQL Statement	the SQL statement
Column Delimiter	Optional column delimiter
Record Delimiter	Optional record delimiter

Description

This is similar to ExecuteSQL, except that it waits until idle to execute. See the other function for more info
Seems like on Filemaker 11 you get LastError 8310 if you use fields with underscore in the name. You avoid that by placing the field names in quotes.

Feedback: Report problem or ask question.

Links
MBS Realbasic tutorial videos - Pfarrgemeinde Ministranten Nickenich