|
Can you define a field equal to this floating point decimal field? Something like rename??? just wondering. Regards,Hrishikesh Kotwal
midrange.com
----------------------------------------------------------------------
From: mandis-inc@xxxxxxx
Reply-To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Subject: Re: [MAPICS-L] AS400 Query and floating point decimal field
Date: Thu, 22 Feb 2007 21:33:15 +0000
>2/22
>
>Greg, I have and I get a message that editing is not allowed on a
floating point field.
>
>Mike
>--
>Best regards,
>
>Mike Dreimiller
>Mandis Inc.
>410-526-5996
>Mandis-Inc@xxxxxxx
>
>
>-------------- Original message from "Greg Novak" <gnovak@xxxxxxxxxx>:
--------------
>
>
> > Have you tried setting an edit code on the fields? Hit F16 on the
field
> > from Specify column formatting.
> >
> > Regards,
> > -Greg
> >
> > Gregory Novak
> > Manager North American Technical Services
> > Momentum Utilities Pty Ltd
> > (630) 985-1736
> > gnovak@xxxxxxxxxx
> > www.jacana.com
> >
> > Making Information Work for your Business
> > www.intuator.com
> >
> >
> >
> > -----Original Message-----
> > From: mandis-inc@xxxxxxx [mailto:mandis-inc@xxxxxxx]
> > Sent: Wednesday, February 21, 2007 2:46 PM
> > To: MAPICS ERP System Discussion
> > Subject: Re: [MAPICS-L] AS400 Query and floating point decimal field
> >
> > Bob,
> >
> > I tried your suggestion. I took the quantity field (floating
decimal),
> > multipled by 1 and set the result to be 7.2.
> >
> > Field Expression Column Heading
> > Len Dec
> > TOTAL itqty * 1 total
> > 7 2
> >
> > Here's the result
> >
> > Transaction Qty total
> > 000001 1.000000000000000E+000 10000.00E-004
> >
> > Mike
> >
> >
> > 9.000000000000000E+002 90000.00E-002
> > --
> > Best regards,
> >
> > Mike Dreimiller
> > Mandis Inc.
> > 410-526-5996
> > Mandis-Inc@xxxxxxx
> >
> >
> > -------------- Original message from bciervo@xxxxxxxxxxxx:
--------------
> >
> >
> > > Hi Mike,
> > > I'm not exactly sure what you are defining as a floating point
decimal,
> > > using the Define result fields, create a new field by multiplying
the
> > > floater field by 1 (which will not change the value, and define
the
> > > created field with 7 and 2 decimals.
> > >
> > >
> > >
> > > Bob Ciervo
> > > Programmer/Analyst
> > > Kinedyne Corporation
> > > 908 231-1800 ext 130
> > >
> > >
> > >
> > >
> > > mandis-inc@xxxxxxx
> > > Sent by: mapics-l-bounces@xxxxxxxxxxxx
> > > 02/21/2007 07:18 AM
> > > Please respond to
> > > MAPICS ERP System Discussion
> > >
> > >
> > > To
> > > MAPICS-L@xxxxxxxxxxxx
> > > cc
> > >
> > > Subject
> > > [MAPICS-L] AS400 Query and floating point decimal field
> > >
> > >
> > >
> > >
> > >
> > >
> > > I am writing an AS400 query. One of the fields is a floating point
> > > decimal. How would I convert this floating point field to a
regular
> > > decimal (7.2. numeric)? The report writing tool is AS400 query.
> > >
> > > TIA
> > > --
> > > Best regards,
> > >
> > > Mike Dreimiller
> > > Mandis Inc.
> > > 410-526-5996
> > > Mandis-Inc@xxxxxxx
> > > _______________________________________________
> > > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > > To post a message email: MAPICS-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> > > or email: MAPICS-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/mapics-l.
> > >
> > >
> > > _______________________________________________
> > > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > > To post a message email: MAPICS-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> > > or email: MAPICS-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/mapics-l.
> > >
> >
> > _______________________________________________
> > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > To post a message email: MAPICS-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> > or email: MAPICS-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/mapics-l.
> >
>_______________________________________________
>This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
>To post a message email: MAPICS-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/mapics-l
>or email: MAPICS-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/mapics-l.
>
----------------------------------------------------------------------
Win a Zune**make MSN(R) your homepage for your chance to win!
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
