CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> .NET

 Coder

Print topic Send  topic

Author Message
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
View profile  Send private message
Tony
Posted: 05/03/2005, 5:16 PM

Awesome! That fixed it! Thank you, and thanks for the lighting-fast response.

Tony

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.