Specifying the unique key columns

The Unique Key Columns box in the Specify Update Properties dialog box specifies which columns PocketBuilder uses to identify a row being updated. PocketBuilder uses the column or columns you specify here as the key columns when generating the WHERE clause to update the database.

The key columns you select must uniquely identify a row in the table. They can be the table's primary key, though they do not have to be.

Figure 20-2: Selecting columns that identify the rows to be updated

The sample shows a portion of the Specify Update Properties dialog box. A list box titled Unique Key Columns displays six column names. The emp _ i d column is highlighted. To the right of the displayed columns is a Primary Key button.

Using the primary key Clicking the Primary Key button cancels any changes in the Unique Key Columns box and highlights the primary key for the updatable table.