Skip to main content

Notifications

Microsoft Dynamics RMS forum

using sql profile to see updates and inserts in RMS

Posted on by 90

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans