sqlany_execute_immediate

sqlany_execute_immediate

Executes the specified SQL statement immediately without returning a result set. It is useful for statements that do not return result sets.

Syntax

sqlany_execute_immediate ( $conn, $sql )

Parameters

$conn A connection object with a connection established using sqlany_connect.
$sql A SQL string. The SQL string should not have parameters such as ?.

Returns

Returns a scalar value that is 1 on success or 0 on failure.

See also

sqlany_error

Example

rc = api.sqlany_execute_immediate(conn, "UPDATE Contacts
     SET Contacts.ID = Contacts.ID + 1000
     WHERE Contacts.ID >= 50" )

Discuss this page in DocCommentXchange.
Send feedback about this page using email.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1