Returns a result set object using the specified statement or prepared statement object and SQL INSERT, UPDATE or DELETE statement.
Syntax
executeUpdate( preparedstatement )
preparedstatement.executeUpdate( )
executeUpdate( statement , sql )
statement.executeUpdate( sql )
Parameters
statement
|
the prepared statement object to use.
|
statement
|
the statement object to use.
|
sql
|
the SQL statement to execute.
|
Returns
integer
|
the number of rows updated.
|
Example
stmt = "delete from names where last_name = 'smith'"
if stmt.executeUpdate( stmt ) = 0 then
break
end
|