. . . as will SEEK return a DELETED record regardless.

Jim N

>You should know that you can go to a record that is deleted:
>
>GO nRec
>
>where nRec is the value returned by RECNO() for that record. This is mainly to be able to do a RECALL while set deleted on.
>
>Vlad
>
>>It appears that
>>
>>SET DELETE ON
>>
>>invokes a built in "filter" for a "delete flag" in every table record.
>>
>>Everything I've read suggests that I should have every expectation that a deleted record, though still physically present, should be "virtually" invisible to absolutely everything I do within a table (except of course to become "real" if I SET DELETE OFF).
>>
>>Is it naiive to assume that deleted records disabled by SET DELETE ON will be totally inert with respect to my app or are there some well known gotchas I should be aware of?