Subject Re: R: [IBO] Xml, Ibo and Firebird
Author Helen Borrie
At 08:00 PM 8/09/2007, you wrote:
>Hi Helen,
>i need to make a procedure into my application who can read files in Xml
>format and populate some different tables in Firebird database.
>My customer must import xml files any times who need it, then my application
>must have a procudere for do this.
>The import operation must be performed from client side and not from server,
>my C++ application

This list is about the IB Objects data access components, which only
work in Delphi (C++ Builder or ObjectPascal).

>must read xml file, transform data in record

Delphi 7 has VCL components for it. If you are using C++ Builder 6,
you can download (from Codecentral) and install the TXMLDocument
package, that should take care of that part for you.
Tip: you might like to hook up with OpenXML (a complete Delphi-based
open source XML framework that bypasses the Microsoft type libraries)
by joining their very active list forum:
mailto:openxml-request@...?subject=subscribe

>and then insert record into firebird tables.

That part IBO would take care of. Exactly *how* would depend on what
you end up with in the XML part of your client code. If your XML
data is ascii, possibly a TIB_Import would help. If non-ascii, you
would need to roll your own parsing routine and pass parameters to
simple ib_dsql statements or stored procedures.

>Because i need to import some different Xml files i think to develope an
>object who can be re-used but i need some input because i don't know what
>would be the best approch for read and interpret xml files and also i don't
>know if there are some object already developed who i can buy and use.

Try Google. There seem to be lots and lots of ways to do the XML
loading and parsing part of your application, probably for no
cost. IBO doesn't have anything idiomatic to do it, but you
shouldn't have a lot of trouble putting together something that fits
with your needs and linking it up with your IBO data access layer.

Tip: you might like to hook up with OpenXML (a complete Delphi-based
open source XML framework that bypasses the Microsoft type libraries)
by joining their very active list forum:

mailto:openxml-request@...?subject=subscribe

If you are using plain C++ (not Builder) then you are asking in the
wrong place.

Helen