Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UNIQUE INDEX FILTER
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
UNIQUE INDEX FILTER
Miscellaneous
Thread ID:
00447200
Message ID:
00447200
Views:
56
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
Next
Reply
Map
View

Click here to load this message in the networking platform