Innovative Data Solutions

Category Archives: MySQL

Benefits of ExecuteSQL

Previously in this blog I have discussed the new ExecuteSQL functionality in FileMaker12 and how useful I find this. I would like to share with you one example of how I have used this.

Jason Erickson joins Linear Blue

Linear Blue are proud to announce the merger of the SyncDeK & fmDataGuard product suite to our expanding product range. 

A quick case study in FileMaker scaling

Recently we’ve been looking at how well FileMaker scales. Typically we need to consider this when faced with large volumes of data or high loads caused by user demands on the system.

Best FileMaker 12 Feature

FMP12A_boxshot

Filemaker 12 has now been out for a few months and we have had a chance to use all the new features in anger. But which is the stand out improvement to FileMaker

To celebrate our 12th Birthday, we’ve launched our new brand and website..

image-6

We’ve just taken the covers off a completely redesigned website of our own. The new Linear Blue site is based on a design by prestigious branding and design company, CaB Studios.

Are FileMaker plug-ins dead?

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.

FileMaker Technical Network

The FileMaker Technical Network is now free for FileMaker developers, designers and users to share their knowledge and skills amongst one another.

PauseOnError [x] London 2011

PauseOnError London was a great success! FileMaker developers, speakers and sponsors flew from all over the world to attend the first Pause on Error event in Europe.

FileMaker can not take NULL for an answer

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…

Why Prepared Statements in MySQL are a Good Thing

This was originally intended to be a blog on useful tips to get around the limitations of PHP’s bind variable methods when using prepared statements, however the ‘short introduction’ got a little out of hand, so instead you’ve got a post about using prepared SQL statements with PHP (which is probably a more interesting choice…