SET DELETED is scoped to the datasession. Make sure that you set it on in each new datasession, otherwise off is the default. The only reason I can see that you get deleted records back from a SELECT-SQL is because SET DELETED is OFF.

>I have DELETED on already.