Locking records

[peronn]

Don't know if this is the right location but i tought it was the most suitable i could find.

Well, i am wondering if there is a way to set "locks" on records? I've worked with forexample MS Sql Server where you can set read and commit locking. The problem is that i have a multi-user solution and it turns out that two user can infact change the same value in a record. Which can lead to falty data if the change it at the same time. I have however noticed that FM locks a field sometimes but have not been able to figure out when that is.

Is there a way to secure a records so that as soon as a user enters a field on one layout, no one else can change that record?

Thanks for reading.

[aaa]

In FM when one user is editing record and other user want to change this record he get message as:

"Alex is modifing this record"

[Søren Dyhr]

s there a way to secure a records so that as soon as a user enters a field on one layout, no one else can change that record?

Yes issue a scripted Open Record/Request command, placing the cursor in a field isn't enough. Another way is to use Insert(calculated result) in a field, such as setting it's own value.

--sd

Edited August 22, 2005 by Guest

[Inky Phil]

Am I missing something here.

I always believed (prior to 7) that if someone was in a field then all other users are locked out from editing that record. Has this changed in 7?

Phil

[Søren Dyhr]

Yes it has, read from page 74 and onwards, in this:

http://www.filemaker.com/downloads/pdf/techbrief_fm7_foundations.pdf

--sd

[Inky Phil]

Thank you Soren

Phil

[Inky Phil]

I have only just got around to reading that tech breifing but it was invaluable in helping me understand opening and committing records- thanks again Soren

Phil