Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unique index violation
Message
 
 
À
25/08/1998 15:49:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00129845
Message ID:
00129893
Vues:
34
>I Create a Table with a field X that is a primary key.
>
>I Input a record with X=1
>Delete the record, set deleted is on
>
>When I Insert record with X=1 again, Foxpro show the error: Unique index violation.
>
>The initial solution of the problem is:
>- In the filter of the index input !deleted() but....
>
>
>Is the unique solution ?????
>
>
>Thank You,
>
>Mauricio Mesa.

The filter you suggests works. You may want to add an additional tag (with the expression DELETED()) to the table. This will Rushmore Optimize the filter.
Rick Hodder
MCP Visual Foxpro
C#, VB.NET Developer
Independent Consultant
www.RickHodder.com
MyBlog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform