Re: XML Procesing with SQR

[Ray Ontko <rayo@ONTKO.COM>]

Tom, Bruce,

Writing XML is fairly easy to do with SQR using WRITE or PRINT.
If you're writing your own code (instead of using Brio ReportBuilder
generated code), you have more control over the structure of the output.

Reading XML is the challenging part.   This can be done with
SQR/DDO (Direct Data Objects), or you can write your own XML
parser in SQR.  Brio ReportBuilder doesn't support DDO access
to XML, so this would need to be written as a regular SQR/DDO
program.

Writing an XML parser from scratch is fairly complex, even if it's
a non-validating parser, but it can certainly be done in SQR.  It's
the kind of program I'd like to write.

If you need read XML with SQR, I'd strongly recommend that you
look at SQR/DDO.

Ray

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Hello,
>
> We too are about to produce XML output with v6.2.  I have seen the code for
> XML generated by report builder. Not suprisingly, it's ugly. I intend to
> begin the XML project in a week or two.
>
> -tom
>
> -----Original Message-----
> From: Merritt, Bruce [mailto:Merritt@USCOLO.EDU]
> Sent: Tuesday, April 02, 2002 2:41 PM
> To: SQR-USERS@list.iex.net
> Subject: XML Procesing with SQR
>
>
> Hi All,
>
> We are currently using SQR version 6.1.3, and in the near future will have
> to receive and send data between our system and a third party using XML. Has
> anyone done any XML processing with SQR?
>
> Thanks
>
> Bruce Merritt
> University of Southern Colorado
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/