John,

I just USEd a view based on a table that I deleted 2 records in. I then SET DELETED OFF and REQUERY('ViewName') and the view came back with 2 extra records. So views do respect the deleted flag. However, the extra records returned, which were the deleted ones, are not flagged deleted in the view but this is also true for SQL-SELECTS into cursors, tables, etc.

>Colin ---
>
>Ummm....a little "whoops", there, buddy. SQL-SELECT respects the deleted flag but views using SQL-SELECT (as they all do) don't. Dunno, why, but that's the case.
>
>>
>>SQL-SELECT respects SET DELETED. SET DELETED OFF and Refresh the view. HTH