Browse problem

Richard Kreiss rkreiss at gccconsulting.net
Mon Feb 22 09:04:57 PST 2021


Thanks for your response,

As I indicated the file being the browse is looking as had to records and everything appears when I run the browse programming in my test file using @keyT to activate the browse.

I haver used this type of programming before and ac should take on the value indicated as I have used AA,AB, & Ac in multiple browses in one program. I have also used Ba BB, and BC to do this same thing.  I have a feeling that the issue is being caused by filePro not allocating enough memory to this processing as This is the same processing that causes me to have difficulty with long variables not accepting assignments until I commented out or deleted long variables that were not being used in this processing table. Once removed the new long variables were able accept assignment.  This indicates a filePro issue and not a programming issue ( it may be in that the processing has hit a limit as to what filePro can handle which is not documented anywhere.  I have been at this a long time and never had an issue like reaching the limit of what a process table can handle.

The only thing support Fp Tech support offered was the environmental variable to change the number of labels that filePro could handle in a processing table. I have to wonder if that also would have changed the number of long variables that the process could handle to solve the issue I am currently having with this browse lookup. As I do not need this browse for production, I can removed it form my programming without an issue but I would still like to know why the browse window comes up but not records are displayed when there are so few record to display and only and 1 key option "S" to select the desired value for the line that is highlighted.



> -----Original Message-----
> From: Filepro-list <filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com>
> On Behalf Of Bruce Easton via Filepro-list
> Sent: Friday, February 19, 2021 5:10 PM
> To: filepro-list at lists.celestial.com
> Subject: Re: Browse problem
> 
> Since you say the browse box is appearing, but no records appear, I would check
> that dummy "AC" is not already being used for another purpose, thereby
> overriding part of your browse definition.
> 
> Also, does the clerk call for this indicate a qualifier (via "-m")?  And if so, are you
> sure you're looking at the right data set for the file
> "testccnumbersforcardworks"?
> 
> --
> Bruce Easton
> STN, Inc.
> 
> 
> 
> On 2/19/21 2:41 PM, Richard Kreiss via Filepro-list wrote:
> > Again thank to everyone who responded.
> >
> > However, no one addressed the main issue I am having.  The browse window
> comes up but no records appear.  I copied the processing out to another file and
> everything works as it should.
> >
> > This is in the file which had issues with the long variables not able to accept a
> value. I am not sure if this is a memory issue or something else.  I added the
> busybox option to see if the records are being accessed.
> >
> > I am going to added an @key function and a GOTO to test the browse.  Again
> there are only 6 records that should appear. The file has only 10 records total.
> >
> > Browse code:
> >
> > 63  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >         ◄ If:
> >         Then: AA="(brw=10 xkey=XS show=keep pop=0 fill=asc,top)"
> >   64  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >         ◄ If:
> >         Then: AB="[ Card Type     Card Number    Exp Date    Security Key]"
> >   65  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >         ◄ If:
> >         Then: AC="*1         *3               *2           *4"
> >   66  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >         ◄ If:
> >         Then: lv="a"
> > 68  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> > busy   ◄ If:
> >         Then: Busybox "Looking for Records"
> >   69  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >         ◄ If:         busy
> >         Then:         MSGBOX "Busybox is running"
> >   70  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> > lokcard◄ If:
> >         Then: lookup test = testccnumbersforcardworks k=lv i=A -NG
> b=(AA&AB&AC)
> >   71  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >         ◄ If:         @bk = "S"
> >         Then:         CCnumber=test(3);display;CLEARB;MSGBOX "The letter S was
> Pressed"
> >   72  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >         ◄ If:         @sk = "BRKY" or @bk= "X" or @bk = "s"
> >         Then:         CLEARB
> > 73  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >        ◄ If:         @sk = "BRKY" or @bk = "X" or @bk = "S"
> >        Then:         Exit
> > 74  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> >        ◄ If:         @bk ne ""
> >        Then:         MSGBOX "The key Was pressed"<@bk<"at line"<@li
> >
> >
> > Thisa is the code that does not display any records when run from ther
> transaction file in a called process.  It does display the records when run form an
> @keyT option in my test file.  The processing was saved and loaded into the test
> file input processing. The file is names "TEST".
> >
> >
> >> 2/16/2021 2:32 PM, Richard Kreiss via Filepro-list wrote:
> >>> I have a new browse that is not showing any records in the processing table
> >> that has the code.  If I move the same processing to a test file al of the
> browse
> >> records appear. There are only 6 records in the file and the index has all 6.  I
> am
> >> only using this to test the programming as I need on of the values from the
> >> browse record.  I do not want to hard code the value as I need to use at least
> 4
> >> of the values which are 15 or 16 number long.  At my age I can't remember
> these
> >> numbers and it was easier to program the browse.
> >>>
> >>> The browse does not have a drop in it as I need all of the records.  As I
> >> indicated nothing appears in the browse window in the primary program but
> the
> >> records do appear in the test file when using an @key command.
> >>>
> >>> I am running this on both filePro (windows) 5.8.03 and 6.0.02.  the problem
> >> exists with both versions.
> >>>
> >>> By the way this is the same processing that had the issue with the long
> >> variables.
> >>>
> >>>
> >>>
> >>>
> >>> Richard Kreiss
> >>> GCC Consulting
> >>>
> >>>
> >>> -------------- next part -------------- A non-text attachment was
> >>> scrubbed...
> >>> Name: winmail.dat
> >>> Type: application/ms-tnef
> >>> Size: 14591 bytes
> >>> Desc: not available
> >>> URL:
> >>> <http://mailman.celestial.com/pipermail/filepro-list/attachments/20210
> >>> 216/b752863a/attachment.bin>
> >>> _______________________________________________
> >>> Filepro-list mailing list
> >>> Filepro-list at lists.celestial.com
> >>> Subscribe/Unsubscribe/Subscription Changes
> >>> http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>
> >> --
> >> Nancy Palmquist         MOS & filePro Training Available
> >> Virtual Software Systems    Web Based Training and Consulting
> >> PHONE: (412) 835-9417           Web site:  http://www.vss3.com
> >>
> >> -------------- next part --------------
> >> An HTML attachment was scrubbed...
> >> URL: <http://mailman.celestial.com/pipermail/filepro-
> >> list/attachments/20210217/8ea03a81/attachment.html>
> >> _______________________________________________
> >> Filepro-list mailing list
> >> Filepro-list at lists.celestial.com
> >> Subscribe/Unsubscribe/Subscription Changes
> >> http://mailman.celestial.com/mailman/listinfo/filepro-list
> > -------------- next part --------------
> > A non-text attachment was scrubbed...
> > Name: winmail.dat
> > Type: application/ms-tnef
> > Size: 15083 bytes
> > Desc: not available
> > URL: <http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20210219/70126f67/attachment.bin>
> > _______________________________________________
> > Filepro-list mailing list
> > 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
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 16795 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20210222/1af61b77/attachment.bin>


More information about the Filepro-list mailing list