Doevents emmulation in VB Script

[nazkhan]

Hi,
I need help with a VB Script prject I'm working on. Basically this is what I'm trying to do:

I first need to query a database, then use some of the returned data for a query to a second database. The problem I'm having is waiting for the first query to complete before moving on to the second query. I need some way to wait in a loop for a flag "ReadyState" to be set to 4. But a loop like this just locks up the computer.

while ADC.ReadyState <> 4
wend

I need some sort of DoEvents in the loop but nothing similar to that command is available in VB script. Is there any way to do this.

I'm at work right now, so I would appreciate answers at soon as possible. Thanks for you help


[sig][/sig]

 

[DougP]

Try this

Do

Loop Until RS1.EOF [sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]