• 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: Ken Anderson <email@hidden>
  • Date: Thu, 3 Jul 2008 09:28:58 -0400

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
  • Follow-Ups:
    • Re: Saving Values with EOF
      • From: Guido Neitzer <email@hidden>
References: 
 >Saving Values with EOF (From: Gino Pacitti <email@hidden>)

  • Prev by Date: Re: WOLips shortcuts ??
  • Next by Date: Re: Saving Values with EOF
  • Previous by thread: Saving Values with EOF
  • Next by thread: Re: Saving Values with EOF
  • Index(es):
    • Date
    • Thread