Semi-Sorted A database can either be sorted, unsorted or semi-sorted. The first two are pretty obvious, but it is less clear how a database becomes semi-sorted. A database becomes semi-sorted when a new record is added to a currently sorted database and the option to keep records sorted is unchecked. It can also become semi-sorted if a record is edited -- but only if one of the fields used in the sort is edited. Deleting a record will not make a database semi-sorted.
Dull Boy FileMaker files were stored in clear text prior to FileMaker 7 so, if you opened a FileMaker file in a text editor, you could see the phrase "All work and no play makes Jack a dull boy" in the header repeated over and over. No, it's not a virus! My understanding is the developers just needed to take up some space in the header and that's what they came up with. Today, modern FileMaker files are stored in Unicode so I'm not sure if the phrase is still there.
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!