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
