Thanks Larry,
But I was kind of hoping for a contained solution that didn't rely on me altering how the environment was setup. Doesn't this seem like a bug to anyone? Why show deleted records in a view when you've specified NOT DELETED() in the WHERE clause, especially if that record isn't going to be indentified as DELETED in the view.
It just doesn't seem to make sense, wouldn't this be a common problem?
- Aaron.
>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.
Aaron Young
Red Wing Software, Inc.