Re: Huge problem with generating response schema using SQL Adapter
- From: "Leonid Ganeline" <leo_gan_57@xxxxxxxxxxx>
- Date: Wed, 21 Nov 2007 13:24:40 -0800
The whole idea is your Select should generate data plus *text with schema*
(two rowsets, one with schema is one row - one field with text of the
schema).
Check this.
You should not care about data (for example about "top 1" or "top 1") but
about the right schema. After generating schemas from the Wizard you can
restore the Select to the original form.
--
Regards,
Leonid Ganeline [BizTalk MVP]
http://geekswithblogs.net/leonidganeline/
"Piotrek" <ptybulewicz@xxxxxxxxx> wrote in message
news:86b96ff9-2b25-4a4e-9929-b02a1ec9d7ef@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi.
I am using BTS 2006 R2 and MS SQL Server 2000. In my db I have such
stored procedure:
create procedure myTest
(
@inputValue numeric(18,0) = 0
)
as
begin
select top 1 'aaa' as 'AAA', 'b' as 'BBB'
from someTable
FOR XML AUTO, ELEMENTS , xmldata
end
where someTable is the name of some table existing in my DB.
When I use SQL Adapter in BTS and add adapter metadata based on this
procedure, then my response message contains single Success element of
xs:AnyType. However when I run this proc in Query Analyzer, then the
returned data is correct.
Why is BTS unable to generate proper response schema?
Thanks in advance,
Piotrek
.
- Follow-Ups:
- Huge problem with generating response schema using SQL Adapter
- From: Kevin Seah
- Huge problem with generating response schema using SQL Adapter - Kevin
- From: Kevin Seah
- Re: Huge problem with generating response schema using SQL Adapter
- From: Piotrek
- Huge problem with generating response schema using SQL Adapter
- References:
- Prev by Date: Re: Table Looping functoid loop on optional element in Mapper
- Next by Date: Re: BTS 2006 and SubmitDirect adapter running under Web Service
- Previous by thread: Huge problem with generating response schema using SQL Adapter
- Next by thread: Re: Huge problem with generating response schema using SQL Adapter
- Index(es):
Relevant Pages
|
