That prototype doesn't do what you think it does. That will convert the boolean value true to the string "true" and and false to "false" which obviously won't save into a bit column.

Look at the intBoolean Wonder prototype. You may need to set the Prototype to "intNumber" first, and then to "intBoolean" to get it to work as I think there is a bug in Entity Modeler that doesn't properly update the external type when changing to "intBoolean".

Dave

On Sep 22, 2009, at 10:25 AM, Freddie Tilley wrote:

the EOJDBCSQLServerPrototypes boolean type defaults to bit with a
custom data type as follows:

External Width: 5
Value Class: java.lang.Boolean
Value type: c
Factory Method: valueOf
Conversion Method: toString
Init Argument: String

2009/9/22 David Avendasora <webobje...@avendasora.com>:
Hi Freddie,

I don't believe Microsoft SQL Server has a boolean datatype. What datatype
are you using for the column in the DB?

Dave


On Sep 22, 2009, at 7:32 AM, Freddie Tilley wrote:

I have a problem with writing a boolean value to the database, using
the EOJDBCSQLServerPrototypes and the boolean type. I'm also
using Chuck Hills MicrosoftPlugin.

If I set the boolean to true when creating an object it actually sets
this value in the db when saving.

But if I edit the object again and set the boolean value to false. It
will show the value as false in the list, but it will remain True
in the database. And after this I cannot change the value to True anymore.

What's going on here?

Freddie Tilley
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:

http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com

This email sent to webobje...@avendasora.com




_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com

This email sent to webobje...@avendasora.com



_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to