Gino,

What you have doesn't make sense. Precision is the total number of digits, and scale is the total number to the right of the decimal point.

My guess is you really want a precision of 30 and a scale of 6, not the other way around.

Ken

On Jul 2, 2008, at 12:27 PM, Gino Pacitti wrote:

Hi all

I have a model set up which has a value for a premium.

In EOModeller I have the Internal Type set to Decimal Number with a Precision of 6 and external Scale of 30

The external type is a Double in Mysql

ANNUALPREMIUM` double(31,30) default NULL

When the premium is calculated I can see the value - something like: 141.755640000

but in the database it is defaulting to 10

Any idea why this could be happening?

WO 5.3.*
10.4.11
Mysql 4.11.*
mysql-connector-java-5.0.6-bin.jar

Gino
_______________________________________________
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/kenlists%40anderhome.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]

Reply via email to