Tony P
|
Posted: 05/03/2005, 1:41 PM |
|
Running CC Studio 2.3.2.24
Connecting to a SQL 2000 server, very simple database, with one field as a Bit type. I've specified it to use a checkbox.
What I noticed was that when I try to save the data on a maintenance screen, I get an error message: Invalid column name 'true'.
(or it says 'false' if the checkbox is UNCHECKED). Now, if I change the type of the checkbox to Integer, instead of Boolean, it appears to work fine.
In both cases, the true value property is set to 1, and the false value property is set to 0.
I can certainly go through my generated screens and change the checkbox type from Bit to Integer, but I shouldn't have to.
How do I make this work propertly?
Thanks, Tony
|
|
|
peterr
Posts: 5971
|
Posted: 05/03/2005, 1:53 PM |
|
Looks like the Boolean format for your database is specified incorrectly.
Set it up in Connections -> (connection name) -> Server.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Tony
|
Posted: 05/03/2005, 5:16 PM |
|
Awesome! That fixed it! Thank you, and thanks for the lighting-fast response.
Tony
|
|
|
|