SQLPrepareStatement() function

The SQLPrepareStatement() function prepares the SQL statement to be run. It does not run the statement, it just makes the statement active so you can set parameter values.

Category

SQL

Syntax

SQLPrepareStatement(ConnectionId, StatementID)

Arguments

ConnectionID

Name of a memory integer tag that holds the number (ID) assigned by the SQLConnect() function to each database connection.

Remarks

Prepare the default statement and return a StatementID (1, 2, 3, and so on). This preparation is useful for statements with parameters that need to be set using the SQLSetParam{Type} functions.