Re: Can't use "FOR XML" query w/ _RecordsetPtr?

Does not _RecordsetPtr support the "FOR XML" clause?

RecordsetPtr has nothing to do with it. What matters is whether the database
supports it as it the database that will execute the SQL not the
RecordsetPtr. That is also true for _ANY_ SQL. It is dependent on the
underlying database, not ADO. For example

SELECT TOP 20 * FROM table1

will work with SQL Server but not Access as it does not support the "TOP n"
clause.

All RecordsetPtr does is act as an underlying container for any resultant
rowsets and presents some interface functionality for viewing the rowsets
and properties.

Returning to your point: SQL Server 7.0, 2000 & 2005 support this and with
MDAC 2.6+ Streams it should be easy.
All the articles I have seen have retrieved results into Streams not
RecordSets.

Here is an article on doing this
http://support.microsoft.com/kb/q271620/

Also see VBScript at bottom of
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adosql/adoprg03_6coj.asp

Stephen Howe


.

Relevant Pages

  • Re: Access 2003 database to SQL 2005
    ... The following articles may be of interest: ... Basically your entire DB structure will be transformed into a SQL ... Server database and the wizard will attempt to change the queries you ... SQL Server Reporting Services. ...
    (microsoft.public.sqlserver)
  • Re: ISA 2004 Logging into SQL 2005
    ... >> The first is how to manage the size of the database, ... >> various articles how to delete records after a date, ... >> but how would I go about retaining only the last 3 months and automate ... > I have tried using SQL automated tasks and it works fine for a while, ...
    (microsoft.public.isa)
  • Re: Replication Programming
    ... > Looking for a SQL Server replication book? ... >> I am given a database and a list of articles in the database to ... >> The publication shows up in the publication folder. ... >> But when i try to see the articles in the publication properties, ...
    (microsoft.public.sqlserver.replication)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)