Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simulate wait state in vfpoledb
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
01062636
Message ID:
01062640
Views:
11
InKey(1)?
or
Do While .... some expression ...
   For i = 1 to 10000
       DOEVENTS
   Next i
   ... do something ....
   Exit && If here you have EXIT why you need DO WHILE???????????????
EndDo
not tested


>I have a need to induce a wait state in a stored procedure I am calling from ASP via vfpoledb.
>
>I have tried several approaches, none of which is successful.
>
>Here is what I have treid so far:
>
>
>Wait "" Timeout 1
>
>
>This results in a "feature not supported" error message.
>
>
>I have also tried:
>
>
>
>Declare Sleep In Win32API Integer nMilliseconds
>
>nSleepSeconds = 1
>nMilliseconds = nSleepSeconds * 1000
>=Sleep(nMilliSeconds)
>
>
>
>This also results in a "feature not supported" error message.
>
>I have also tried:
>
>
>Do While .... some expression ...
>   For i = 1 to 10000
>   Next i
>   ... do something ....
>   Exit
>EndDo
>
>
>This results in the web server being tied up and slows down all processing. Not good!
>
>I can't believe this is that difficult. I keep feeling I am missing something obvious.
>
>Any ideas?
>
>Thanks,
>
>-Steve Kanski
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform