| Matt Milner 2005-03-24, 2:50 am |
| In the before you need to have the values that would be used in a where
clause to update. For example, the ID for your table, but you don't need all
of the other columns. Then in the after you need the new data. You
shouldn't need to use the updg:id attribute.
matt
"Chad" <chad.crosby@wise.com> wrote in message
news:1111608180.068047.184630@g14g2000cwa.googlegroups.com...
>I am using an updategram and sql adapter to do an update of multiple
> tables (parent/child). However I am having a problem with it inserting
> instead of updating. I need to somehow ensure that it is updating for
> the existing id (which I have in my map -source schema). I'm guessing
> I need to use the updg:id value somehow but I am not finding any
> examples of this using biztalk. I know updates require <before> and
> <after> tags, but I'm not sure how the updg:id ties into that. I tried
> mapping the source ID to updg:id in the before and after and that
> didn't work. Any experience with this.
>
|