Re: XML ODBC Driver?

Tom wrote:
<RecordSet>
<Record>
<FieldName>Data Contained</FieldName>
</Record>
<Record>
<FieldName>Data Contained</FieldName>
</Record>
</RecordSet>

ADO will do this out of the box with any OleDB provider, including
the OleDb provider for ODBC.

Configure the ADO connection for a client-side cursor, execute the SQL
and save the resulting recordset by executing recordset.savetofile ('filename.xml')

You can then load the xml file from disk into an Ado recordset in
your Delphi application.


--
Arthur Hoornweg

(In order to reply per e-mail, please just remove the ".net"
from my e-mail address. Leave the rest of the address intact
including the "antispam" part. I had to take this measure to
counteract unsollicited mail.)
.

Relevant Pages

  • Re: XML ODBC Driver?
    ... Configure the ADO connection for a client-side cursor, execute the SQL ... and save the resulting recordset by executing recordset.savetofile ...
    (borland.public.delphi.non-technical)
  • Re: Opinions on approach, please...
    ... Create a data layer program per table, ... number of bind variable tokens in your dynamic SQL. ... then simply EXECUTE that without passing it any parameters? ... Hard code WHERE clauses. ...
    (comp.lang.cobol)
  • Re: SQL Injection- Bypassing magic_quotes
    ... Because i was trying to execute: ... Don't terminate the query and you most ... Or try something like bobcat or one of the other SQL injection tools out ... Chief Information Security Officer ...
    (Pen-Test)
  • Re: Opinions on approach, please...
    ... Create a data layer program per table, ... number of bind variable tokens in your dynamic SQL. ... then simply EXECUTE that without passing it any parameters? ... explicitly code dummy words as bind variable placekeepers, put the host variables on the ...
    (comp.lang.cobol)
  • Re: UPDATE query in Access 2003 raising error
    ... string into a variable strSQL but create the qrydef from a string strSQLx (I ... Runtime error 3066 Query must have at least one destination field. ... The SQL works fine if I use it in the QBF Design mode. ... Elsewhere in the code I use the same technique to execute an SQL ...
    (microsoft.public.access.formscoding)