>>>>

>>>>SET DELETED OFF
>>>>

>>>
>>>You have turned off the DELETED filter. That is why you are getting deleted records. Change this to SET DELETED ON.
>>
>>I think I'm not making myself clear. I WANT deleted records returned, but I want them returned with the deleted flag set as it is set in the table itself. This only happens if DELETED, ANSI, and EXACT are all set off. If I set either ANSI or EXACT to ON, the deleted flag is wiped out and the record is returned as non-deleted. I can't find any documentation that says why ANSI or EXACT should cause such behaviour.
>
>The flag in never returned. What is your select statement?
>
>For single table in FROM you can do
>
>select field1, field2, deleted() as lDeleted from myTable where ...
>
>You can not use this idea for multiple tables in FROM and there is no way to return deleted status. Or at least I don't know a way <g>

I included some example code in my first message, but I guess it's been snipped by now. Anyway, if you do a select while DELETED, EXACT, and ANSI are all set to off (and you don't include NOFILTER), the deleted flag will stay set on deleted records. Whether or not this is something that can be counted on as staying that way is a separate and equally important issue.