Browse Lookups

Bruce Easton bruce at stn.com
Wed Jun 27 17:08:48 PDT 2018


Oh my - let's me try this again hopefully with fewer typos...lol.  Also 
a bit more clarification.

Response made inline.  --Bruce

On 6/27/18 6:20 PM, Richard Kreiss wrote:
>
> The problem is that this would require user input as processing stops 
> once all the records are selected.
>
OR *program input* - which is why Bill mentioned using pushkey. And 
actually I believe processing stops when either a) all records have been 
selected that can be shown OR b) when filepro has enough records 
selected to show to fill up one browse screen's worth. (Whichever comes 
first.)
>
> That is why there needs to be some way to have a browse lookup do 
> something without user input.
>
And there is - pushkey.  Keep in mind that the "exit key" defined in the 
browse can be almost anything.  It could be "P" for "proceed!".  It 
shouldn't be advertised to the end user - it's only needed in 
conjunction with @bk to allow you to have the program execute (for example):

a) clear a message, then
b) repeat the browse with "pkeep" on to keep the place in the browse

Obviously your pushkey needs to be above the browse line in the 
program.  At least initially.  I can see how one might reuse pushkey as 
part of browse processing under certain conditions.


On 6/27/18 6:20 PM, Richard Kreiss wrote:
>
> The problem is that this would require user input as processing stops 
> once all the records are selected.  That is why there needs to be some 
> way to have a browse lookup do something without user input.
>
> @bk is the only way a browse does anything once the records have been 
> selected.  Even then, the acceptable key strokes are defined as part 
> of the command line.  That is why adding an option for a length of 
> time would be workable.  The sub-routine name can be either fixes or 
> be another renvirnmental variable such as PFBrowseSub.  That could be 
> set from the command line or passed as a –BW option with the *clerk or 
> *report command.
>
> An option such as this would allow a browse to be updated 
> automatically.  And yes I did need this for a programming job I was 
> considering.  Without such an option, I had to pass on the job.
>
> Richard Kreiss
>
> GCC Consulting
>
> *From:*William J. McEachran [mailto:bill.mceachran at gmail.com]
> *Sent:* Tuesday, June 26, 2018 1:01 PM
> *To:* rkreiss at verizon.net
> *Cc:* Bruce Easton <bruce at stn.com>; Filepro 2 List 
> <filepro-list at lists.celestial.com>
> *Subject:* Re: Browse Lookups
>
> You could probably do that ...
>
> Record the current time into a variable before the browse starts.
>
> In the browse processing compare the current time the original time.
>
> When your desired time has passed 'drop all' -- you'd need a pushkey 
> set to get you out of the browse and continue with your 'out of time' 
> routine.
>
> The devil is in the details of course.
>
>
> --
>
> Bill McEachran
>
> bill.mceachran at gmail.com <mailto:bill.mceachran at gmail.com>
>
> http://www.wjmceachran.com
>
> http://www.fileproprogramming.com
>
> https://ca.linkedin.com/in/bill-mceachran-82a56114
>
> On Tue, Jun 26, 2018 at 11:39 AM Richard Kreiss via Filepro-list 
> <filepro-list at lists.celestial.com 
> <mailto:filepro-list at lists.celestial.com>> wrote:
>
>     Problem with your not tried suggestion is that the browse lookup
>     occurs outside the normal processing and will not see anything
>     done outside the browse that’s why the @bk option.
>
>     I would love to be able to set a timer for a browse which would
>     execute a sub-routine. One could then put up or take down a show
>     pop up.  What I really wanted was the ability to have the browse
>     re-execute to add or delete records. This would also allow for the
>     closing of a browse if nothing is happening or putting up a msgbox
>     which requires a response. No response in a given fine the. Record
>     is exited. This is similar to what happens on some websites where
>     one is prompted about logging out after a. Set time of inactivity.
>
>     In my example, the programmer would be responsible for deciding if
>     the record should be saved first or just cancelled thereby losing
>     any changes made.
>
>     Richard
>     Sent from my iPhone
>
>     > On Jun 25, 2018, at 10:28 PM, Richard Kreiss via Filepro-list
>     <filepro-list at lists.celestial.com
>     <mailto:filepro-list at lists.celestial.com>> wrote:
>     >
>     > I did this years ago be counting the records to appear in the
>     lookup or report and the dividing by the length of the scroll bar.
>     That let me know how many records had to be processed before
>     setting a 1 character field’s value to a graphic character for
>     display. Ds=ds{ds when the execution value was met. You can even
>     put up % complete values or display that value as a show.
>     >
>     > With a browse, you will need to set this as a subroutine to be
>     run along with Any other processing. Keep in mind that once all
>     the records are selected in a browse, moving through the records
>     will cause the scroll routine to run again. You will need to block
>     any key strokes that cause the browse to execute this sub routine.
>     >
>     > For Windows based computers, I have not seen the issue of a
>     browse appearing to be frozen. This was an issue in the early ‘90’s.
>     >
>     > As for the report output, this was done for a client’s
>     bookkeeper so that she could glance at a screen and have a visual
>     idea of how far along the report generation was. Again, the speed
>     of today’s machines has made this unnecessary.
>     >
>     > Richard
>     > Sent from my iPhone
>     >
>     >> On Jun 25, 2018, at 3:40 PM, Walter Vaughan Jr via Filepro-list
>     <filepro-list at lists.celestial.com
>     <mailto:filepro-list at lists.celestial.com>> wrote:
>     >>
>     >> I had sort of the same Idea that one could show boxes/lines
>     incrementing across the bottom of the screen  like  the illusion
>     of a progress bar, however I'm curious how one would trap  knowing
>     that you are not locked up. How would you know in the "prc= " code
>     that you had gotten to the end and need to take it down? Typically
>     after the browse I've only  checked for @bk keys. So one could
>     change the show box status to "Completed" before checking for @bk's?
>     >>
>     >>
>     >>
>     >> -----Original Message-----
>     >> From: Filepro-list [mailto:filepro-list-bounces+wvaughan
>     <mailto:filepro-list-bounces%2Bwvaughan>=steelerubber.com at lists.celestial.com
>     <mailto:steelerubber.com at lists.celestial.com>] On Behalf Of
>     Fairlight via Filepro-list
>     >> Sent: Monday, June 25, 2018 3:24 PM
>     >> To: filepro-list at lists.celestial.com
>     <mailto:filepro-list at lists.celestial.com>
>     >> Subject: Re: Browse Lookups
>     >>
>     >> 1) Before your lookup, do a SHOW (or other NON-blocking) text
>     display.
>     >>
>     >> 2) Set an increment counter to zero.
>     >>
>     >> 3) Every time that code block is executed, increment your
>     counter.  If you want to handle it in multiples of 'x', do the
>     calculation to determine if you're on that multiple (of, say...100
>     or 1000).
>     >>
>     >> 4) Every time it's time to print the message, update it with
>     the incremented counter.
>     >>
>     >> 5) After the lookup is complete, take down or otherwise paint
>     over your text display.
>     >>
>     >> 6) Profit.
>     >>
>     >> m->
>     >>
>     >> On Mon, Jun 25, 2018 at 03:06:24PM -0400, Scott Walker via
>     Filepro-list thus spoke:
>     >>> I'm doing a browse lookup.
>     >>>
>     >>> There is some code executed for each record which causes many
>     of them
>     >>> to be dropped  (that is good).
>     >>>
>     >>> But when a lot of records are dropped (like thousands) I want
>     to flash
>     >>> a message telling the customer that the system is doing some
>     searching
>     >>> and is not "frozen".  When the system is not actively
>     searching for
>     >>> records to include, (like when it's filled up the entire
>     browse lookup
>     >>> window) I want this message to be cleared or when it's gotten
>     to the
>     >>> end of the file it is searching through.
>     >>>
>     >>> Has anyone figure out how to do this?
>     >>>
>     >>> I'm having trouble figuring out where the right place to put
>     the code
>     >
>     > _______________________________________________
>     > Filepro-list mailing list
>     > Filepro-list at lists.celestial.com
>     <mailto:Filepro-list at lists.celestial.com>
>     > Subscribe/Unsubscribe/Subscription Changes
>     > http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>     _______________________________________________
>     Filepro-list mailing list
>     Filepro-list at lists.celestial.com
>     <mailto:Filepro-list at lists.celestial.com>
>     Subscribe/Unsubscribe/Subscription Changes
>     http://mailman.celestial.com/mailman/listinfo/filepro-list
>



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180627/fbc5f261/attachment.html>


More information about the Filepro-list mailing list