ODBC connection gives error when filtering on a boolean field
I have an ODBC connection that has entities with boolean fields. When I try to create a query filter on one of these fields, I get the following error:
ERROR: Exception Type : InvalidExecuteQueryException
Message : The following error has occurred in the ODBC Connector: ERROR [42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'False'.
The field map shows the field as a boolean type and I've tried all of the following values with no luck: false, 'false', 0, FALSE()