SQR with a DoEvents, or a Yield - A Quiz for over-acheivers amongst us

[Steve Hall <Steve_Hall@PEOPLESOFT.COM>]

Fellow Toilers:

SQR, like so many other languages, will race ahead when I want it to wait.

I want it to keep reading a certain column in a database, say END_TIME.
When END_TIME is no longer NULL, the process is complete and my
SQR script can run ahead.

     PROC_NAME       |      START_TIME    |      END_TIME

---------------------------------------------------------------------------
---
     money_import           00:01:00                          NULL

     wait, wait wait.....


     PROC_NAME       |      START_TIME    |      END_TIME

---------------------------------------------------------------------------
---
     money_import           00:01:00                          12:34:56
<-----

     ok, go!


How can I get it to go into a polling loop?

     Steve Krim writes:

     How about shelling out to unix, calling sleep for say, 10, 20, or xx
     seconds, returing to SQR and check your column.  If the value you are
     looking for is there, break out of the loop and go on...
     What are you really trying to do, maybe there's another way.
     ----------------------------------------------------------------------
     Steve Krim          |  SK Professional Services Inc.
     smkrim@teleweb.net  |  Check out - http://www.skprof.com/


OK, that'll work. Has anyone called Yield or any Windows95 polling
functions?

-Steve