>>>Yes, of course you are right. My example was for a table without order, without filter, and without deleted records (+ SET DELETED ON).
>>
>>It was only to make clear to the OP that he will start an adventure.
>>
>>I've never used
SET KEY so I've learned something on this subject today.
>
>If it can be used, set key is often the fastest way available. So think about use ... again, set key if you are not worried about in-between writes instead of a cursor or view if handling a local table.
I do nothing direct on tables (all CA) and INDEX only if needed for rushmore. I have some on the fly indices for Excel-like-order, but that's it.
Skip is mostly use for the purpose mentioned in this thread, to figure out where I am for display ... :)
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]