Updating Records

See Also

Quick Tour

Employee Form

To allow users to update existing records in the database, we include an update button in our Employee form. Users navigate to a particular record, click on the Update button, make changes, and then commit.

While in update mode, our application makes the following restrictions:

· users cannot navigate to another record or perform another function

· users cannot change the employee number since this is the primary key

To code the Update function, we write an event procedure for the Update button and modify our Commit procedure to handle both updating and adding records. Refer to the following sections:

Coding the Update Button

Coding the Commit Button (Update and Add)