Re: AS400 Query and floating point decimal field

["hrishikesh kotwal" <hdkotwal@xxxxxxxxxxx>]

  Can you define a field equal to this floating point decimal field?
  Something like rename??? just wondering.

  Regards,
   
  Hrishikesh Kotwal
   

    ----------------------------------------------------------------------

    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!