Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Skipping when Index value changes
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00487842
Message ID:
00487893
Vues:
7
A cheesy solution is to store the ID value (or other determining value like Recno()) of the FOLLOWING record (Ford in this case). Make your change and then return to Ford.

Since you're changing the indexed field, you can also SET NEAR ON, seek the original value you change (SEEK 'Berra'). It will find the record AFTER Berra since Berra is now Pepitone.

Either way will work.

HTH
Barbara

>Hi all:
>
>If I have a table open with an active index and then modify one of the fields involved in that index expression, can I set any setting/property which would cause a SKIP to go to the next record from before I made the change???
>
>For example: A table indexed on last name with the following entries
>
>Berra
>Ford
>Mantle
>Turley
>
>
>If I change Berra to Pepitone, and issue a skip, the next record would be Turley. I'd like it to go to Ford.
>
>
>Thanks for any response.........Rich
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform