• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Saving Values with EOF
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Saving Values with EOF


  • Subject: Re: Saving Values with EOF
  • From: Guido Neitzer <email@hidden>
  • Date: Thu, 3 Jul 2008 09:49:21 -0600

And you probably don't want a double but a Decimal in the database either if you want some reliable behaviour. Or you could just go with a Double in Java.

cug

On 03.07.2008, at 07:28, Ken Anderson wrote:

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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden

-- http://www.event-s.net

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


References: 
 >Saving Values with EOF (From: Gino Pacitti <email@hidden>)
 >Re: Saving Values with EOF (From: Ken Anderson <email@hidden>)

  • Prev by Date: Re: Saving Values with EOF
  • Next by Date: DB uniqueness constraints and dealing with them
  • Previous by thread: Re: Saving Values with EOF
  • Next by thread: WOLips shortcuts ??
  • Index(es):
    • Date
    • Thread