|
Home > Archive > BizTalk Server General > October 2004 > deleting using an updategram
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
deleting using an updategram
|
|
|
| I'm using an updatgram to delete a record from a table based on a parameter
I'm sending. . I need to know if the delete was successful or it failed. How
can I find out?The updategram contains a child called "success" . Can it be
used to check whether the deletion has been successful? If so, How?
--hasan
| |
| Matt Meleski 2004-10-25, 7:48 am |
| Hasan,
In SQL profiler, you can see the exact transact sql that BizTalk is submitting
to Sql Server, and any type of response that it is sending back.
I would highly recommend , calling a Stored procedure instead of a
updategram.
You will have much more control on what to do, depending on the success or
failure
of the outcome of your delete.
Matt.
"hasan" wrote:
> I'm using an updatgram to delete a record from a table based on a parameter
> I'm sending. . I need to know if the delete was successful or it failed. How
> can I find out?The updategram contains a child called "success" . Can it be
> used to check whether the deletion has been successful? If so, How?
>
> --hasan
>
| |
|
| Thanks for the reply Matt.
The reason I wanted to use an update gram is that I read somewhere that
updategrams are a lot more efficient as compared to stored procedures. If I
was to add an element of type string to success, would I be able to access
whatever was returned? (I'm basing this on the fact that the success child is
of type "any".)Comments would be welcome.
thanks,
--hasan
"Matt Meleski" wrote:
[vbcol=seagreen]
> Hasan,
>
> In SQL profiler, you can see the exact transact sql that BizTalk is submitting
> to Sql Server, and any type of response that it is sending back.
> I would highly recommend , calling a Stored procedure instead of a
> updategram.
> You will have much more control on what to do, depending on the success or
> failure
> of the outcome of your delete.
>
> Matt.
>
> "hasan" wrote:
>
|
|
|
|
|