After much deliberation, I finally figured out that the problem was that I had “Smart Quotes” turned ON in the File Options.
I swore I had it right, but I couldn’t get it to work.
Age calculation in filemaker pro 6 how to#
This is a fantastic tool, especially for people (like myself) just learning how to utilize Execute SQL!Īfter installing it and trying to use it, I spent over 2 hours and couldn’t get a single query to work right. Let me know what you think, or if you find a bug (not that that would ever happen), or if you have a suggestion on how to improve it. I also created a video to demonstrate how to make the most of this utility.
Age calculation in filemaker pro 6 install#
You can use the file in your solution in one of two ways: either add table occurrences from your solution to this file or install it as a module into your solution, (which takes about a minute to do). I followed Todd Geist’s Modular FileMaker approach and submitted the tool on his site.Ĭomplete this form to get the Query Builder tool. Download Our Complimentary FileMaker SQL Builder These last two steps – troubleshooting and name abstraction – end up being a bit of a nuisance, so I built a tool to make this easier and faster to do. My Query Builder tool also does some SQL formatting to make queries easier to read. Finally, I abstract the field and table names so that the query doesn’t break if the names end up changing later.
If the query has some moderate degree of complexity, I usually end up having to wrap it in Andries Heylen’s sql.debug custom function at least once along the way to troubleshoot what I did wrong. This process involves opening up the Data Viewer and writing out the query there. It just seems faster that way, especially now that I’ve gotten some SQL experience under my belt. Unfortunately, as I create new queries for current projects, I find myself inclined to type them out manually instead of using a wizard (which is how SQL Explorer works). I like the SeedCode SQL Explorer developed by Jason Young. There are several excellent utilities available for constructing SQL queries for use with FileMaker’s ExecuteSQL function.
0 kommentar(er)
