>>>Can anyone tell me whether SELECT - SQL respects SET DELETED ON/OFF? I used to know this.
>>>
>>>thank you
>>
>>Yes, it respects it in all reasonable situations. The only exception if you run SELECT * From Table INTO Cursor, and even this case can be remedied by NOFILTER.
>
>Thanks, Edward,
>
>The problem I appear to be having is that SELECT is selecting deleted records when SET DELETED is ON -- puzzling!
>
>regards
That's strange. Are all tables open before SELECT? Also, if you SELECT into cursor, try NOFILTER.
Edward Pikman
Independent Consultant