RE: [sqr-users] Debugging a Lookup Table

["Alexander, Steve" <Steve.Alexander@ci.sj.ca.us>]

I assumed that the lookup was merely a device to determine whether a value
existed on the table, and it didn't matter what the return value was.

-----Original Message-----
From: Don Mellen [mailto:donm@ontko.com]
Sent: Friday, August 01, 2003 2:19 PM
To: SQR Users Group (E-mail)
Subject: RE: [sqr-users] Debugging a Lookup Table


On Fri, 1 Aug 2003, White, Denise wrote:

> Rick,
> 
> Steve and clark suggested that I might be retrieving trailing spaces.  I
> have confimed that this isn't so.  Thanks for the suggestion, though!

Did you check both the value from department@smarttime and the key
construction for the lookup?  The lookup has to match character per
character.

Also, since I was curious before, it looks like your key for looking up 
contains your return value.  I assume this was a typo when you posted the 
code?

> > >    load-lookup
> > >       name=departments
> > >       table=department@smarttime
> > >       key=to_char(division_number,'09999')||department
> > >       return_value=department
> > >       rows=9999

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users