4 Replies Latest reply on Apr 25, 2017 3:41 AM by wimdecorte

    Does Import Records lock records on FMS?

    bigtom

      Does Import Records lock records on FMS? If so, for how long? All records at once to build an export list or one at time as they transfer to the client?

        • 1. Re: Does Import Records lock records on FMS?
          Jason Wood

          You're asking about locking in the source file, right?

           

          So when you import to File1.fmp12 to File2.fmp12, will the records in File2.fmp12 be locked at any point?

           

          The answer is no. Import will not lock the source records and therefore it doesn't matter if they are locked by another user. The last committed values will be imported.

          • 2. Re: Does Import Records lock records on FMS?
            bigtom

            You buried the answer at the end. So actively locked records will be sent as source data with the last committed data. Interesting. I will test that.

            • 3. Re: Does Import Records lock records on FMS?
              bigtom

              Well you say source file but reference File2?

              • 4. Re: Does Import Records lock records on FMS?
                wimdecorte

                bigtom wrote:

                 

                So actively locked records will be sent as source data with the last committed data. Interesting. I will test that.

                 

                That makes total sense when you think about it.  If a client exports, FMS will need to send it all the data.  FMS is aware of locked records but not about the uncommitted data.  Only the client with the record open knows what the uncommitted data is.  The server only knows what the committed data is.

                 

                This is the same principle that I used a few years ago for my audit log devcon session: At the moment of commit (and the OnCommit is a pre-event trigger) you can get both the old and new data, saving you from having to store all the old data ahead of time.

                Your FMP client will know the new data, you can ask FMS through PSoS for the old data since FMS has not received the new data yet.