| Author |
Get one row from a table using SQL adapter
|
|
| joseph 2005-03-22, 6:03 pm |
| Hello I am trying to figure out the best way to get one row from a table.
I got dropped file in BizTalk with row id (primary key). In my orchestration
I use that id to get one row from my table. I tried with request-response
however I am having hard time to initialize multi-part message before send
shape...
Anyone know a nice tutirial for this case.
Thanks.
| |
| Niklas E 2005-03-22, 6:03 pm |
| Have you tried to write a Stored procedure, which you call with the id as a
parameter?
Best regards
Niklas Engfelt
"joseph" <joseph@discussions.microsoft.com> wrote in message
news:4945F945-BC05-48AB-806D-670BE28CD454@microsoft.com...
> Hello I am trying to figure out the best way to get one row from a table.
> I got dropped file in BizTalk with row id (primary key). In my
orchestration
> I use that id to get one row from my table. I tried with request-response
> however I am having hard time to initialize multi-part message before send
> shape...
> Anyone know a nice tutirial for this case.
>
> Thanks.
>
| |
| joseph 2005-03-23, 6:01 pm |
| Yes, that is what I am doing.
As begining of my orch is constructmsg shape with assign message shape where
I have to assign to request schema parameter (sp parameter) row id value.
After that I have conneted to port send and recive shape.
I am getting compile error
BizTalk Orchestration.odx(168): 'Message_1.parameters': message part has not
been initialized in construct statement
This must be simple fix to problem. But I can not see it.
Thanks.
Regards Joseph.
"Niklas E" wrote:
> Have you tried to write a Stored procedure, which you call with the id as a
> parameter?
>
> Best regards
> Niklas Engfelt
>
>
> "joseph" <joseph@discussions.microsoft.com> wrote in message
> news:4945F945-BC05-48AB-806D-670BE28CD454@microsoft.com...
> orchestration
>
>
>
|
|
|
|