AnsweredAssumed Answered

Locking on record When 2 users are working on the same table but not the same record !

Question asked by Fagreement on Dec 7, 2012
Latest reply on Dec 10, 2012 by philmodjunk

Title

Locking on record When 2 users are working on the same table but not the same record !

Post

     I have a serious issue of records locking in my program and it is really urgent and scarring me cause it is on Production: Locking on record When 2 users are working on the same table but not the same record.

     I have FM installed on each machine with SQL server as database, connected via ODBC, everything work fine.

     Here is the scenario (please see attach file):

         
  •           USER1 open the main page where we can see 2 portals: Archive type portal, and List of the collection portal. When we click on the 1st portal then the 2nd will be refreshed accordingly.
  •      
  •           User2 open also the main page.
  •      
  •           USER1 edit the record no 1 in the list, another layout is opened, he performed change (with or without save you will see that the issue is the same)
  •      
  •           Then User2 wants know to edit another record, the 2nd record! So when he try to edit it -> boom: “this record was modified by another user since your started editing…”

                     (I can provide you the FM file In worst case)

      

     thanks !

Outcomes