Bugger -----Original Message----- From: "Stephen Bertram" <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Date: Wed, 30 Jul 2003 14:43:41 +1200 Subject: RE: RE: [DUG]: ADOTables and XML files
> 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=20 > > 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=20 > 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 ? > >=20 > > Stephen > >=20 > > -----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 > >=20 > >=20 > > HI All. > > I have come back to looking at loading XML files into ADO Tables for > > a=3D20 > > small project I am looking at. > > If I take a standard (if there is such a thing) XML file and try to > > load =3D > >=20 > > 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=3D20 > > loadfromfile into the ADOTable, and it works. > > Ok, so I then looked at the XML, and its got headers that I have > > never=3D20 > > 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 =3D > >=20 > > which lets you do, SELECT * FROM Products FOR XML,AUTO which = > will=3D20 > > export to XML. > > Does anyone else do this, or similar ? how do I get SQL Server > to=3D20 > > generate the headers that the ADOTable seems to need etc? > >=20 > > Thanks, Jeremy > >=20 > > = > ----------------------------------------------------------------------- > > --=3D > > -- > > 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 =3D > > confidential and the copyright of enSynergy Limited or a third party. > > If =3D > > you are not the intended recipient of this communication please > delete > > =3D > > and destroy all copies and telephone enSynergy Limited on +64 9 = > 9205441 > > =3D > > immediately. If you are the intended recipient of this communication > > you =3D > > should not copy, disclose or distribute this communication without > the > > =3D > > authority of enSynergy Limited. Any views expressed in this =3D > > Communication are those of the individual sender, except where the > =3D > > sender specifically states them to be the views of enSynergy Limited. > = > =3D > > Except as required by law, enSynergy Limited does not represent, > > warrant =3D > > and/or guarantee that the integrity of this communication has been > =3D > > maintained nor that the communication is free of errors, virus, =3D > > interception or interference. > >=20 > > = > ----------------------------------------------------------------------- > > ---- > > 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/ --------------------------------------------------------------------------- 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/
