Return
-
Title
Error executing SQL in Query Builder errors "Implicit conversion from datatype" -
Description
Using Sybase connection, the Query Builder is used to build a query between two tables. This error occurs running the query:
"Sybase Database Error: Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed.
Use the CONVERT function to run this query." -
Cause
Change tables columns that are used to related the tables and ensure they are both of the same data type.
-
Resolution