Hi,
Why dont you try to Issue a command,
GO TOP after your
set order to command and see what will happen. You know that whenever you issue a
seek() and it finds the record, the pointer will be left to that record even you issue a
set order to againWhat if the record you want is at the upper location of your Index table? then definitely it will return an invalid records...
Check if it works as I've encountered a lot about this
Seek() function.
I mostly use this for local tables searching.
Hope it helps.
Best Regards,
Jojo R. dela Cuesta
Dalplus Technologies
http://www.dalplus.com