BLOG

Advantages of ExecuteSQL + Get Clear Error Messages with ExecuteSQLe

FileMaker’s ExecuteSQL function has been available for quite some time and is a powerful tool in your developer's tool kit. While FileMaker’s native relational model is simple and intuitive, the ExecuteSQL function introduces an additional level of flexibility, enabling developers to access data across tables without creating extra table occurrences or relationships. The recent release of FileMaker 21.1 represents a significant enhancement to SQL functionality with the new ExecuteSQLe function. One of the biggest limitations has been addressed - error reporting. Unlike ExecuteSQL, ExecuteSQLe provides the return of clear error messages, enabling developers to troubleshoot queries much more effectively. If you’ve been frustrated with ExecuteSQL’s cryptic “?” symbol, ExecuteSQLe’s feedback is a welcome change. Read more
Read More

The Importance of Test Data in FileMaker Solutions and FM-Backed Web Apps

Your data is valuable and protecting it is vital in terms of legal obligations, your business reputation, competitive advantage, and more. The importance of test data in FileMaker is a discussion worth having when starting a new project or updating your solution. One easily overlooked area of data protection is the security of your data in the development and test versions of your solution, whether a FileMaker solution or a web application. While your live production data may be carefully secured, the copy of the data made for testing, especially if residing on an outside server, may not be safe. Read more
Read More

DEMO: Didn’t Know You Could Do That With A DataTable!

As Claris FileMaker developers we are always on the lookout for resources that will enhance our solutions in an easy and intuitive way. DataTables can be a rather challenging feature to implement from scratch without some serious learning and research, but resources like the popular Carafe Kitchen provide a great starting point for anyone wanting to implement a basic DataTables integration. Like any great resource though, it’s important to understand its limitations. While Carafe offers a great tool kit for basic DataTable integrations, it’s not always the easiest to expand so today we’ll explore two development processes for creating your own DataTables integration - Carafe Kitchen and JSDev.

Read more
Read More