General information
Category:
Coding, syntax & commands
Ok, you're right with NOFILTER. But if I want deleted records returned to the cursor as deleted, I need to set DELETED, ANSI and EXACT to OFF (and not include the NOFILTER keyword). My question is simply, why do exact and ansi control this? Is it documented somewhere?
>Sure it does. All deleted records are returned as undeleted for all combinations of SET EXACT and SET ANSI which is expected behavior for SET DELTED OFF.
>
>>I just tried it and it doesn't change anything. With EXACT ON (or ANSI ON) and using NOFILTER, I still get back the deleted record as a non-deleted record in the cursor. I appears to be EXACT and ANSI that are controlling whether or not the deleted record is brought back as a deleted record or as a non-deleted record.
>>
>>I wonder if it's just a bug. Hard to believe this is the intended behaviour - especially since the documentation seems to make no mention of it.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only