Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UNIQUE INDEX FILTER
Message
From
30/11/2000 08:24:23
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00447200
Message ID:
00447254
Views:
13
>I ran into a particular problem that I have trying to figure it out.
>
>I have a table with a primary index.
>I can add to the table. If I delete the record and cannot add another record.
>I get the Error Index Uniqueness. If I pack the table. I can add the record.
>Then I start the process again.
>
>I have set delete on -- does not work in this problem.
>
>What I ended up doing was to add to the filter option of the index
>tag the expression !DELETED().
>
>This allowed me to by passed my problem
>
>However, I have a question.
>
> Is this approach correct or is there a better way?
>
>Manny

As Larry said, you should not reuse primary keys. There is a KB article on my web site that discusses this and provides code to generate new PKs.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform