Hi ,
I m having a very strange issue while inserting data in inbound tables
through a updategrams , which is updating multiple tables e.g
Inbound_Order,
Inbound_Order****pment. (I added on table thru sql adapter wizard while
manually added the rest)
Inbound_Order schema generated by updategrams wizard has a field
updg:at-identity. In map, MyDataSchemaToUpdategramSchema ,
updg:at-identityis mapped to Inbound_OrderId of Inbound_Order****pment.
(Inbound is declared as FK and is related to Orderid in Inbound_Order.
Now when the process runs.. all int records of that row in
Inbound_Order****pment are repalced by Inbound_OrderId(FK value)....
I ve captured the msg before it is sent to DB. Both the updg of
Inbound_Order and Inbound_OrderId of Inbound_****pmentOrder ve value =1.
After
stored proc executes these are replaced by newly assigned value or OrderId
but along with them all int values are replaced with OrderId too....
Note: This is happening in all the tables where updg is used to initialize
OrderId(FK)....
Can you suggest any solution. ThankYou.
Regards,
Waqar Ahmed.
