gijeet 6/29/2010 2:30:06 PM

Extending business logic - Add XML nodes to an existing schema

Has anyone added their own custom xml node to an eConnect schema?  I created my own xml node with two elements in which I want to update a field in the SOP10100 table that is not part of the taSopHdrIvcInsert schema.  I followed the directions and named the custom schema the same as the stored procedure I created and the two elements are the same as the two parameters in the sp.  But it's not working and I suspect it's because in my stored proc I do an update and since eConnect wraps the whole SOPTransactionType into a sql transaction  -  the record has not been commited yet and therefore does not exist in the SOP10100 table so updates will not work!

 

Anyone tried to do their own custom xml nodes with updates?
Version: Unknown or N/A
Section: eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3