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
The day you take complete responsibly for yourself, the day you stop making any excuses, thats the day you start to the top. - O.J. Simpson
Great advice from a questionable source...