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.
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.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center