Browse Lookups

Bruce Easton bruce at stn.com
Wed Jun 27 16:54:58 PDT 2018


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 then either all records have been 
selected that can be shown OR when filepro has enough records selected 
to show to fill up one browse screen's worth.
>
> 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 execution (for 
example):

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

Obviously your pushkey needs to be above the browse line in the program.
>
> @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/e442a311/attachment.html>


More information about the Filepro-list mailing list