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

All responses (0)

Answers (0)

Helpful resources

André Arnaud de Cal... 291,431 Super User 2024 Season 2

Martin Dráb 230,503 Most Valuable Professional

nmaenpaa 101,156

Leaderboard