![]()
To set non-text data use BEClipboardSetFile' '107' 'BEFolderCreate ( path )Folder CreateCreates a new folder at the location path. You only need to apply a single format when setting the clipboard. BASEELEMENTS PLUGIN ADDRESS A SQL DATASOURCE PROUpdate 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. When setting a type it's best to copy a sample and then use BEClipboardFormats to see what types are used. 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. 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. 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. Along with the new HTTP Post functions, the latest version (1.3 as of ) includes lots of new functions and is quickly becoming the Swiss Army knife of FileMaker plug-ins. We use a recent feature in FileMaker to have a dynamic file path, and calculate the path to the prefs folder on startup. The BaseElements plug-in is free, open-source, and is a terrific option when looking to extend FileMaker via a plug-in. We do this by keeping the ClipManager file in the preferences folder, instead of alongside the three main BaseElements files. BASEELEMENTS PLUGIN ADDRESS A SQL DATASOURCE UPGRADEPlug-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. Anything you put in the ClipManager is kept even if you upgrade to a new version of BaseElements. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |