Return
-
Title
Using the SUBSTR function in a calculated field in Query Builder produces the wrong syntax -
Description
If I connect using ODBC, does not matter which database platform it is for, and I try to create a calculated field in the Query Builder using the SUBSTR function, the query does not come out correct. It includes a From and For in the syntax, instead of commas.
It looks like...
,SELECT SUBSTR(NUM_TEST."COL1" FROM 1 FOR 3) AS sub_col
FROM "5050".NUM_TEST NUM_TEST
,...instead of...
,SELECT SUBSTR(NUM_TEST."COL1", 1, 3) AS sub_col
FROM "5050".NUM_TEST NUM_TEST -
Resolution
WORKAROUND #1:
Connect using a native client of the database platform you are using, instead of ODBC. This will not be possible for all database platforms.
WORKAROUND #2:
Manually edit the SUBSTR syntax in the calculated field before clicking OK to submit it to the query builder.
STATUS:
Waiting for fix to be released in a future version of Toad for Data Analysts. -
Defect ID
ST88624