Mike,
How do you use your variable vTrue?
It looks like you want your program to pause for 100 milliseconds
whenever you issue the command:
set var vtrue = (call sp_pause(100))
During the 100 milliseconds the program simply executes the while
loop looking for the endTime calculated when the stored procedure began.
Previous threads have used timers to do things like check for
records in a table representing an outbox for e-mail messages to be sent.
My understanding is that for this to be effective it needs to be placed on
a separate computer because continuously running the while loop
essentially immobilizes the system. The only time the system 'does
anything' is when the while loop ends, runs a program, then
returns to running the while loop.
Why would you want your program to pause for 100 milliseconds?
Is a separate machine required if a while loop is used to look for
intermittent data?
TIA,
Randy Peterson
MikeB wrote:
> I have a SP that does less than a second timer, but you have to set your
> time format to .SSS to make it work. You can hard code it if your delay is
> fixed. I just made it a SP so I could pass in ms values....
>
> She Goes Lika Dis:
>
> Procedure : sp_pause
> Description :
> ID : 45
> Last Modified: 12/19/2001 13:42:44.638
> Version : 1
>
> Parameter Name Parameter Attributes
> -------------------- -----------------------------------------------------
> ----
> vaddtime Type : INTEGER
>
> Procedure has 1 parameters.
> Return Value: Type : INTEGER
>
> *(sppause Auth 011401 mbyerley)
> *(Stored Procedure While Loop To Pause in partial second intervals)
> clear var MICRORIM_RETURUN, STP_RETURN
> SET VAR vaddtime INTEGER
> SET VAR vendtime TIME = (ADDFRC(.#TIME,.vaddtime))
> WHILE #TIME < .vendtime THEN
> ENDWHILE
> clear var vaddtime, vendtime
> RETURN 0
>
> called like:
> -- pause for 100 milliseconds
> set var vtrue = (call sp_pause(100))
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
