SQL.Prepare
-----------

Validates and prepares the current command for execution.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [SQL](component_SQL.md) | [2.6](newinversion26.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "SQL.Prepare"; Command ) 

**MBS**( **"SQL.Prepare";** /\* Validates and prepares the current command for execution. \*/  
**$Command**) /\* The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). | $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

- [SQL.NewCommand](SQLNewCommand.md)

This function is free to use.

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

  
[SQL.ParamCount](SQLParamCount.md) - [SQL.ResetCommand](SQLResetCommand.md)

[HTML Version](SQLPrepare.shtml)