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
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.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
