Browse lookup field not found error

Richard Kreiss rkreiss at verizon.net
Mon Jan 19 16:01:31 PST 2015


Top post:

Thanks to all who responded.

The error in my program is that I can't have one browse which excepts keys and the other which can't programmed as I have done.

Apparently when the browse is executed even with show=only, the code below, with the @bk,  is checked, and although no record has been selected, the program executes the lookup - field not found error

I broke the programming into 2 separate browse lookups and the error stopped.

I tried to avoid writing two separate browses.  One browse excepts no key strokes and the other one that does.  Only specific users will have the "live browse"

Richard

> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Bruce Easton
> Sent: Monday, January 19, 2015 3:40 PM
> To: filepro-list at lists.celestial.com
> Subject: Re: Browse lookup field not found error
> 
> Good point.  Since he is seeing a difference in behavior, I think being that his
> wizard-defined browse lacks the "drop" processing, there is more likelihood
> of that deficiency making itself known  (because of
> exiting from the browse from different data shown in the browse).    But
> yes - I would think he should even get the error when cancelling from the
> browse from not checking 'not tran'.  Of course we are not seeing all the
> code - maybe he has break turned off.
> 
> Bruce
> 
> On 1/19/15 2:40 PM, Craig Tooker wrote:
> > Could it be that the lookup is not finding a valid record?
> >
> > You are not checking to see if the lookup succeeds.  On the line after
> > the lookup you need a 'not tran' (check failure condition) that will
> > preclude any reference to 'tran'.  This is required because you used
> > the 'n' flag to lookup which tells filePro that you are going to deal
> > with lookup failures.
> >
> > Craig
> >
> > On 01/19/15 12:47, Richard Kreiss wrote:
> >> Windows
> >>
> >> Filepro 5.7.03.07
> >>
> >> I have the following code for a browse lookup which when executed
> >> displays the field not found error at an @bk when the option has not
> >> been selected.
> >>
> >> The problem is at line 196 & 197 which executes the browse. If I use
> >> the browse created by the wizard, no error occurs (line 196).  If I
> >> use the browse command at 197, it appears that the @bk = "c' line
> >> executes and the field not found error occurs.
> >>
> >> If I use the debugger, the browse appears and line 200 shows as false
> >> as @bk is empty.
> >>
> >> If it is empty as line 200, why is line 201 executing as @bk is empty.
> >>
> >> More to the point, as I indicated, the programming works correctly
> >> when run from a wizard created browse?
> >>
> >> Anyone see why I am having this problem as other browses written
> >> similarly work properly.
> >>
> >>
> >> Richard Kreiss
> >> GCC Consulting
> >>
> >>
> >>
> >> do_brow◄ If:
> >>         Then: sn=@sn;switchto "tran"
> >> 190  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If: IsCard = "Y"
> >>         Then: SHOW POPUP("2","-1") "\r 1,2, or X \r-Cancel, \r C
> >> \r-Change to CC, \r R \r-Run CC"
> >> 191  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >> sho_brw◄ If: IsCard = "Y"
> >>         Then: aa="(brw=14,6,-1 xkey=12crx show=pkeep prc=dr_tran
> >> fill=asc,top)"
> >> 192  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If: IsCard ne "Y"
> >>         Then: aa="(brw=14,6,-1 show=only prc=dr_tran fill=asc,top)"
> >> 193  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:
> >>         Then: ab="[\b6Journal     Date    TY  St  Due Paid     Date
> >> Last 4     \a-"
> >> 194  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:
> >>         Then: ac="*1      *7         *18*3*9        *40 *39"{""
> >> 195  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:
> >>         Then: debug on
> >> 196  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:
> >>         Then: 'lookup tran = transaction  k=16   i=E -Nxm b="(brw=14
> >> xkey=12crx show-pkeep fill=asc,top)[Header]*1 *7              "
> >> 197  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:
> >>         Then: lookup tran = transaction  k=16   i=E -Nxm b=(aa&ab&ac)
> >> 198  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:         @bk = "1" or @bk = "2" or @bk = "x"
> >>         Then:         CLEARB;CLEARS;switchto (sn);end
> >> 199  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:         @bk="C" and tran(6) ne "CH" and tran(33) lt "6"
> >>         Then:         ERRORBOX "Transaction Not a CH-Check";GOTO sho_brw
> >> 200  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:         @bk="C" and tran(33) = "6"
> >>         Then:         ERRORBOX "Transaction Already Paid";GOTO sho_brw
> >> 201  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:         @bk="C" and tran(6) = "CC" and tran(33) lt "6"
> >>         Then:         MSGBOX "\b2 Transaction already a credit card
> >> \a-";GOTO sho_brw
> >> 202  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:         @bk="C" and tran(6) = "CC" and tran(33) = "6"
> >>         Then:         MSGBOX "\b2 Transaction already a credit card
> >> and Paid \a-
> >> 203  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:         @bk="C" and tran(6) = "CH" and tran(33) lt "6"
> >>         Then:         rn=tran(@rn);GOTO chg_typ
> >> 204  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:         @bk="C" and tran(6) ne "CC" and tran(33) = "6"
> >>         Then:         ERRORBOX "Transaction Payment type Can't be
> >> changed\nAlready Paid";GOTO sho_brw
> >> 205  -------   -   -   -   -   -   -   -   -   -   -   -   - -   -
> >> -   -
> >>         ◄ If:         @bk="C" and tran(6) ne "CC" and tran(33) = "9"
> >>         Then:         ERRORBOX "Transaction Payment type Can't be
> >> changed\n CANCELLED;GOTO show_brw
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> 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
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list



More information about the Filepro-list mailing list