×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
OK, apparently my testing skills weren't as methodical as I thought.
I went back and re-tested and the issue only occurs with STRSQL.
Works fine by specifying the short field names in a query using JDBC (ACS, DBeaver) and probably ODBC as well. Testing shortly.
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Richard Schoen
Sent: Wednesday, November 3, 2021 3:14 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: RE: Question on Long Column Names Returned from SQL Query. I Want Short Column Names
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
After a little more testing it appears that if there is a "Heading Line 1" defined for a column that heading gets returned instead of the actual field name in all cases.
Does the field you mention have a heading line 1 label on it ?
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
midrange.com
