I have an application I inherited written in VB6 using crystal 9. There are some reports that, while working fine in the original production executable, give me the "A boolean is required" error when I try to run them in the development environment. I managed to trace one of them down and found it's occuring in this formula:
if {tblVendorControlFile.CHARTER_FLAG} = 1 then
"Charter"
else
"Non-Charter"
The editor states that the 1 should be a boolean value and when I change it to a boolean it does work. Note that this works fine in the installed version of the executable, but I'm getting the error in development, even though I have the same source code the original was compiled from.
The database backend is SQL 2005 and the data type of that field is bit.
Can anyone tell me what might be causing this?
IP Logged
