On Jun 15, 2006, at 12:49 PM, Nate Smith wrote:
I am writing an application in which I am querying a SQL Server
database
via ODBC. After querying the database, I use a Do...Until loop to
iterate
over the recordset and fill a listbox with rows of data. This
query takes
quite some time to run, and I want to show the user some visual
feedback; a
progress wheel. However, my interface just freezes and the
progress wheel
never displays. In fact, the interface does not unfreeze until the
listbox
is fully populated.
So, I tried putting the query and the recordset loop inside a
thread. This
did not change anything.
I also tried (without the thread) using app.DoEvents. Still no luck.
Does anyone have any suggestions?
Dont use DoEvents
The ODBC driver sounds like it is not yielding back to RB so it
blocks ANYTHING else from happening regardless of whether it's in a
thread or not
There's nothing you can do about that
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
