If you need to use the deleted flag, it should be quicker to combine her idea with mine. You can then omit the lDeleted field from grids.
< view definition >
SELECT *,deleted() as lDeleted from table1 where ...
....
< when you use the view >
USE view1 in 0
select view1
delete for lDeleted
>
>Also found a message (Thread #
675313, Message #
675350) with a workaround for this problem but would like to find a better way.
>
>Best regards,
>
>Todd
Steve Gibson