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.
WORKAROUND:
Manually change the = True or = False in the query to i.e. = ‘True’ , = ‘False’, = 1 or = 0.
STATUS:
Issue fixed in version 4.0. The latest version of Toad Data Point can be downloaded here.