Apache OpenOffice (AOO) Bugzilla – Issue 12478
error in read al register
Last modified: 2006-05-31 14:29:06 UTC
dears, look this 'error read all registers in database' really, i have a 121 registers in my BD (MySQL via ODBC) im think... this only read the 'first page'... regards, marting
Created attachment 5161 [details] error in read al register
martin, I suppose you're referring to the record number, which is shown as "15 *"? This is no bug: For databases, it is simply impossible to know how many records a table/query contains without _visiting_ all these records (You could do guesses, but never an accurate number). But, because visiting all records is potentially expensive (for all of them, a small amount of data must be cached by OOo), OOo does _not_ visit all records, but only travel a little bit further than what is actually needed. This means that in your example, 6 and a half record are visible, so 7 records are needed at least. So OOo visits all records up to the 15th. When you travel further, you will see that the number of records increases, because OOo then _knows_ them. The "*" sign behind the record number is telling you exactly this: The number is only a "lower limit" currently, because not all records have been visited, yet. Once they _have_, the "*" will vanish, thus indicating that the record number now is correct.
close this issue, if there is still a problem please open the issue again.
change subcomponent to 'none'