OdbcExecute

Syntax

OdbcExecute(str_dbidentifier, str_sql_statement);

str_dbidentifier	The identifier specified in OdbcConnect.
str_sql_statement	The SQL statement to execute.

Description

Executes SQL statements. Any result sets that the statement generates are ignored. This function can be used, for example, to update record fields in the data source. To use this function, you must first write the SQL statement and give it an identifier. You then use the OdbcExecute to execute the statement.

Se also OdbcExecuteEx.

Returns

	The statement was executed successfully.
-1	Error. An error occurred while trying to execute the statement.

Example

$st="INSERT INTO CUSTOMER(CNR)VALUES("+$custid+");"); OdbcExecute("my_identifier",$st);

In this script, the customer ID is stored in a variable. An SQL statement is written using the value of this variable. $st would contain something like the following when OdbcExecute is called:

INSERT INTO CUSTOMER (CNR) VALUES (124);