Though I have never worked with deleted records in the view, I would use two separate views (for deleted and not deleted records) to handle separately problems if they arrived.


>Hi Yuri,
>
>>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.
>
>
>Yes, it seems to me that "Create View" assumes the Nofilter behavior by default.
>
>Ill probably just create a logical delete flag field in my table to get the result I want.
>
>
>Todd