Stored procedure with "For XML Auto" and BCB

Article View: borland.public.cppbuilder.database.ado

Article #1934

Back to borland.public.cppbuilder.database.ado Previous Next

#1934

From: John
Date: Tue, 16 Dec 2003 15:38

12 lines
1481 bytes

Hello

I have create a stored procedure in SQL Server 2000 that returns XML, using "For XML Auto". Running the Stored Procedure in Query Analyzer returns the expected results, however running the stored procedure in builder using either ADOStoredProc or ADOCommand does generate the expected results. 

I tried reading the data as a blob, however the results were identical.

Has anyone successfully done this in builder, or have any suggestions on what else to attempt?

Thanks,

John

Technical Details

Message-ID: <3fdf351b$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!zeus.visi.com!news-out.visi.com!green.octanews.net!news.octanews.net!cox.net!news-xfer.cox.net!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,8db657f25300c55,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-12-16 08:42:12 PST
From: "John" <ms_crack@yahoo.com>
Sender: "John" <ms_crack@yahoo.com>
Reply-To: "John" <ms_crack@yahoo.com>
Subject: Stored procedure with "For XML Auto" and BCB
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 138.11.254.204     
X-Forwarded-For: unknown
NNTP-Posting-Host: 207.105.83.66
Message-ID: <3fdf351b$1@newsgroups.borland.com>
Date: 16 Dec 2003 08:38:51 -0700
X-Trace: newsgroups.borland.com 1071592731 207.105.83.66 (16 Dec 2003 08:38:51 -0700)
Lines: 12
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!zeus.visi.com!news-out.visi.com!green.octanews.net!news.octanews.net!cox.net!news-xfer.cox.net!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail