Many thanks, Dennis.
Obviously, I never knew that. Having just looked at the help for the MOD
function even knowing what you've just shown me I wouldn't have seen that as a
way to do what a loop would have done.
I've now got some work to do to make some changes to my code.
Thanks again,
Regards,
Alastair.
----- Original Message -----
From: Dennis McGrath
To: RBASE-L Mailing List
Sent: Monday, August 17, 2009 7:02 PM
Subject: [RBASE-L] - Re: PAUSE Command with Meter Progress Bar
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
To: RBASE-L Mailing List
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]] 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
To: RBASE-L Mailing List
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
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
------------------------------------------------------------------------------
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
