Database Updates

Always use result sets to make modifications to the database. Most blocking tends to occur when a custom stored procedure attempts (for example, through a calculation or event mode) to directly update or delete records in the database and it conflicts with the DatabaseMgr service.

The Proficy DatabaseMgr service is responsible for making updates to the database, so, by using result sets, the DatabaseMgr service makes the changes for you and situations where both processes attempting to access the same record locks will be avoided.