Q: Can you select data from an external FMP file, e.g. Q: Example 15: If searching for created (date) = ’′ is it using system formats or does the date need to always be ‘yy/mm/dd’? A: As far as I know, the only valid syntaxes for specifying a date constant are “DATE ‘′” and “’′”. The ExecuteSQL function is a convenient way to access data from any context. For example, gathering data from different contexts for a chart or web viewer used to require either a script or additional utility relationships. However, it does make some things much more convenient.
It doesn’t let us build anything that isn’t possible without it. Why would I choose to use ExecuteSQL instead? A: The ExecuteSQL function is just another tool. Q: ExecuteSQL allows me to do many of the same types of things I can do in FMP without ExecuteSQL. The script is called “Find contacts ( id list )”. Q: Is there an example of how to parse the data and create records from it? A: Not exactly, but the example file includes a simple script that parses the data from an ExecuteSQL function and creates find requests. Just remember to escape the double quotes if you’re specifying them in a calculation. Q: If a field name does not normally require double quotes around it, will putting double quotes around it alter the way ExecuteSQL functions? A: It’s perfectly fine to include double quotes around any table or field name. Q: …how about using single quotes to get globals? A: Global fields can be used in a query. I covered a few examples of this in the webinar. The example below would return all of the records from the contacts table sorted by last_name and then first_name: SELECT * FROM contacts ORDER BY last_name, first_name Q: If FileMaker only supports SELECT, what is the actual vulnerability if a user attempts to use DROP, as in your charming cartoon example? A: While it isn’t possible to DROP a table using ExecuteSQL, the function is still vulernable to certain SQL injection attacks if the developer chooses to include user-supplied text in a calculated SQL query. Q: Is it possible to use the SQL CASE function? A: Yes, here’s an example of the syntax: SELECT first_name, CASE WHEN s=’M’ THEN ‘Boy’ WHEN s=’F’ THEN ‘Girl’ ELSE ‘Unknown’ END FROM contacts Q: Can you sort the data? A: Yes, the “ORDER BY” clause can be used to specify the sort order for the records. If you missed it, you can still catch the recording at FM Academy or download the example file.
Thanks to everyone who participated live or via the recording.
If you still have a question, feel free to contact us. I’ve included answers below for all of the questions we weren’t able to address during the webinar. We received a lot of great questions during the session. I was overwhelmed by the positive response to my 12 Days of FileMaker 12 – ExecuteSQL webinar.
0 kommentar(er)
