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
.
|
|
|