Deleted Row information cannot be accessed through the row

Epicor ERP 10
1

Reaching out to the Service Connect pros out there.

I am simply trying to delete an Order and all of its information. Trace says to use SalesOrder.Update() and set the RowMod to D for the OrderHed, OrderDtl, OrderRel, OrderRepComm, and OrderSched tables.

Trouble is, when I set RowMod to “D” or “[DELETE]” I get the error in the subject. I also tried .DeleteByID, but I don’t think Epicor ever utilizes these.

Anyone know how to delete records using .Update() methods? Not sure what I’m doing wrong here.

2

It’s been awhile since I’ve touched Service Connect, but you might try using UpdateExt instead. If I recall, that works way smoother in SC.

3 Likes
3

I’d have to agree with @hmwillett on using the Updateext method, may need to do some additional tests like checking if the type of release and if jobs are attached etc.

You could test it with the BL tester first, or using the REST Help (if you are using the latest Service Connect with the REST capabilities (disclaimer I have not used them).

Hope that helps.

1 Like
4

That did it! Same exact conversion and setting the RowMod to [DELETE], just used UpdateExt() instead of Update().

Thank you so much!

2 Likes