>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
Hi Rich,
Back in Foxpro 2.6 days I vaguely recall the trick my colleague used. Check Help on SET OPTIMIZE Command.
If it's not broken, fix it until it is.
My Blog