I found this out the hard way not so long ago myself..... Excerpt from BMC(r) Remedy(r) Action Request System(r) 7.0 Form and Application Objects For real fields, the representation in the database keeps a maximum of 10 digits worth of data. After 10 digits, the number is rounded, and the succeeding digits are ignored. For example, if 12345.090009 is entered, the value after a submit is 12345.090010. But, if 1234567.090099 is entered, the value after a submit is 1234567.090000. The last three digits are ignored because the rounded answer comes after the 10th position.
Try a decimal field instead? Thanks, Jonathan Jones Southern Company Services 205-257-4799 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Monday, June 23, 2008 1:55 PM To: [email protected] Subject: Question about Real field type in a form Hi: I am trying to store 12 digit number in a Real field. When I send the data via API, I send a value 633813768390. But when I query remedy database, this field value shows as [EMAIL PROTECTED]> select NUMERIC_REP from aradmin.sprint_mns_worklog; NUMERIC_REP ------------ 633813768400 633813768400 Any one have ideas why the value gets rounded up ? Thanks Ravi ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
