Forum Discussion
Solved
ODBC --call failed. [Sage][Support] (40190) Data conversion algorithm not supported for...
ODBC --call failed. [Sage][Support] (40190) Data conversion algorithm not supported for SQL_BIT to SQL_TYPE_DATE. (#40190) I'm trying to execute an update statement in MS Access using the followi...
- In most other databases other than Access, the values for True and False would be 1 and 0, not -1 and 0. They appear to be in a Bit field in this database, and that's where 1 and 0 would be used.
Have you tried the Boolean constants TRUE and FALSE?
Thanks Ken. Also tried that but I when I realized that my mistake was really in the where clause. I was using a boolean field with a between operator using date values. Once that was corrected, error no more.