You’re offline. This is a read only version of the page.

Microsoft Dynamics RMS (Archived)

using sql profile to see updates and inserts in RMS

(0) Share

Report

Posted on by moshe

hi i am making a application that will handle work orders. and i need a way to commit a item in a work order and some times even change the price.

so the first update ill do is something like this

Update OrderEntry Set QuantityOnOrder = 0,QuantityRTD = 1,Price = 12.99,Taxable = 1 Where ID = 20144

but my question is what else needs to be updated?

so i tried using sql profile and i selected this events

RPCStarting,SQLBatchStarting,SQLStmtStarting,SPStarting,SPStmtStarting,SQLFullTextQuery

but all i get is select statements, there is no update or insert.

is there another way of doing this?

*This post is locked for comments

I have the same question (0)

All responses (0)

Answers (0)

Helpful resources

Last 30 days Overall leaderboard