The answer is yes 2033.00 == 2.033_E3 (mathematically) if you are trying to maintain a XXXX.YY format - you need to have a field formatted for that decimal type and then push from the decimal into the char.
On Mon, Jan 4, 2010 at 8:34 AM, LJ Longwing <[email protected]> wrote: > ** > And you are sure that the field you are pushing to is a Char field? > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Kemes, Lisa > *Sent:* Thursday, December 31, 2009 10:22 AM > *To:* [email protected] > *Subject:* Re: Real Field pushed to a Character Field > > ** > In the database I see the field as 2033. > > > Lisa > > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Kemes, Lisa > *Sent:* Thursday, December 31, 2009 12:20 PM > *To:* [email protected] > *Subject:* Re: Real Field pushed to a Character Field > > ** > Sorry: > > ARS 7.1 patch 7 > Windows 2003 > Oracle > > > Lisa > > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Kemes, Lisa > *Sent:* Thursday, December 31, 2009 12:19 PM > *To:* [email protected] > *Subject:* Real Field pushed to a Character Field > > ** > I hope this isn't an obvious question, but when I push a real field (ie, > the data in the real field is 2033.00) into a character field on another > form, the character field shows: 2.0330000000E3. Is this normal? > > *Lisa Kemes** * > AR System Developer > Tyco Electronics > 717-810-2408 tel > 717-810-2124 fax > [email protected] > > > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the > Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where > the Answers Are"_ > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > -- If it were not for the gutter, my mind would be homeless! _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
