hi
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156