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

cmckallo at gmail.com cmckallo at gmail.com
Tue Aug 11 02:06:54 UTC 2015


On Monday, August 10, 2015 at 9:18:05 AM UTC-7, Allan Biggs wrote:
> 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

Isn't this the proper syntax 
        .print "            in a day, the \"Was\" data will reflect the oldest i
nformation"," for the day."



More information about the Info-ingres mailing list