Changing or deleting data

The process for executing other data manipulation operations is identical to the process used to execute a SQL SELECT or INSERT statement, as described in Working with SQL statements. Simply substitute a different SQL statement in the SQLStatement instance's text property:

• To change existing data in a table, use an UPDATE statement.

• To delete one or more rows of data from a table, use a DELETE statement.

For descriptions of these statements, see SQL support in local databases.