Again, it's the tool.
In Run sql scripts I added this:
label on column LOOKUP_TABLE.LOOKUP_ITEM is 'Line1 Line2';
label on column LOOKUP_TABLE.LOOKUP_VALUE_CHARACTER is 'Eat Venison';
I've yet to figure out how to get it to display any of those values in the headings.

I get the long name with
select lookup_item from lookup_table;

I get the short name with
select C000000001 from t00000001;

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.