I used it inside of another while loop in the calling procedure to pause briefly for the creation of a marker file. sometimes a second seems like an eternity to a user......
----- Original Message ----- From: "randyp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, June 15, 2002 9:27 AM Subject: Re: PAUSE 4 and Screen Flicker > 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/ > ================================================ 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/
