Browse lookup

[GCC Consulting]

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com 
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf 
> Of Kenneth Brody
> Sent: Thursday, December 16, 2004 10:30 AM
> To: rkreiss at gccconsulting.net
> Cc: Filepro 2 List
> Subject: Re: Browse lookup
> 
> GCC Consulting wrote:
> [...]
> > However, the routine drops through and also shows lookup field no 
> > found on the line that reads
> > 
> >         if: @bk = "S" and foobar(40) = ""
> >     then: in=foobar(1);ia=foobar(6) .........
> [...]
> > I think we need a way to more gracefully trap browse lookup 
> errors.  
> > Yes, we can do a lookup first to make sure that is at least 
> one record 
> > matching the lookup criteria and if not display our own 
> message or run 
> > some other routine.  However, in my can I received the 
> standard browse 
> > error and then the drop routine executed, I think, causing 
> the second error.
> 
> is there any reason you couldn't check for "not foobar" to 
> see if the lookup didn't get a record?
> 

Here is the processing in question.  Are you indicating that Not postar could be inserted at line 97?



───────────────────────────────────────────────────────────────────────────────
 95  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: bc="*3           *14           $*6             *40"
 96  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: lookup pros = postar  k=1    i=1 -nxm b=(ba&bb&bc)
 97  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:         @sk="BRKY" or  @bk = "X"
       Then:         GOTO is_exit
 98  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:         @bk = "E"
       Then:         GOTO is_end
 99  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:         @bk = "R"
       Then:         FLAG="5";CLEARB;GOTO review
100  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:         @bk = "S" and pros(40) = ""
       Then:         in=pros(3);pr=pros(14);id=pros(5);pros(40)=pros(6)-pros(39)


Richard Kreiss
GCC Consulting