Learn how to populate a SQL table with data generated within a FileMaker app using ExecuteSQL.
The Data Viewer is a feature of FileMaker Advanced that gives you under-the-hood access to your data. Agnes gives you some examples of how to use the Data Viewer when creating custom apps.
A seemingly small but important change in FileMaker 15 is the addition of the Truncate Table script step. If you have developed with SQL databases, this function will be familiar to you, but you may be interested in some details and differences with how it works in FileMaker.
Get the slide deck and demo files from Wim Decorte’s “Deep-Dive Scripting, an Audit log…” DevCon session.
In some cases, a FileMaker developer needs to determine if two date ranges overlap. That is a daunting task with standard techniques using complex relationships or a long ExecuteSQL query. In this post, we examine a simple way to determine if two date ranges overlap. It solves some real-world problems and is extremely easy to use.
Learn how to use FileMaker mySQL to maintain dependencies and business logic associated with FileMaker tables after they have been moved to mySQL.