I guess I am not sure if I should use the Meter in this situation.
I am creating some temporary tables then updating a table with a series
of update commands.
Since there are only around 1000 records I am sure it will not take long
but it will take long enough that the user can get nervous if nothing is
up.
I have never done this before.
My code starts out with a DIALOG command (of course I have set my
variables but none you mentioned below).
SET VAR vMsg = ('You are about to update the Inventory
Tables:'+(CHAR(013))+ +
'Have you updated all negatives in INV_LOCATE
table?'+(CHAR(013))+ +
'Click Start to Continue, Cancel to Abort'+(CHAR(013)))
DIALOG .vMsg vYesNo vEndKey YES +
CAPTION ' Click Start to Continue, Cancel to Abort' +
OPTIONS etc
I then go to the Pause with meter
PAUSE 3 USING 'Processing Inventory! Please wait until meter closes.' +
CAPTION 'Inventory Updates!' +
OPTIONS etc
Then I create my tables and do my updates here.
I end with clearing the variable and dropping the temp tables & views.
I am not sure how to nest this into the WHILE loop.
I have never taken a programming course so all this is new.
Jim
________________________________
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 <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
Version: 8.5.392 / Virus Database: 270.13.58/2309 - Release
Date: 08/17/09 06:08:00
