IN Toad Data Point - 184.108.40.2063 - in the Build query box, if i have a table/view with a long column name it will truncate the column to 30 characters.
column name = cumulativeNonRecoverableInterest
truncated name = cumulativeNonRecoverableIntere
How do I stop this. The query will not run - it gives the error the field does not exist.
I can query just fine in Edit mode.
I'm not seeing this in my limited testing, not with my mainstream relational databases anyway (SQL Server, Oracle, etc.)
Can you share what data source/version you're trying to build the query for? Can you share a screen snap?
Also, see if this option might help:
Please observe attached screen shot, I am using it on Teradata.. i have show both Correct column name
LEft shows -- Truncated column names
right Shows -- Correct Column names
To stop Toad Data Poin from truncating column names in the Buld Query box, you can change settings by going to Tools > Options > Database > Object Explorer and changing the value of "maximym column name length in characters" to a higher value to set it to zero to remove the limit. This should allow you ti use the full column name in the query and avoid the error