freeform not working as expected
Joe Boyle
joeboyle_adt@hotmail.com
Mon, 20 Sep 2004 11:22:52 +0100
This is a multi-part message in MIME format.
------=_NextPart_000_0011_01C49F04.2B841AE0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
I suspect that as the decimal part is stored/present in the item you will
need to add syntax 'output scale 2 ' to the element syntax.
This multiplies the value up to an integer ( same as * 100 ) - only the
integer part is moved into the picture when a field is displayed.
Regards, Joe.
This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.
_____
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Brett Greiner
(Kinetix)
Sent: 19 September 2004 23:44
To: powerh-l@lists.sowder.com
Subject: freeform not working as expected
We are using Ph 8.13.D2 on an AIX.
I have a data file to read in which has amounts specified as <1 char
sign>00000031.17 ie. 00000031.17 for $31.17. When I setup the element as
FREEFORM its only displayed as 31. If I remove the decimal place from the
data, it comes out correctly as 31.17.
The manual for Freeform says its works with leadings/trailing spaces and an
imbedded decimal point.
Here is the PDL code of the element;
Element CALTEX-VOLUME NUMERIC Size 12
&
Decimal 2 &
Leading Sign " " &
picture " ^^^^^^^^.^^" &
Default Item Datatype FREEFORM SIZE 12
Can anyone help?
Thanks in advance,
Brett.
Brett Greiner,
Kinetix Group Ltd.,
ph. +64 6 759 1929
fx. +64 6 759 1928
------=_NextPart_000_0011_01C49F04.2B841AE0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Message</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
p.style1, li.style1, div.style1
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";
color:#002558;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!-- Fireworks MX Dreamweaver MX target. Created Thu Jun 12 13:20:07 =
GMT+1200 (New Zealand Standard Time) 2003-->
<script language=3D"JavaScript" type=3D"text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init=3D=3Dtrue) with (navigator) {if =
((appName=3D=3D"Netscape")&&(parseInt(appVersion)=3D=3D4)) {
document.MM_pgW=3DinnerWidth; document.MM_pgH=3DinnerHeight; =
onresize=3DMM_reloadPage; }}
else if (innerWidth!=3Ddocument.MM_pgW || =
innerHeight!=3Ddocument.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=3Dwhite
background=3D"file:///C:\Program%20Files\Common%20Files\Microsoft%20Share=
d\Stationery\kinetix.gif"
lang=3DEN-US link=3Dblue vlink=3Dpurple leftmargin=3D0 topmargin=3D0>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I suspect that as the decimal part =
is
stored/present in the item you will need to add syntax ‘output =
scale 2 ‘
to the element syntax.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>This multiplies the value up to an =
integer
( same as * 100 ) – only the integer part is moved into the =
picture when
a field is displayed.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>Regards, Joe.</span></font><font color=3Dnavy><span
style=3D'color:navy'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>This e-mail and all information contained in it is
confidential and may be legally privileged. If you are not the =
intended</span></font><font
color=3Dnavy><span style=3D'color:navy'> </span></font><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>recipient,
your access to this e-mail is unauthorized. Any use, dissemination,
distribution, publication or copying by you of this e-mail or any of the =
information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the =
sender
promptly by e-mail that you have done so. The content of this e-mail and =
any
attachments sent with it may have been altered without the consent or =
knowledge
of the author.</span></font><o:p></o:p></p>
</div>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>
<hr size=3D3 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> =
powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] <b><span =
style=3D'font-weight:bold'>On
Behalf Of </span></b>Brett Greiner (Kinetix)<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 19 September 2004 =
23:44<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> freeform not =
working as
expected</span></font><o:p></o:p></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:black'>We are using Ph 8.13.D2 on an =
AIX.<o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:black'>I have a data file to read in which has =
amounts
specified as <1 char sign>00000031.17 ie. 00000031.17 for $31.17. =
When I
setup the element as FREEFORM its only displayed as 31. If I remove =
the
decimal place from the data, it comes out correctly as 31.17. =
<o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:black'>The manual for Freeform says its works =
with
leadings/trailing spaces and an imbedded decimal =
point.<o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:black'>Here is the PDL code of the =
element;<o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:black'>Element
CALTEX-VOLUME =
NUMERIC Size
12  =
;
&<br>
Decimal 2 &<br>
Leading Sign " " &<br>
picture " ^^^^^^^^.^^" &<br>
Default Item Datatype FREEFORM SIZE =
12<o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:black'>Can anyone =
help?<o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:black'>Thanks in =
advance,<o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:black'>Brett.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Brett Greiner,</span></font><font =
size=3D2
color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:black'> <o:p></o:p></span></font></p>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Kinetix Group =
Ltd.,</span></font><font
size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:black'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>ph. +64 6 759 =
1929</span></font><font
size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:black'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>fx. +64 6 759 =
1928</span></font><font
size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:black'><o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>
------=_NextPart_000_0011_01C49F04.2B841AE0--