Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wrong tag with FOR NOT DELETED() UNIQ after recs are deleted
Message
De
26/02/1998 15:55:19
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Wrong tag with FOR NOT DELETED() UNIQ after recs are deleted
Divers
Thread ID:
00081529
Message ID:
00081529
Vues:
55
I have a table where it is important that an index tag be correct
at all times that includes the FOR NOT DELETED() UNIQUE criteria.

When a user marks the record for deletion that was being used
by the UNIQUE tag, VFP5a is not substituting another record that
has the same key fields that is not marked for deletion.

Consider the following example where a table with the field TEST has
an index tag: INDEX ON TEST FOR NOT DELETED() UNIQUE TAG TESUNIQ
The table contains the following data in the field TEST:
A
A
B
B
C
C

With the TESTUNIQ tag active you will correctly see:
A
B
C

If you delete the first B record, you will only see
A
C
but you should still see the second B record

This can be fixed by a REINDEX command but this is unaccepable
in a production environment.
__________________________________________________
Mesa Vista Software (david@mesa-vista.com)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform