Using XML to get SQL Statement structure

[tfitz]

Hello,

I have a question regarding XML. I have a database whose schema
changes quite frequently. I have code to query that database;
however, if the database schema ever changes or is enhanced, I have to
then go in and modify my code (C++) so the new SQL statemens match. I
would like to use XML to solve this problem. Can anyone tell me a
good reference for this type of problem, and whether or not is seems
fairly feasible. Thanks in advance!

Regards,

T

 

[Arto Viitanen]

tfitz> Hello, I have a question regarding XML. I have a database whose
tfitz> schema changes quite frequently. I have code to query that database;
tfitz> however, if the database schema ever changes or is enhanced, I have
tfitz> to then go in and modify my code (C++) so the new SQL statemens
tfitz> match. I would like to use XML to solve this problem. Can anyone
tfitz> tell me a good reference for this type of problem, and whether or not
tfitz> is seems fairly feasible. Thanks in advance!

It might be. I have made a system where I descripe the data using XML. From
the XML-file I generate the database description and programs that operate
the database using XSLT. But, if someone else changes the database, you have
to fetch the schema, so you cold fetch it using your C++ program also.