>>>>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,
I think all tables are open -- I guess I assumed they are since I'm getting no error messgages to that effect -- but I guess I'd better check.
Thanks again,
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.