>Hi
>Default 'Deleted' setting is on.
>Can I work on same table twice- one alias as 'deleted off' and other 'deleted on' without to explicit 'set deleted' again and again?
>Thanks
There are probably (almost certainly) better ways but the first thing that came to mind is to do something like
SET DELETED OFF
USE myTable ALIAS allrecords
SELECT 0
USE myTable AGAIN ALIAS notdeleted
SET FILTER TO NOT DELETED()
It may not be pretty, but I think it works.