In theory, the answer is yes, but the data is going to come back to you as a big delimited text field.
So, once you have your returned data, you need to parse it out into Filemaker Fields or variables to get the data to display on a layout.
In practice, this is reasonable for doing relatively small record sets or summary reports. For large data sets, it gets to be more trouble than it's worth, IMHO.
The function is best used for getting values from related tables without having to setup relationships, and for summarizing data.
Hope that helps!
1 of 1 people found this helpful
Yes, you can do this. There are a couple of different methods:
1) The Virtual List technique, developed by Bruce Robertson, quite cleverly allows you to change a return delimited series into a list view. You can read about it using one or more of these resources:
Or just do a search on this forum.
2) You can parse the ExecuteSQL result out as an HTML table easily enough (just replace your field separator with "</td><td>" and use "</td></tr><tr><td>" as your record separator). Clean it up a bit and you can display it in a web viewer.
To your other question, yes you can display the data in a chart. Just select "Current Record - delimited" for the data series and store the query results in a variable.
I am looking for tutorials on how to build this and the links are broken.
If the quantity of data returned fits on a single page you might be able to get acceptable results simply by sizing the field (one defined as a calculation field with your SQL query or set by script to the query results), to fill the page and using paragraph formatting options on the data. You can specify the tab character as your field separator and a return as your row separator.
But if you are reporting summary data, don't forget summary reports. These can be a lot less complex to set up if the resulting format is what you want.
3 of 3 people found this helpful
These articles (parts one and two) are similar to the technique as found in the FileMaker Training Series (Advanced):