Show a continuous progress bar when do sql interrogation?
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...
Re: Show a continuous progress bar when do sql interrogation?
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.
Insomnia is just a byproduct of, "It can't be done"
Re: Show a continuous progress bar when do sql interrogation?
you could use egg timer cursor, just so it looks like something is happening
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
Re: Show a continuous progress bar when do sql interrogation?
i guess there is a few to choose from, depending on windows version
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
Reply With Quote
Originally Posted by westconn1
