Record Locking In FileMaker 6 and earlier versions, record locking occurred when a guest on the network clicked into a field. That's was all that was required to prevent others from changing the record. Unfortunately, this also prevented other guests from copying data from a locked record and other basic features. FileMaker 7 has changed how record locking works. In order for a guest on the network to lock a record, he must actually modify a field, allowing user to work with a record without locking it. However, the most important change is when scripting for record locking. You don't want to test if the record is locked by setting a field to a value. FileMaker 7 introduces the Open Record/Request script step which attempts to lock a record without modifying it. If the record is locked, an error of 301 will be returned. If the record is not locked, this script will lock it until the Guest exits the record manually or the Commit Record/Request script step is intiated.
Level: N/A Version: FileMaker 15 Category: General Sunday, January 1, 2017
You may be wondering why I named this blog the "Philosophy of FileMaker". Philosophy is defined as the following by Merriam-Webster :
1) the study of ideas about knowledge, truth, the nature and meaning of life, etc. 2) a particular set of ideas about knowledge, truth, the nature and meaning of life, etc. 3) a set of ideas about how to do something or how to live
The Philosophy of FileMaker The Philosophy of FileMaker aims to teach you how to think about FileMaker in a meaningful way and not just regurgitate techniques. Too many developers blindly follow what they read on a blog or an article or a book without thinking about whether there is a better approach. With FileMaker there are always multiple approaches. The goal of this book is to teach you how to think on your own so you can solve your own unique problems using the best solutions available.
“Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.” - Anne Isabella Thackeray Ritchie
The Reader It’s easy to say an educational resource is designed for intermediate or advanced or expert level FileMaker developers. But, what does that really mean? How is an advanced developer gauged? What makes someone an intermediate developer? It’s pretty easy to determine a beginner since they just recently started their FileMaker journey. An expert developer is also easy to recognize as they have been working exclusively with FileMaker for a decade or more and have probably passed all the FileMaker certification tests. It’s all the in-between that’s tough to figure out.
My guess is you, the reader, fall into this undefinable black hole of knowledge seeking. Most people are not experts. Others don’t want to go beyond the basics. That’s not who I’m writing to in this blog. I’m writing to all the aspiring FileMaker developers who want become professionals. You might be a hobbyist, an in-house developers or even a full time FileMaker consultant. Whoever you are, this blog aims at teaching this widely diverse audience to the best of my ability.
If you have a passion to be better than the average developer then read on and enjoy!