Ultimate SQL Mastery
When embarking on your journey with FileMaker, you encounter the wonderfully visual tool known as the Relationship Graph, which grants you the ability to visually comprehend the intricate interconnections within a complex solution. In fact, the relationships used to link table occurrences in FileMaker are fundamentally akin to those in SQL.
FileMaker essentially offers a visual representation of what would otherwise be a textual definition of a SQL statement. The key distinction lies in the fact that SQL operates within the realm of text and only executes when required. Conversely, the Relationship Graph in FileMaker is persistent and is continually assessed by FileMaker. Consequently, comprehending the implications of specific relationships in your solution becomes vital as your solution expands. Relationships that appear ostensibly simple, serving utility purposes within your user interface, might have more profound ramifications than you initially realize. Hence, it is imperative to comprehend and effectively employ all of your available tools.
One of these indispensable tools is FileMaker's full SQL implementation. In this video, I delve into the advanced aspects of using SQL within FileMaker. If you've constructed your FileMaker solution exclusively using native FileMaker features, you might unknowingly incur a big cost if you haven't invested time in learning FileMaker's SQL capabilities.
Comments
Should warn about dependency on paid plug-in
Although I am personally use and am a fan of the MBS plug-in, I wished in your description had specified the dependency on this plug-in, as not all clients are willing to take on the extra costs.
Guillermo Leal
Please try the BaseElements plug-in
While the MBS plug-in will create the SQL for you AND you can opt to run the plug-in server side (limiting the number of client installs required), you can also try out the BaseElements plug-in which will run SQL for free - although I suggest sending some money their way if used commercially.
There are free options for using FileMaker's full SQL capabilities.
-- Matt Petrowsky - ISO FileMaker Magazine Editor
SQL joins
Hi Matt,
I remember a video of yours from not too long ago where you warned about using SQL JOIN. If memory serves right, I think you said it would consume memory / cache and slow everything down. Was that fixed, or am I misremembering? I use a lot of simple SQL calls to grab data quickly. Would love to expand that usage.
Thanks,
Alex
Using SQL calls/functions on FM-GO?
Can you clarify if mobile apps (Go) are able to utilize these SQL functions/plugins?