>A thought that comes to mind now is that the reaction to SET DELETED is inconsistent with the reaction to SET FILTER. No matter what filter is active, the SQL-query will ignore the filter anyway.
There is a difference, however. SET DELETED is a global setting (for the entire current datasession, that is), whereas SET FILTER is only for a single table.
When SELECTing from a filtered table, internally, the table is USEd AGAIN. When SELECTing with SET DELETED ON, this global setting also applies to the new instance of the table.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)