Printable View
I made a small ERP for my firm ...and i have a problem. I have a lot of sql interrogation (client conected to a server in LAN) ..and this takes very long time..
It is possible to display a continuous progress bar when i do sql interrogation because it takes a very long time to wait for user.
I think i can use multi-threading but I do not know how.
Can someone help...
Here is a screenshot for my ERP:
Multi-threading in VB isn't exactly easy & is relatively unstable; no room for error.
A possible solution could be to use asynchronous SQL execution and use a timer to update the progress bar or display a simple label saying to wait... May want to search the databases portion of the forum using the keyword: asynchronous.
Thank you!
you could use egg timer cursor, just so it looks like something is happening
never heard it called that before :)Quote:
Originally Posted by westconn1
Always known it as the hourglass
i guess there is a few to choose from, depending on windows version