<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"MS Shell Dlg 2";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
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",serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Have you tried:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New"">.PRINTLN
</span><span style="mso-fareast-language:EN-US">'</span><span style="font-size:10.0pt;font-family:"Courier New""><?xml version="1.0"?></span><span style="mso-fareast-language:EN-US">'</span><span style="font-size:8.5pt;font-family:"MS Shell Dlg 2";mso-fareast-language:EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:8.5pt;font-family:"MS Shell Dlg 2";mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">What does you make thinking that a slash (/) would work as an escape character?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Bodo.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> openroad-users@googlegroups.com [mailto:openroad-users@googlegroups.com]
<b>On Behalf Of </b>Allan Biggs<br>
<b>Sent:</b> Montag, 10. August 2015 18:16<br>
<b>To:</b> openroad-users@googlegroups.com; info-ingres@lists.planetingres.org<br>
<b>Subject:</b> [openroad-users] Report writer - booleans and other "special" characters<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">I am attempting to create an XML spreadsheet using report writer.</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Courier New"">this is the type of fixed text at the header of the spreadsheet.</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue"><?xml version="1.0"?></span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue"><?mso-application progid="Excel.Sheet"?></span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue"><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"</span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue"> xmlns:o="urn:schemas-microsoft-com:office:office"</span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue"> xmlns:x="urn:schemas-microsoft-com:office:excel"</span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue"> xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"</span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue"> xmlns:html="</span><a href="http://www.w3.org/TR/REC-html40"><span style="font-size:10.0pt;font-family:"Courier New"">http://www.w3.org/TR/REC-html40</span></a><span style="font-size:10.0pt;font-family:"Courier New";color:blue">"></span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"></span>
<br>
<br>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Courier New"">I have tried de-referencing with /</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial",sans-serif">.HEADER REPORT </span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Courier New"">.PRINTLN "/<?xml version=/"1.0/"?/>"
</span><br>
<br>
<span style="font-size:10.0pt;font-family:"Courier New"">This will store but gives this error when run (there isn't a 'rollback' in the report and the report runs if I remove the line )</span>
<br>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue">INGRES REPORT Copyright 2003 Computer Associates Intl, Inc.</span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue">Reading report specifications and preparing query . . .</span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue">Retrieving data . . .</span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue">E_US1130 illegal character to integer conversion or non-numeric character</span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue"> in money field.</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue">E_RW1209 Fatal error occurred in header text for 'report'. Line with</span>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue"> error: 'println "/<?xml version=/",1.0/"?/>"'. Processing stops.</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Courier New";color:blue">E_LQ002B 'rollback' may not be nested within a data retrieval loop.</span>
<br>
<br>
<br>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Courier New"">I would be grateful of any suggestions
</span><br>
<span style="font-size:10.0pt;font-family:"Courier New"">I should say that I had forgotten just how flexible and useable Report writer is.</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Courier New"">thanks</span> <br>
<span style="font-size:10.0pt;font-family:"Courier New"">Allan</span><o:p></o:p></p>
<p><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties.<o:p></o:p></p>
<p>Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean<o:p></o:p></p>
<p> <a href="http://www.DuPont.com/corp/email_disclaimer.html">http://www.DuPont.com/corp/email_disclaimer.html</a><o:p></o:p></p>
<p class="MsoNormal">-- <br>
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.<br>
To unsubscribe from this group and stop receiving emails from it, send an email to
<a href="mailto:openroad-users+unsubscribe@googlegroups.com">openroad-users+unsubscribe@googlegroups.com</a>.<br>
To post to this group, send email to <a href="mailto:openroad-users@googlegroups.com">
openroad-users@googlegroups.com</a>.<br>
Visit this group at <a href="http://groups.google.com/group/openroad-users">http://groups.google.com/group/openroad-users</a>.<br>
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/openroad-users/OFED74B0B4.B8A1F364-ON80257E9D.0057710F-80257E9D.0059899F%40CDCLN05.LVS.DUPONT.COM?utm_medium=email&utm_source=footer">
https://groups.google.com/d/msgid/openroad-users/OFED74B0B4.B8A1F364-ON80257E9D.0057710F-80257E9D.0059899F%40CDCLN05.LVS.DUPONT.COM</a>.<br>
For more options, visit <a href="https://groups.google.com/d/optout">https://groups.google.com/d/optout</a>.<o:p></o:p></p>
</div>
</body>
</html>