Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Skipping when Index value changes
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00487842
Message ID:
00487893
Views:
8
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform