Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement