Return
-
Title
Query Builder generates wrong SQL query on BIT datatype. Error: “Lookup Error. Invalid column name ‘True’.” -
Description
Query Builder generates or creates invalid SQL query on BIT data type.
Error:
“Lookup Error. Invalid column name ‘True’.”Query Builder error on BIT data type (similar to Boolean). The query that Toad builds does not run and gets the error below. Manually changing the where condition from i.e. = True or = False in the query to i.e. = ‘True’, = ‘False’, = 1 or = 0, then it will run fine.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.