How can I disallow duplicate entries in my table? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How can I disallow duplicate entries in my table?

Message

From

21/05/2004 05:18:59

Borislav Borissov
Microcomplex
Sofia, Bulgaria

To

21/05/2004 04:37:26

Evelyn Neri
Epn Inc.
Manila, Philippines

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Re: How can I disallow duplicate entries in my table?

Miscellaneous

Thread ID:

00905919

Message ID:

00905926

Views:

11

I addition of what Tore said:

IF .NOT. SEEK(myUniqueValue,myTableAlias,myTagName)
   APPEND BLANK
   REPLACE ...
ELSE
   MessageBox(Duplicate records", 0 , "Warning")
ENDIF

or

IF .NOT. SEEK(myUniqueValue,myTableAlias,myTagName)
   APPEND BLANK
ENDIF
REPLACE ...

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

Click here to load this message in the networking platform