Prepares the supplied SQL string.
sqlany_prepare ( $conn, $sql )
$conn A connection object with a connection established using sqlany_connect.
$sql The SQL statement to be prepared.
Returns a scalar value that is the statement object, or nil on failure.
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.
stmt = api.sqlany_prepare(conn, "UPDATE Contacts SET Contacts.ID = Contacts.ID + 1000 WHERE Contacts.ID >= ?" ) rc, param = api.sqlany_describe_bind_param( stmt, 0 ) param.set_value(50) rc = api.sqlany_bind_param( stmt, 0, param ) rc = api.sqlany_execute( stmt )
Syntax