> ...
>The other thing I get with an Int is multiple states of deletion. In my last job, we needed to have undelete capability for a table. So I just added a state of "2" in the iDel column for things that were deleted but subsequently recalled. The table relationships were pretty complex, so I didn't want to create a complete mirror image of the table with just "undeleted" rows. I just added the "2" value and a child table with a little undelete-related info and I was moving.
> ...
OK, it seems you have some additional options that are not included in the built-in mechanism. Just don't forget that an index on the iDel column will give you the same problems (slow fetching over the network) as an index on deleted(). Unless you use a workaround to specifically disable the index on a specific query.
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)
