Sorry Jeremy - I haven't used XML in Delphi yet, only in Javascript. I remember major issues getting compatible XML formats - so much for a universal standard data format :-(
Cheers Stephen -----Original Message----- From: vss [mailto:[EMAIL PROTECTED] Sent: Wednesday, 30 July 2003 1:56 p.m. To: Multiple recipients of list delphi Subject: RE: [DUG]: ADOTables and XML files yip. but it gives me a different error now. Are you doing this Stephen? Maybe if you are and it works ok for you, I might be doing something wrong? Jeremy -----Original Message----- From: "Stephen Bertram" <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Date: Wed, 30 Jul 2003 13:46:52 +1200 Subject: RE: [DUG]: ADOTables and XML files > Have you tried FOR XML RAW ? > > Stephen > > -----Original Message----- > From: vss [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 30 July 2003 1:38 p.m. > To: Multiple recipients of list delphi > Subject: [DUG]: ADOTables and XML files > > > HI All. > I have come back to looking at loading XML files into ADO Tables for > a=20 > small project I am looking at. > If I take a standard (if there is such a thing) XML file and try to > load = > > it into an ADOTable it tells me the XML file is incomplete or invalid. > I then ran a query via an ADOQuery, then did savetofile the did=20 > loadfromfile into the ADOTable, and it works. > Ok, so I then looked at the XML, and its got headers that I have > never=20 > seen before, but I can see what its on about. > My main question IS, I will be getting the XML data from SQL Server > 2000 = > > which lets you do, SELECT * FROM Products FOR XML,AUTO which will=20 > export to XML. > Does anyone else do this, or similar ? how do I get SQL Server to=20 > generate the headers that the ADOTable seems to need etc? > > Thanks, Jeremy > > ----------------------------------------------------------------------- > --= > -- > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > Disclaimer : This communication contains information that is = > confidential and the copyright of enSynergy Limited or a third party. > If = > you are not the intended recipient of this communication please delete > = > and destroy all copies and telephone enSynergy Limited on +64 9 9205441 > = > immediately. If you are the intended recipient of this communication > you = > should not copy, disclose or distribute this communication without the > = > authority of enSynergy Limited. Any views expressed in this = > Communication are those of the individual sender, except where the = > sender specifically states them to be the views of enSynergy Limited. = > Except as required by law, enSynergy Limited does not represent, > warrant = > and/or guarantee that the integrity of this communication has been = > maintained nor that the communication is free of errors, virus, = > interception or interference. > > ----------------------------------------------------------------------- > ---- > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ Disclaimer : This communication contains information that is confidential and the copyright of enSynergy Limited or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone enSynergy Limited on +64 9 9205441 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of enSynergy Limited. Any views expressed in this Communication are those of the individual sender, except where the sender specifically states them to be the views of enSynergy Limited. Except as required by law, enSynergy Limited does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
