FileMaker Magazine Posted October 4, 2012 Share Posted October 4, 2012 by Matt Petrowsky 55 minutes Article options Watch Full Version Download Technique File Download Movie File The native display method for related data in FileMaker has always been the good ol' built-in portal. This flexible tool has been used for its intended purpose as well as for unintended - such as for hiding and showing a button. With FileMaker 12's new ExecuteSQL() function you can now dip into the data bucket of any given table, or tables, and pull out exactly what you need. ExecuteSQL is useful for dynamic charting and filtering portals based on desired key values. It's a very flexible tool for sure. There are, however, some not so obvious "secrets" to making FileMaker's SQL implementation jump through the types of hoops that will allow you to generate some really cool stuff such as HTML. When you combine this knowledge with understanding how networking and performance may apply, you can accomplish some really useful things with ExecuteSQL() and Web Viewers. That's what this video is all about. It's an implementation of HTML based comments and provides you with some of those "hidden" tricks to making ExecuteSQL sing like song bird! Details: Released - 10/4/2012 / Size - 137.95 MB / Length - 55 min View the full article Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4227 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now