The topic – ExecuteSQL:
FileMaker 12 adds a dozen new functions, including the much anticipated ExecuteSQL, some Location functions for iOS devices, new ID functions, a set that accompany the new container method, and others.
FileMaker 12’s new ExecuteSQL function opens up the power and flexibility of the SQL query language to any FileMaker calculation. This webinar presented techniques for using the ExecuteSQL function, within calculations to gather and manipulate data for reports, charts, dashboards, and more. We used a variety of built-in and custom functions to slice and dice data in a variety of context. We also covered the basics of the SQL SELECT statement to help anyone get started quickly.
If you missed this webinar, you can watch the recording below. You may also download the demo file, with all the examples shared during the webinar, by clicking HERE. Stay tuned for our follow up blog which will explore, in greater detail, answers to the questions that were covered at the end of the video. You can check out other past webinar videos at FM Academy YouTube Channel.
ExecuteSQL – Video:
About FM Academy
FM Academy is a consortium of seven FileMaker Business Alliance Platinum companies. Our goal is to educate FileMaker users and developers, encourage best practices, and foster adoption of the FileMaker platform. The members of FM Academy are 360Works, Anvil Dataworks, Fiddlehead Software, IT Solutions, KyoLogic, MightyData and Skeleton Key.
About Skeleton Key
Skeleton Key is an accomplished team of technology consultants who solve business problems. We specialize in the rapid development of custom applications, integrating Macs and PCs in the professional workplace, and providing
personalized FileMaker training and coaching.
Skeleton Key is a Platinum Level FileMaker Business Alliance company, an Authorized FileMaker Trainer, a member of the Apple Consultants Network and a Microsoft Registered Partner.