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  

SQL.Prepare

Validates and prepares the current command for execution.

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

Parameters

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

Result

Returns "OK" or error message.

Description

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.



Links
MBS Xojo Plugins

Start Chat