Do you need to view deleted records in your system? If not, issue a SET DELETE ON to filter those out. This is scoped to datasessions so you have have to issue it in the Load of each form with a private datasession.
>Hi all,
>
>I have a view which uses LEFT OUTER JOINS to join several tables, the problem is, records that are deleted in some of the tables are being pulled into the resultant view, creating records that shouldn't be there, even though I have a "NOT DELETED()" in my WHERE clause.
>
>I've tried adding "WHERE NOT DELETED()" to each JOIN, but that didn't work either. Am I doing something wrong?
>If I try adding the alias to the DELETED() command I just get Column/Field not found messages.
>
>Please enlighten me.
>
>Thanks,
>
>- Aaron.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao