Hi,
SET DELETED is scoped to the current data session and by default it is OFF. Could it be that you are using a private data session? If yes, you need to SET DELETED ON i.e. in the DE's BeforeOpenTable().

HTH

>hi all:
>
>when i use SQL SELECT to select records from a table, i end up retreiving the deleted records too although SET DELETED is ON. how do i overcome this problem ?
>
>thanks in advance.