AFAIK, there is a difference even for plain select. To see the behaviour, use a small table to have avility to create the 'regular' cursor and the table.

set dele off
1. select * from ... into cursor tmpcurs &&it must be the 'regular' cursor, then it shows the deleted records as deleted.
2. select * from ... into cursor tmpcurs NOFILT &&it will show all records WITHOUt deleted mark. The same is with select .. into table.


>Hi Yuri,
>
>Thanks for responding on this.
>
>Im not using "where deleted()" in the view SQL statment because I want the result to include both deleted and non-deleted records, which it does. The problem is that the "delete flag" is getting turned off on deleted records in the view result.
>
>Todd