Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Executes a prepared statement.
sqlany_execute ( $stmt )
$stmt A statement prepared successfully using sqlany_prepare.
Returns a scalar value that is 1 on success or 0 on failure.
You can use sqlany_num_cols to verify if the statement returned a result set.
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