Uniqueness of index violated on deleted records? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Uniqueness of index violated on deleted records?

Message

De

03/08/1999 22:46:12

Craig Berntson
Quicken Loans
Salt Lake City, Utah, États-Unis

À

03/08/1999 20:16:22

Eric Crespin
Pc Plus Inc.
Montréal, Québec, Canada

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Uniqueness of index violated on deleted records?

Divers

Thread ID:

00249514

Message ID:

00249567

Vues:

24

>Is it really like this?
>If I have a record with the ident (which is a unique index) = 1000, I deleted it, I cannot put 1000 anymore?
>?
>thanks
>eric

Yes. By definition, a PK is totally unique...you never resue it.

Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer

Click here to load this message in the networking platform