Executes a statement on an open connection

Executes statement against an open database connection. Returns -1 on error, 0 on no record changed, or number of records changed on success.

Sample Source Connect MyDatabase to "DSN=dsn_name" as ODBC iResult := ExecuteStatement "Delete from Sample" on MyDatabase If iResult < 0 Then Say GetLastError MyDatabase EndIf Disconnect MyDatabase

Sample Source Connect MyDatabase to "DSN=dsn_name" as ODBC PrepareStatement MyStatement as "Delete from sample" From MyDatabase iResult := ExecuteStatement MyStatement If iResult < 0 Then Say GetLastError MyDatabase EndIf Disconnect MyDatabase

Related Function(s):
   BindParameter; Connect; GetLastError; GetRowset; PrepareRowset; PrepareStatement;

Minimum version: 1.0