Greg Lane, Skeleton Key, hosted FM Academy's tenth webinar in the 12 Days of FileMaker 12 series, on May 10th. 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.
You may also download the demo file, with all the examples shared during the webinar: http://www.skeletonkey.com/Downloads/...
Visit Skeleton Key: http://www.skeletonkey.com
View all of Skeleton Key's Technical Videos: http://www.youtube.com/skeletonkeystl
Connect with us:
http://www.facebook.com/skeletonkeystl (company page)
http://www.facebook.com/skeletonkeycrew (profile page)
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.