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. 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 the appendix “SQL support in local databases” in the Adobe AIR Language Reference for HTML Developers.