|
The UNIQUE keyword does work, no doubt about it. Its probably just my bad luck that too often theres been a need for more than one identically keyed primary record, and then we have to go back and add in the Seq. # field to keep the uniqueness. It isn't religion for me but I don't define a unique key anymore unless told to. --------------------------------------------------------- Booth Martin http://www.MartinVT.com Booth@xxxxxxxxxxxx --------------------------------------------------------- -------Original Message------- From: RPG programming on the AS400 / iSeries Date: 11/17/03 12:46:06 To: RPG programming on the AS400 / iSeries Subject: the idea of unique primary keys to be a solution that has outlived its usefulness? Why do you feel that way Booth? Rob Berendt -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.