[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Printing Entire Lookup Table?

Matt,

This may not be exactly what you are looking for but it does allow iterating 
through a LOAD-LOOKUP (in Oracle at least).

LET $WHERE = 'ROWNUM < 100'
Load-Lookup
  NAME  = TEST
  Table = PS_DEPARTMENT_TBL
  Key   = ROWNUM
  Return_value =DESCR||'|'||DESCRSHORT
  WHERE = $WHERE

LET #COUNTER = 1
WHILE 1
    MOVE #COUNTER TO $X 9999999999999999
    LET $X = LTRIM($X,' ')
    LOOKUP TEST $X $Z               
    IF $Z = ''
        BREAK
    END-IF
    SHOW $X ' '  $Z
    LET #COUNTER = #COUNTER + 1
END-WHILE

Jim

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of
Matt Rogish
Sent: Tuesday, July 26, 2005 9:19 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Printing Entire Lookup Table?


List members:

If you reply, could you reply directly to me as well as the list since I 
receive a digest and sometimes it takes a while for that to end up in my 
inbox. Thanks!

I have a lookup table which stores some code -> description combinations 
(somewhat more complicated than that). What I'd like to do is iterate over 
the entire thing so I can print out the code -> description pairs as some 
sort of a footnote at the bottom of the report.

I can do something goofy like put all of the codes in an array and iterate 
through them and perform a lookup, but that's not really optimal (I might 
as well store the description in the array and not use the lookup table to 
begin with). Otherwise I have to hard code the descriptions etc. at the 
bottom and since the codes are dynamic then, well, that won't work either.

There's no real good alternative -- I need to be able to go over the entire 
lookup table. Anything else is going to be sucky, but if there's no way, 
then I'll take advice as to which is the least sucky method. :)

Thanks,

--
Matt Rogish
Programmer
Advancement Services
Miami University


_______________________________________________
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