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 […]
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.
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
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
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
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.
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
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.