schema

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.

Photo of three smiley faces on yellow paper - one said, one neutral, one happy. With the happy face highlighted by a magnifying glass.

Make Gains with a Professional Third-Party Software Evaluation

If you already use  FileMaker Pro and the Claris platform for managing your custom database and workflow automation, you are aware of the key role it plays in making your processes more efficient and your firm more profitable.  To ensure it operates at peak performance, however, a professional third-party evaluation can be invaluable. This article discusses the process we use for this kind of evaluation, which will hopefully shed some light on this valuable endeavor.

Graphic of icons depicting the new custom connectors feature in Claris Connect and the possibilities of connecting to any API

How To Utilize the New Custom Connectors In Claris Connect

We are excited to announce the latest feature in Claris Connect – custom connectors! This newest and greatly anticipated feature is now available in every Claris Connect account. This means we are no longer limited to just the pre-built connectors but can now create a customized connector for virtually any API that exists.

Scroll to Top