I can use the short names in the query, but the result-set beings back the alternate names.
I can work around it if needed, but it seems odd that even when specifying short names I get the long alternate names back.
date: Wed, 3 Nov 2021 18:59:11 +0000
from: Dean Eshleman <Dean.Eshleman@xxxxxxxxxxxx>
subject: RE: Question on Long Column Names Returned from SQL Query. I
Want Short Column Names
I assume you are running this statement via ODBC, JDBC etc. which is why it defaults to the long names. I haven't tested this, but I think you have to specify the short names in your select statement rather than use *. You wouldn't need the AS clause. So, just SELECT FIELD1, FIELD2, etc..
Software Development Architect
1110 North Main Street
PO Box 483
Goshen, IN 46527
(800) 348-7468 ext. 3528
(574) 533-9515 ext. 3528
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2022 by midrange.com 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
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.