Hi Eric,

>Is the command SET DELETED ON is working when you attempt to create a SQL views.

Yes, when I do:

set deleted off
select * from orders into cursor mike1
set deleted on
select * from orders into cursor mike2
?reccount('mike1') &&178
?reccount('mike2') &&110

I get two numbers when orders has deleted records.