[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?


The SQR lookup is both a table in the database and an array in your
computer's memory.  The sad part is: you can't access either except
through the load-lookup command.  It would be more efficient to skip the
load-lookup, select your pairs from the db using the same logic used to
load the lookup table and load these into an array that you can traverse
at will.  Chances are that if your lookup data set is small enough to
print at the end of the report, the load-lookup mechanism is not an
efficient way to do the lookup anyway.  (Just guessing here about the
size of the lookup table/array.)

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@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