Update for Claris FileMaker Pro 19.4.1 – a new faster query to return base tables is now available in Claris FileMaker Pro 19.4.1 or later. I am running a script to send an html email with an attachment. ![]() I have the same version installed on my local client. I can see the plugin in the extensions folder. I have installed BEversion 4.1.4 plugin on FileMaker Server 19. If you would like support for the plugin, please consider taking up a paid support and sponsorship option. Our plugin will always be free, and there is no registration or licencing required to use it. BaseElements-Plugin/BaseElements. /rebates/&252fbaseelements-plugin-sql. Base Elements plugin works locally, not on server. The BaseElements Plugin runs in FileMaker Pro on Mac and Windows, on iOS in the FileMaker Go SDK and in Linux on FileMaker Server for AWS. Details can be found in this article.įileMaker Pro v12 introduced the new ExecuteSQL function, which allows you to perform an SQL query on your FileMaker database. FileMaker Pro plugin used for BaseElements to provide file, dialog and XSLT functions. The query can can combine the results of two queries, include dynamic parameters, and lets you specify relationships independent of the relationships graph. It is presently limited to the SELECT statement, which is similar to doing a find using the native FileMaker Pro commands, but is not tied to a particular layout or relationship. I’m going to discuss one particular use of the ExecuteSQL function in this post: the ability to query 2 “virtual tables” for information about the schema of your FileMaker Pro v12 files. Plug-ins that utilised the SQL functionality have also had the ability to query 2 hidden virtual tables for information about the schema of your. The ability to execute SQL statements has been available via the external plug-in API since FileMaker Pro v7.0v3 was released, and many plug-ins have included this functionality, including MMQuery and the BaseElements plugins. baseelements plugin sql update Now that we have the ability to perform native SQL queries using the ExecuteSQL function in FileMaker Pro v12 we can also query these virtual tables. Plug-ins that utilised the SQL functionality have also had the ability to query 2 hidden “virtual tables” for information about the schema of your FileMaker database, including Table Occurrences and Field Names. Now that we have the ability to perform native SQL queries using the ExecuteSQL function in FileMaker Pro v12 we can also query these “virtual tables”.
0 Comments
Leave a Reply. |