Article View: borland.public.cppbuilder.database.ado
Article #1900Re: Stored procedure with "For XML Auto" and BCB
From: Emil Doychev
Date: Thu, 15 Jan 2004 15:34
Date: Thu, 15 Jan 2004 15:34
28 lines
1800 bytes
1800 bytes
Same problem here, but with ADOQuery and SQL property set to something like this: SELECT * FROM atable FOR XML AUTO It works i Query Analyzer, but not in ADOQuery. The result when ADOQuery is opened is: DS Any suggestions? "John" <ms_crack@yahoo.com> wrote in message news:3fdf351b$1@newsgroups.borland.com... > > 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:
<4006b38c@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3fdf351b$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,8db657f25300c55 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2004-01-15 07:40:36 PST From: "Emil Doychev" <e.doychev@isy-dc.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3fdf351b$1@newsgroups.borland.com> Subject: Re: Stored procedure with "For XML Auto" and BCB Date: Thu, 15 Jan 2004 17:34:04 +0200 Lines: 30 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 212.104.98.58 Message-ID: <4006b38c@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1074181004 212.104.98.58 (15 Jan 2004 07:36:44 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail