>>>>Is there any way to count records in a buffered (mode 5) view without moving the record pointer?
>>>
>>>Check new WITH (buffering) option of Select-SQL. I'm not sure how does it work internally and it is a slow option, be aware.
>>
>>I'm curious though... why can't the table header be used for count operations? Doesn't the header have an accurate count of records?
>
>Table header counts all physical records, and deleted are included there. Therefore RECCO() function returns all records.
Good point.
If it's not broken, fix it until it is.
My Blog