Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary keys and Deleted records
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00067840
Message ID:
00067857
Vues:
29
>I wanted the primary index to ignore deleted records using SET DELETE ON,but when i delete one and add another with the same primary key,
>the "Duplicate primary key error" appears.
>
>I solved this problem creating a filtered index (FOR NOT DELETE()),
>but Rushmore Technology won't use filtered indexes, so i think
>the application will lose performance when tables have many records.
>Am i right?
>
>Is there any other solution?
>
>I can't execute a PACK statement from the application because the
>multiuser environment won't have exclusive access on the table.
>
>
>Thanks
>
>Juan Carlos
Hi Juan Carlos,
Why don't you recicle deleted records instead of using pack ?
Before appending a blank record use your index to find the first deleted record, then
scatter memvar blank and gather memvar blank, or something like that.
Hope this helps.
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform