The recent upgrade Claris FileMaker introduced transactions. FileMaker has, until now, only been able to commit one data record at a time. In a relational database this “per record” approach has drawbacks. When we do something complex we may create several records, or create records in several different tables. Using FileMaker’s “per record” approach, each […]
Transactions in Claris FileMaker 19.6.1 Read More »
In the.fmsoup recently we discussed an issue raised by @menno. He had seen that local variables declared in one object on a layout were accessible in other areas. His immediate concern was that this was a security issue as it was possible that data would be accessible in places where it should not be seen.
Layouts and Local Variable Collisions Read More »
Button bars were introduced to FileMaker in 2015 with version 14 and they quickly became a favourite tool for managing many different layout and display jobs. The ability to display an SVG or PNG image beside a text label and link it to a script action made a mundane and laborious job easy and satisfying.
Many database applications are based on relationship models which are one-directional but there are other patterns that we will need from time to time. In this article we’ll discuss several common design patterns and then look at a more unusual pattern which can be used to handle situations which are difficult to structure or have
Reciprocal Relationships Read More »
We have been working on an idea that we like. It’s a universal menu for Claris FileMaker layouts. The idea is simple: have a layout control that you can update without having to modify every layout in the solution. Is it possible? Well, the project isn’t ready for prime-time yet but we’re pretty happy with
Sneak Peak: Universal Navigation Menu Read More »
This is the second part in a series discussing design patterns for Claris FileMaker databases. The first part discusses the use of data layers, check it out first if you haven’t read it already. What are Key tables, also known as “no data” tables? In this article we introduce Key tables. Key tables are an
Design Patterns: Key Tables Read More »
If you want to use your Sites folder in your account as a location for web dev then you need to modify httpd.conf to allow that.
FileMaker Server 19: Configure Apache User Directories on Mac OSX Read More »
The Problem Cannot open php file in htdocs folder. Message is “You don’t have permission to access the requested directory. There is either no index document or the directory is read-protected. You don’t have permission to access the requested object. It is either read-protected or not readable by the server.” Diagnosis PHP and/or web serving
FileMaker Server 19: Configure Apache for PHP on Mac OS X Read More »
Using number fields for IDs is reported to produce faster results for related processes on large data sets. For that reason the extra storage overhead would be justified by the benefits in performance for the user. To our surprise, we discovered that at large numbers, the storage requirements of UUIDNumber is less than for UUIDs.
Working the Numbers: choosing an ID based on storage requirements Read More »
Data layers simplify common data modelling problems. Data layers share the same core data and typically include several extra attributes which are unique to that layer.
Design Patterns: Data Layers Read More »
