Listbox refresh question

[PeterHarmes]

Hi,

In my app i am using LISTBOX from a resource file to browse a database. Under DBFCDX i can set a scope and use oBrw:bLogiclen := {|| DBF->(cmxKeyCount())} and the the listbox behaves itself when the vertical thumbnail is dragged. If under SQLRDD, as there isnt a way to find out how many records there are in a scope quickly (or is there?) the listbox display can corrupt until you press home/end or do a refresh - is there a way to repaint the listbox when the thumbnail is dragged?

My cmxKeyCount function is :

func cmxKeyCount(xOrder, cBag)
dbOrderInfo(DBOI_KEYCOUNTRAW, cBag, xOrder)

Hope the above is clear and thanks in advance

Pete

[Antonio Linares]

Peter,

Is there a way that you may issue this SQL sentence:

SELECT COUNT( FieldName ) FROM TableName

[PeterHarmes]

Yes there is, but it can be slow if you are looking at large amounts of data on a large table. I was wondering if there was a way to call a function if the thumbnail was dragged?