General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
UNIQUE INDEX FILTER
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only