dBASE adding UNIQUE index/Primary Key issue

<< Click to Display Table of Contents >>

Navigation:  Tables > File Restructuring > Primary Key Set/Delete >

dBASE adding UNIQUE index/Primary Key issue

Previous pageReturn to chapter overviewNext page

The dBASE adding UNIQUE index/Primary Key issue

Contrasting Paradox, adding a UNIQUE index (all dBASE levels) or Primary Key (dBASE 7 only), any key violations on existing data are ignored.
So, applying a unique key/Primary Key to the first field of a dBASE table like this:

dBASE7-Duplicates

key violations among existing data are ignored leaving the records unaltered, and checking keys for successively added data only.

__________________________
PdxEditor Application Help, 14 July 2026; © 2010-2026 Niels Knabe