Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unique index violation
Message
 
 
To
25/08/1998 15:49:10
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00129845
Message ID:
00129893
Views:
36
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform