>>
>>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.