Database Guide


Writing UPDATE, INSERT, and DELETE statements

The general technique you use to update, insert, or delete rows in a database table in IBM Smalltalk 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 IBM Smalltalk classes. It includes the following sections:

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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]