Rename Linked Table Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm currently in the process of trying to make it easier for others to learn
how to use ODBC to query our AS400. I have created a template that has a
number of tables listed on it. I have also given meaningful names to the
linked tables that I included (our ERP system uses numbers to name the
files). I would now like to rename or give an alias to the column headings
in each linked table. Is this possible? If so how?

Thanks!
 
Return the rows from each liked table in a query, giving aliases to each
column, e.g.

SELECT
SomeColumn AS SomeThing,
SomeOtherColumn AS SomeThingElse
FROM YourTable;

You can of course then base other queries on these queries if you wish

Ken Sheridan
Stafford, England
 
I thought about that, but I wanted to keep my table seperate from my tables.
No way to just give an alias to an existing table column? I may do have to
do your suggestion as I would also like to put some edit masks on the data
(numbers are stored as integers and decimal places are a function of our ERP
systems display screen).

Thanks for input Ken!
 
It’s the only way with a linked tabledef object as far as I know.

Ken Sheridan
Stafford, England
 
Back
Top