ExecuteSQL Method Example

The example executes an action query that changes the City from "New York" to "NY" in the Publishers table.

MySQL = "UPDATE Publishers SET City = 'NY' WHERE City = 'New York'"
RecsChanged = MyOracleDB.ExecuteSQL MySQL