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: 8.0   8.1   8.2   8.3   8.4   8.5   9.0   9.1   9.2   9.3    Statistic  


Validates and prepares the current command for execution.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
SQL 2.6 Yes Yes Yes Yes Yes
MBS( "SQL.Prepare"; Command )   More


Parameter Description Example value
Command The command reference number gained with SQL.NewCommand. $Command


Returns "OK" or error message.


Validates and prepares the current command for execution.
Prepare method compiles the command, but does not execute it. The method detects syntax errors in command text and verifies the existence of database objects.

Execute method calls Prepare method implicitly if needed, therefore you don't have to call it explicitly.

See also

Created 18th August 2014, last changed 13th January 2015

SQL.ParamCount   -   SQL.ResetCommand

Feedback: Report problem or ask question.

MBS FileMaker Plugins