Tutorial Chapter 6: Add, Update and Delete

Parent topic: Tutorial Chapter 6: Add, Update and Delete

Updating Database Tables

The values of the program variables that have been input through the form can be used in SQL statements that update tables in a database.

SQL transactions
The embedded SQL statements INSERT, UPDATE, and DELETE can be used to make changes to the contents of a database table.
Concurrency and Consistency
While your program is modifying data, another program may also be reading or modifying the same data. To prevent errors, database servers use a system of locks.

Parent topic: Tutorial Chapter 6: Add, Update and Delete