>>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)-.

My application are developed with C++Builder 5 and IBO dataaccess components

>>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:HYPERLINK

"mailto:openxml-request%40philo.at"openxml-request@...?subject=subscri
be

>>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:HYPERLINK

"mailto:openxml-request%40philo.at"openxml-request@...?subject=subscri
be

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

Helen,
i understand that the best approach for do the job is using an XML parser.
Then write a procedure who read the XML file using the XML parser and then
will write all
data into FireBird database tables how my need using sql insert or using
TIB_DSQL components.

The problem then are what XML parser it's the best for do my job...

I see TXMLDocument but i never found any version for C++Builder 5 ... then
how can
i use Microsoft XML dll without TXMLDocument ?
I found also a lot of different parser with google ... but almost not
compliant to the last xml standards.

I know that this problem is out of topics here ... but if someone can help
me ...

Thanks in advance
Enrico Raviglione.


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.14/1001 - Release Date: 11/09/2007
13.37



[Non-text portions of this message have been removed]