If (MOD(.vloopcounter,1000)) = 0 then
--update your meter
endif
This will update you meter only when your loop counter = 1000, 2000, 3000, etc
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr
Sent: Monday, August 17, 2009 12:26 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: PAUSE Command with Meter Progress Bar
Dennis, please explain how - I'm always having to adjust my values so if
there's an easier way...
Thanks in advance,
Regards,
Alastair.
----- Original Message -----
From: Dennis McGrath<mailto:[email protected]>
To: RBASE-L Mailing List<mailto:[email protected]>
Sent: Monday, August 17, 2009 4:39 PM
Subject: [RBASE-L] - Re: PAUSE Command with Meter Progress Bar
You don't need another loop.
You can use the MOD function to determine when the counter is a multiple of say
1000, and update the pause when that occurs.
Dennis McGrath
________________________________
From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On
Behalf Of Alastair Burr
Sent: Monday, August 17, 2009 10:34 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: PAUSE Command with Meter Progress Bar
Briefly...
Prior to your WHILE loop set the var to integer and zero.
Also set a variable to the total number of records in the loop (select count(*)
into vCount where...)
Inside the loop calculate the percentage of records processed as the value for
vProgress;
Use the value in the pause command.
If you have a large number of records you may find that you only want to do the
calculation and pause every hundred or thousand, whatever suits you. If so, add
another loop that counts to that number and do the calculation and pause inside
that. Reset that count to zero when your preferred limit is reached.
Regards,
Alastair.
----- Original Message -----
From: Jim Belisle<mailto:[email protected]>
To: RBASE-L Mailing List<mailto:[email protected]>
Sent: Monday, August 17, 2009 3:54 PM
Subject: [RBASE-L] - PAUSE Command with Meter Progress Bar
When using the PAUSE Command with Meter Progress Bar, how do I set the variable
vprogress (as shown in Help)?
Jim
________________________________
No virus found in this incoming message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 8.5.392 / Virus Database: 270.13.58/2309 - Release Date: 08/17/09
06:08:00
________________________________
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.392 / Virus Database: 270.13.58/2309 - Release Date: 08/17/09
06:08:00
