Glad to help, Alastair. Here's another tip to solidify the use of MOD If (MOD(.vValue,2)) = 0 then --value is even Else --value is odd Endif
Dennis ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Monday, August 17, 2009 3:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: PAUSE Command with Meter Progress Bar 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<mailto:[email protected]> To: RBASE-L Mailing List<mailto:[email protected]> 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]> [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 ________________________________ 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
