| Dinesh Chauhan 2005-03-28, 6:10 pm |
| I have table level 4 in my database. How can I make keyfield(index) Autoinc
field? Because I want to validate that field with unique field value so I
can not enter the duplicate value for that field.. Like Romain Strieff has
said "Using an AUTOINC field makes all this moot, no coding needed, they're
always UNIQUE".
From: dBVIPS@use.net (Romain Strieff [dBVIPS])
Newsgroups: dbase.programming
Subject: Re: Entryfield Validation
Date: Sat, 24 Jul 1999 05:39:39 +0200
Better move to form-level validation, done when the user tries to save.
Your code won't work anyway if you move the record pointer in the same
rowset during the append, it would have to use an additional copy of the
table to do such things as moving the mointer during buffer operations.
Using an AUTOINC field makes all this moot, no coding needed, they're
always UNIQUE.
--
Romain Strieff [dBVIPS]
Dinesh Chauhan
|