SET DELETED is scoped to the datasession. Place a SELECT MyTable before SET DELETED ON to make sure that it is applied to the right datasession.

HTH

>have an easy one i am sure. i am selecting out of a table that has deleted records but cannot be packed. my select takes out the deleted items as well as live items and i have a set deleted on just before the select statement, can anyone point me in the right direction.