>>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
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.