Click this video (use the full screen or click to go to YouTube) to see what you may be missing in your copy of FileMaker Pro! I don't develop without it!
SQL Based HTML Comments
Posted by: Editor / Thursday, October 4, 2012 – 6:00pm
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
Let us tell you when a new video is posted. We'll send you an email with a direct link right to your email inbox.Make sure and whitelist (or add to your address book email@example.com
10 Most Recent Videos