The release of FileMaker Go has added a new variable to the equation we use when considering whether to use a FileMaker plug-in. We are experiencing a big shift to mobile solutions. Within less than a year ignoring the iOS platform became an unforgivable mistake for every FileMaker developer.
Read more…
While NULL is a concept familiar to SQL users FileMaker developers tend to have little exposure to the idea. Effectively NULL is the value given to a field who has no known value. It is distinct from an empty field or a field that contains the text NULL. NULL has some interesting characteristics most based around the fact that NULL ≠ NULL so SELECT * where field = NULL will never return any values; NULL never equals anything even itself. To test for NULL within MySQL the IS NULL function is used.
Read more…
Recently I’ve spent some time looking at FileMaker’s internal SQL support. In this article I discuss how we can use FileMaker scripting to add and delete tables from a FileMaker database.
Read more…
Unit testing involves testing software at a component level to ensure that each element is functioning correctly. This differs from system testing where we determine whether the complete system is working as expected.
Read more…
So we’ve now got a new version of FileMaker . It’s got improvements across the board which make it a better, more productive development environment. There are no dramatic surprises as FileMaker has kept up their mantra of slow and steady improvement in the product. Many of the changes appear to be small, but smooth away the rough edges. The .fp7 file format has been maintained, so no conversion process is required to use an existing post-FileMaker 7 solution.
Read more…
It would be rude not to introduce myself and start blogging! I will start by telling you a little bit about myself first.
Read more…
I had a conference call with a client, one of their biggest customers and the customers’ developers the other day. Both the customer and my client are having new systems written (my client in FileMaker, my client’s customer in MySQL and, i guess, HTML) and they are both keen on integrating stock figures.
Read more…
I have been doing quite a bit of work with smart pens recently so I thought I would drop in a quick primer on the technology.
Read more…
Whilst working on a project this week I had to access an image from a local directory on the hard drive through the FileMaker web viewer. It’s not as obvious as it might first appear. To start with you can’t just access the path directly.
Read more…
