[Info-ingres] Report writer - booleans and other "special" characters

[Allan Biggs]

I am attempting to create an XML spreadsheet using report writer.

this is the type of fixed text at the header of the spreadsheet.

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">



I have tried de-referencing with /

.HEADER REPORT 

.PRINTLN "/<?xml version=/"1.0/"?/>" 

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 )


INGRES REPORT Copyright 2003 Computer Associates Intl, Inc.
Reading report specifications and preparing query . . .
Retrieving data . . .
E_US1130 illegal character to integer conversion or non-numeric character
    in money field.

E_RW1209 Fatal error occurred in header text for 'report'. Line with
    error: 'println "/<?xml version=/",1.0/"?/>"'. Processing stops.

E_LQ002B 'rollback' may not be nested within a data retrieval loop.




I would be grateful of any suggestions 
I should say that I had forgotten just how flexible and useable Report 
writer is.

thanks
Allan

This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean

          http://www.DuPont.com/corp/email_disclaimer.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20150810/a73b03d2/attachment.html>