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/
