>I have SET DELETED ON in my form. Whenever I retrieve record I still see the deleted record. on one of my form that has a grid bound to a view doesn't see deleted records, but on another form ( both forms modal, optimistic) my individual controls that are bound to a view do see deleted records. I even tried putting set deleted on in the form itself that have bound control to a view. Does anyone know what is up with this bizzare behavior.
>
>
>Thanks
>Nick

If you are opening the table or view in the DataEnvironment, SET DELETED ON, SET TALK OFF, SET EXCLUSIVE OFF, SET MULTILOCKS ON in the BeforeOpenTables.