tag:blogger.com,1999:blog-6691994129222744759.post3366389021167289472..comments2024-03-21T11:36:24.769-07:00Comments on Dynamics GP Land: Does Dynamics GP use the tempdb database? No? Yes? Prove it!Christina Phillipshttp://www.blogger.com/profile/03332221198245457747noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6691994129222744759.post-68420025793871999802017-07-18T14:07:31.302-07:002017-07-18T14:07:31.302-07:00Thank you. This was very helpful.Thank you. This was very helpful.RRBhttps://www.blogger.com/profile/18204297866067860943noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-91909534219234207082014-07-07T16:54:56.236-07:002014-07-07T16:54:56.236-07:00Hey David,
That is interesting--I didn't know...Hey David,<br /><br />That is interesting--I didn't know GP supported that.<br /><br />Under what circumstances, or with which GP record types, is it possible for two users update the same record?<br /><br />For instance, when I have two logins update different fields on the same customer or item record and try to save, I get "This record has been updated since you opened this window. Changes won't be saved."<br /><br />For transactions, if I have two logins attempt to open the same transaction, I get "This transaction is being edited by another user." <br /><br />Or is it only applicable for users editing different GP record types, such as one person can edit a PO while another receives against that PO?<br /><br />Steve<br />Steve Endowhttps://www.blogger.com/profile/03950475674093020502noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-79715653415801860692014-07-02T23:35:54.473-07:002014-07-02T23:35:54.473-07:00The DEX_LOCK and DEX_SESSION tables are used by De...The DEX_LOCK and DEX_SESSION tables are used by Dexterity in conjunction with the DEX_ROW_ID identity column on the tables to implement the Optimistic Concurrency Control feature of Dexterity which allows two users to update the same record of the same table at the same table as long as they are updating different columns.<br /><br />DavidDavid Musgravehttps://www.blogger.com/profile/15001247843646031525noreply@blogger.com