Prepares the supplied SQL string

Syntax

a_sqlany_stmt * sqlany_prepare( a_sqlany_connection * conn, const char * sql )

Parameters

Returns

A handle to a SQL Anywhere statement object.

Remarks

The statement associated with the statement object is executed by sqlany_execute. You can use sqlany_free_stmt to free the resources associated with the statement object.

See also

• sqlany_execute function
• sqlany_free_stmt function
• sqlany_num_params function
• sqlany_describe_bind_param function
• sqlany_bind_param function

Example

char * str;
a_sqlany_stmt * stmt;

str = "select * from employees where salary >= ?";
stmt = sqlany_prepare( conn, str );
if( stmt == NULL ) {
    // Failed to prepare statement, call sqlany_error() for more info
}