thx that works.
but something doesn’t…
when add an send port also, and i also generate the send port message (it is to update another database with the same values)
i do everything ok, i map the two messages, i have in my send message this structure:
[quote:7e17e1b748]<sync>
<before>
<tablename>
<columns></columns>
</tablename>
</before>
<after>
<tablename>
<columns></columns>
</tablename>
</after>
</sync>[/quote:7e17e1b748]
in my before and after i have all the columnnames.
so what do i do,
i connect the \”ID\” from the receive message to the \”ID\” from the BEFORE block of the send message.
i connect the \”Aantal\” from the receive message to the \”Aantal\” from the AFTER block of the send message.
i build it, i deploy it, it all works.
but i start my host instance and then the only thing i’m getting is errors in my event log.
this is my error message:
[quote:7e17e1b748]A message sent to adapter \”SQL\” on send port \”SendSQLOrderSysteem\” with URI \”SQL://AWS00401/Ordersysteem/\” is suspended. Error Details: HRESULT=\”0x80040e14\” Description=\”The request for procedure ‘Artikelen’ failed because ‘Artikelen’ is a table object.\”[/quote:7e17e1b748]
The funny thing about it is i don’t use a procedure, i have a sql statement in my receive port and have used the updatagram on my send port…
How could i solve this?
Thx in advance
Thomas