Re: XML Procesing with SQR

["Merritt, Bruce" <Merritt@USCOLO.EDU>]

Thanks Ray,

That what I thought, writing would be easy, but reading would be difficult,
and yes we will have to read the XML file.

Where do I find documentation and SQR/DDO?

Do you know if SQR support OLE on the windows platform. The reason I am
asking is because if it does, then I could write an SQR program that could
manipulate Microsoft's XML parser object and use it for validation?

Thanks

Bruce

 -----Original Message-----
From:   Ray Ontko [mailto:rayo@ONTKO.COM]
Sent:   Thursday, April 04, 2002 4:43 PM
To:     SQR-USERS@list.iex.net
Subject:        Re: XML Procesing with SQR

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/