|
|
#1 |
|
Guest
Posts: n/a
|
I'm currently working on a project in VB6, using DAO, that requires me to check an xbase db for 3600+ items to see if they are in stock, before generating an entry for it on a web page. Whenever the program is in the loop performing this operation, it practically renders the system unusable. The operations usually take ~45 minutes on a P3-500 system.
What I would like to do is add some code to it that will allow the program to handle running in the background better (at all). Can anyone suggest something? Any help would be appreciated. |
|
|
|
#2 |
|
Guest
Posts: n/a
|
Have you tried adding a "DoEvents" at the very bottom of your loop?
|
|
|
|
#3 |
|
Guest
Posts: n/a
|
Thanks! I think that's exactly what I needed. I wasn't even sure what direction to start looking.
|
|
|
|
#4 |
|
Guest
Posts: n/a
|
Glad to help
|
|
![]() |
|
||||||
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|