Hi
Seems that my combombox, download #23713, can help you. I designed it special for client-server.
It has both asyncronous and incremental search (in all columns, if needed). Also, it uses _incseek and start to retrieve records or search in local cursor only after that interval elapsed after the last key pressed. Or can be set to search/retrieve only in LostFocus().
The asyncronous combobox is in the last page in sample form.


>I have just migrated to a client-server environment with mysql as backend. However i've just encountered a problem with very slow form loading due to both slow hardware and the nature of disconnected record-sets, since i have to pull all the data from mysql to populate a combobox. I'm looking for an optimum solution in which a combobox just needs to pull just enough data (from mysql) for what is visible, like, if i may make an analogy, how vfp opens dbfs. When VFP opens a dbf, i doesn't load the entire file. Issue a use command and a table opens without delay . yet browse and you can pagedown or go to the bottom using the vertical slider. i think as you pagedown vfp fetches the corresponding data as needed from disk. I've tried asynchronous data access but it's not d same. you still have to wait till it fetches all data to be able to go to the end of the generated cursor. I mean to open a table and go to the last record, the computer just has to open the file and access first
>few and the last few records in order to emulate GO TOP, and Go bottom successfully. It doesn't have to load all data continuously (even in an asynchronous access which wastes processor time)..I've read that combobox is not suitable for large records but it's not negotiable since i was able to do it in a non-client-server environment and my client is insistent on having the incremental combobox feature.