>Sergey, I must be missing something here. From the Visual FoxPro Language Reference for SET DELETED:
>
>Note Calling SQL SELECT with SET DELETED OFF includes records fitting the specified criteria in the result set and sets those records as available for processing. That is, SET DELETED OFF is not set for the records in the result set.

When deleted records are included into SQL Select result ( only when SET DELETED OFF ) the deletion flag isn't transfered into result set. IOW retrieved records don't have deletion flag set. However, deleted records are not included into SQL Select result with SET DELETED ON in effect.