Yeah, I know or at least thought I knew...

The whole reason I asked this (now stupid) question was that a few months ago I was trying to figure out how to keep from trashing grids using cursors created from XMLTOCURSOR() requeries. Had to use the 8192 flag, but had to empty the local cursor beforehand. The only way to get RECCOUNT() to zero was to ZAP the cursor.

I have no idea why I assumed the behavior for RECCOUNT() changed after all these years. Maybe because I'm finishing up a two year project and haven't seen the light of day, vacation, or anything human in a long time.


>Hi Jeff,
>
>The RECORDCOUNT() returns value from the header of the table. The cursors created with XMLTOCURSOR() is a temporary table. Deleting records from the cursor doesn't change the number of physical records in the cursor. So, the RECORDCOUNT() would return the same value before and after deletion.
>
>>In the case with cursors created locally via XMLTOCURSOR() (getting XML from a remote source), there IS no underlying table header.
>>
>>Anyway, I have found a workaround. Thanks.
>>
>>
>>>Forgive me if I've missed something in there, but doesn't RECCOUNT() look at the table header and return the number of records?