TQuery: How to get query record number different from physical record number
Posted on 1998-09-16
I have a TQuery, doing SQL onto local FoxPro files thru LocalSQL.
The problem is that when I check the TQuery.RecNo property, it tells me the physical record number.
But first a little side note. This only happens when I set the TQuery.RequestLive property to TRUE. That is when the .RecNo property reflects the physical records. If the .RequestLive is false (the default) then the .RecNo reflects the position in the TQuery. But, I need .RequestLive to be true because this has to be a live dataset.
I'm needing to know the record index of a live query..
I need this because I have a TList full of other temporary properties that tie to each element in a TDBgrid... owner draw stuff.
I have the option of making the TList fill up to the max size the query could get, but this table has millions and millions of records... but what is displayed is quite small and frequently changes, so rebuilding this massive TList is not on the top of my choices.