Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DataIsland Readystate Loop

Status
Not open for further replies.

QuantumDoja

Programmer
Jun 11, 2004
76
GB
Hi, I am trying to perform a loop until all data in a dso has been downloaded, one thing is tho, if i remove the MsgBox it loops forever and if i put the message box in, it works fine, but i get an annoying pop-up. Any Ideas??

Here is the code:

Code:
Found = False
Do
  MsgBox(dsoMyData.Readystate)
  If dsoMyData.Readystate = 4 then
    Found = True
  Else

  End if
Loop Until Found = True

 
You have coded a fast loop!

The best thing is to use an event handler to detect when the data is ready.

ondataavailable
ondatasetcomplete
ondatasetchanged
onreadystatechanged

There are several, depending on what you are trying to trap on.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top