Ricardo:
I use OpenBase and have boolean columns. I have mine modeled like the
first "boolean" prototype below. The prototype sets the valueType to
String and uses toString() to convert the java boolean to a 5
character varchar in the database (for "false"). The result is that it
actually writes "true" or "false" (String) to the database. So, your
column type in OpenBase should not be boolean, it should be varchar, 5.
I haven't used the approach of the intBoolean prototype.
I am not using the WOnder prototypes but Practical WebObjects also
describes modeling booleans in this fashion - which I like.
Tim
UCLA GSE&IS
On Mar 8, 2009, at 3:25 PM, Ricardo J. Parada wrote:
Hi Mike,
Not sure I understood what you mean by flag. :-)
Anyways, here's the boolean protototype from ERPrototypes as defined
in EOJDBCOpenBasePrototypes.plist:
{
adaptorValueConversionMethodName = toString;
columnName = "";
externalType = varchar;
factoryMethodArgumentType =
EOFactoryMethodArgumentIsNSString;
name = boolean;
valueClassName = "java.lang.Boolean";
valueFactoryMethodName = valueOf;
valueType = S;
width = 5;
},
and the intBoolean prototype is setup as follows:
{
adaptorValueConversionMethodName = toString;
columnName = "";
externalType = bool;
factoryMethodArgumentType =
EOFactoryMethodArgumentIsNSString;
name = intBoolean;
valueClassName = NSNumber;
valueFactoryMethodName = valueOf;
valueType = c;
},
I tried both and neither one works for me. Anybody out there using
OpenBase 10.0.11 with and boolean properties in your columns and EOs?
I've been trying all kinds of things to get these booleans to
work... And I just thought of one which might work. I'll change
the type in openbase for those columns back to integer type. Then
I'll use the intBoolean prototype from ERPrototypes. I assume
that's what the intBoolean prototype is for: to have a boolean in
your EO stored as an integer in the database. Right?
On Mar 8, 2009, at 10:20 AM, Mike Schrag wrote:
"boolean" in erp = varchar, not boolean, "intBoolean" in erp =
number, "flag" = probably what OB is calling "boolean", but you'd
have to check if the OB variant of erp declares this properly.
ms
On Mar 8, 2009, at 3:06 AM, Ricardo J. Parada wrote:
Hi All,
There seems to be something wrong with booleans when using
OpenBase and ERPrototypes.
In OpenBaseManager the column type for my column says boolean:
<Picture 2.png>
In openisql (command line) I can query like this:
select count(*) from cliente where suspendido = true
of like this:
select count(*) from cliente where suspendido = 1
In entity modeler, if I configure my attribute using the boolean
prototype from ERPrototypes as shown below, then the queries don't
return the right number of rows. The update statements generated
by EOF don't work either (even though they look right).
If I model my attribute as an integer then the queries work okay
and the update statements issued by EOF work too. By I don't like
having an Integer in my accessor methods in my EO for a boolean
column. I want to use boolean.
Looking at the screenshot below, does this look like the boolean
prototype is setting the fields correctly for a boolean column in
OpenBase? Anybody wants to guess? Anybody using booleans in
OpenBase and ERPrototypes?
<Picture 1.png>
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San
Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the
Enterprise
-Strategies to boost innovation and cut costs with open source
participation
-Receive a $600 discount off the registration fee with the source
code: SFAD
http://p.sf.net/sfu/XcvMzF8H_______________________________________________
Wonder-disc mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wonder-disc
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San
Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the
Enterprise
-Strategies to boost innovation and cut costs with open source
participation
-Receive a $600 discount off the registration fee with the source
code: SFAD
http://p.sf.net/sfu/XcvMzF8H_______________________________________________
Wonder-disc mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wonder-disc
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com
This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
