how to show all fields and tables in filemaker pro 14

While testing the SQL queries I discovered that the tablename in each SQL statement refers to FileMaker’s table occurrence name, not the base table name. Never before having tried SQL in FileMaker, I started small, testing a basic query to discover constraints or differences in the SQL language from my experience with MySQL. Although I probably could have accomplished this in FileMaker, I like the elegance of SQL as it allows you to select data from various tables, and return only the results that you need. 1 million records each and finding the records from Table A that were missing in Table B, and then make some adjustments to these records. My task required comparing two tables with ca. 2empowerFM SQL Runner from Dracoventionsįor my testing I used MMQuery, and primarily its ExecuteSQL( query ) function.Several plugins enable access to FileMaker Pro 11’s internal SQL via functions. When creating or finding records through scripts, for instance, failing to start on the right layout could lead to drastic consequences.

Some of the reasons to look at SQL in FileMaker include context-free queries, a simplified the relationship graph (fewer TOs in the graph), avoiding complex finds in scripts, and flexibility in building reports. In FileMaker, context is king. However, I believe there are times when the power of SQL combines nicely with FileMaker to produce better, smarter solutions, and this makes learning and using SQL worthwhile. Also, almost everything that SQL does within FileMaker can be natively accomplished without adding plugins. You might ask why bother, since SQL is a complex language with specific syntax we must learn outside FileMaker. One such hidden tool is FileMaker’s internal SQL engine, which intrepid developers expose via plugins. Dig deeper, invest some time and effort, and you expose powerful tools and options that extend your solution. As a rapid development database you can create a robust and elegant solution fairly quickly. FileMaker Pro succeeds as a database system because of its many layers.

How to show all fields and tables in filemaker pro 14