Jim,
If it's not going to take long then would a simple pause message not be enough?
If I have something that might only take a minute or so I usually just put up a
message to that effect:
"Please wait - this process might take a few moments..."
You can use the pause with the gauge if you want to show something moving (see
below).
Personally, I wouldn't bother with a progress meter unless I wanted to monitor
the progress for some reason or I knew it would take something like more than
ten minutes and I could get on with something else yet be able to see
(guesstimate) how much time was likely to still be taken.
>From what you seem to be doing it sounds like you might only need a brief
>message - with the gauge if you think your users would prefer it.
PAUSE 3 USING 'Processing Inventory! Please wait until meter closes.' +
CAPTION 'Inventory Updates!' +
OPTION GAUGE_VISIBLE ON |other options
do updates
PAUSE 4 USING ' ' OPTION GAUGE_VISIBLE OFF -- turn the gauge off or you'll get
it next time as well.
CLS -- to clear the pause message from the screen
Hope that helps,
Regards,
Alastair.
----- Original Message -----
From: Jim Belisle
To: RBASE-L Mailing List
Sent: Monday, August 17, 2009 5:30 PM
Subject: [RBASE-L] - Re: PAUSE Command with Meter Progress Bar
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
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
