Re: AS400 Query and floating point decimal field

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.