addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrosseditemptyheartexportfacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

DIGFM March Meeting - "Making Friends with ExecuteSQL"

This is the March DIGFM Meeting, hosted by FileMaker Inc. at their HQ (The Wedge).

Here is the information regarding the meeting:

"We've all heard that the ExecuteSQL function is a very powerful addition to FileMaker 12 and 13, and DigFM has hosted several talks demonstrating the power of this function. Nevertheless, some FileMaker developers have shied away from this function. First, you have to know SQL, even though FileMaker's implementation of SQL [aka "FQL"] differs in small but sometimes significant ways from the SQL used by other databases, such as MySQL or PostgreSQL. Also, if used improperly, ExecuteSQL can be a fragile command: changing a field name or a table name can break your application. The syntax can also be a bit finicky, and this has dissuaded busy developers from devoting the time to master it.

This presentation will focus on a methodology that virtually guarantees that your ExecuteSQL commands will work the first time, and will continue to work in the face of a wide variety of database changes. It doesn't require any third-party solutions or add-ons; it's just a matter of doing the right thing in a highly-disciplined way."

"Steve Hanna has been a freelance FileMaker developer for more than two decades. He's a member of FMPug and a regular at the monthly meetings. Prior to that, he was an engineering manager at Intel, and has consulted with Intuit's Computer Security group. Besides developing database applications, Steve is also an instructor at Ohlone College in Fremont, where he currently teaches American and European history, U.S. constitutional law, and cybercrime, and has taught C and C++ programming and mathematics."

Networking, pizza and refreshments at 6:30 PM, with the meeting starting at 7:00 PM.

Be sure to visit the DIGFM website for details and links to the FMPug form to formally RSVP.

#FileMaker #DIGFM #FQL

Join or login to comment.

  • Lisa H.

    i didn't make it over there. Would really love it if these things got recorded. I bet a lot of other far flung developers would DIG that too.

    March 20, 2014

  • Jose R.

    Be a little late

    March 13, 2014

11 went

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy