Database Guide : Database programming guide : Querying databases : Writing UPDATE, INSERT, and DELETE statements
Writing UPDATE, INSERT, and DELETE statements
The general technique you use to update, insert, or delete rows in a database table in VAST Base is to open or query the database table you want to update, retrieve and update a row, and then add the row back to the table. To work with database tables in this way, you use the classes AbtResultTable, AbtTable, and AbtRow.
This section provides examples of how to update, insert, and delete rows in the SAMPLE database using these VAST Base classes. It includes the following sections:
Updating a row in a database table
Inserting a new row in a database table
Deleting a row from a database table
The examples for inserting and deleting a row operate on the same row. To use these examples, first follow the example for inserting a row, and then follow the example for deleting it.
The techniques illustrated in this section operate on only one table at a time. You cannot, for example, delete a row from a table returned by a join operation.
Last modified date: 02/27/2021