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

[Bodo Bergmann]

Have you tried:

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


What does you make thinking that a slash (/)  would work as an escape character?

Bodo.

From: openroad-users at googlegroups.com [mailto:openroad-users at googlegroups.com] On Behalf Of Allan Biggs
Sent: Montag, 10. August 2015 18:16
To: openroad-users at googlegroups.com; info-ingres at lists.planetingres.org
Subject: [openroad-users] Report writer - booleans and other "special" characters

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
--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-users+unsubscribe at googlegroups.com<mailto:openroad-users+unsubscribe at googlegroups.com>.
To post to this group, send email to openroad-users at googlegroups.com<mailto:openroad-users at googlegroups.com>.
Visit this group at http://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/OFED74B0B4.B8A1F364-ON80257E9D.0057710F-80257E9D.0059899F%40CDCLN05.LVS.DUPONT.COM<https://groups.google.com/d/msgid/openroad-users/OFED74B0B4.B8A1F364-ON80257E9D.0057710F-80257E9D.0059899F%40CDCLN05.LVS.DUPONT.COM?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20150810/a8d3e030/attachment.html>