Kevin Frank: FileMaker's Internal SQL Engine for Developers


Update 3/3/2011: You can download a demo file with the custom functions I showed at this session here --
http://fmforums.com/forum/topic/76921-custom-functions-for-fql/



This session will focus on practical FM/SQL implementation in your solutions. Not an intro, but the "merely curious" are welcome (as of course are grizzled SQL veterans). If you're using FileMaker's internal SQL engine, or considering doing so, this is a session you won't want to miss. As always, come prepared to contribute. Kevin says “Ernest and Corn: you’re profoundly invited.”

Topics of discussion will include:
  • The day-to-day reality of using SQL in your FM solutions
  • Common mistakes FM/SQL developers make, and how to avoid them
  • Some custom functions that can make your life easier
  • Insert/Select and surrogate keys
  • The wondrous beauty of SQL joins
  • Changes to the SQL parser in FM 11

Topics of discussion will not include:
  • ODBC
  • JDBC
  • ESS
  • What is SQL?

Suggested reading:
1. FileMaker 11 OBDC and JDBC Guide (chapter 7: "Supported Standards")
2. Wikipedia SQL Entry

Links to some of the SQL plug-in vendors:
1. MyFMButler (doSQL)
2. CNS (MMQuery)
3. Dracoventions (SQL Runner)


Subject Author Replies Views Last Message
No Comments