Script Trigger pitfalls: Get(LastError)
May 20th, 2009
Today I implemented some script triggers in an existing project and something strange happened. My navigation scripts that have worked correctly for years, suddenly stopped working. I checked my scripts over and over again and couldn’t find any clue, until I discovered an unexpected behavior.
Read the rest of this entry »
Enhanced Changelogs with DoSQL
April 29th, 2009For this week’s blog article, we want to extend a special thanks to Kevin Frank and Dave Walton who sent us the example.
When using DoSQL to create a ChangeLog of your records, you want to avoid creating log records when nothing has actually changed.
The trick is to prevent DoSQL from firing unless you want to log a change… take a look at the example and check the validation on _K in the Data table… basically, if the parent sees that nothing has changed since the last corresponding ChangeLog record was created, then doSQL won’t trigger.

Note that if you have no ChangeLog record for a given parent record, then it will be created *regardless* of which parent field you edit, but… once you have at least one change log record for a given parent, then any “don’t log” fields will be respected.
The thing I like about this technique is that ChangeLog records will be created when a Replace is performed and when parent records are imported.
PrinterSwitch and “Data Execution Prevention” on Windows
March 31st, 2009Lately we have been getting regular reports from people experiencing a problem when trying to use PrinterSwitch on systems with Windows Server 2003/2008 or Windows Vista (and 7).
After running the installer, and starting FileMaker, the PrinterSwitch plug-in is not automatically enabled. Manually trying to enable it generates an error message “myFMbutler PrinterSwitch could not be enabled”.
This problem is caused by certain security settings of the above versions of Windows, by a feature that’s called “Data Execution Prevention”.
To correct the settings, do the following:
Read the rest of this entry »
AutoSender 2.5.5 now available
March 17th, 2009We just released a maintenance update to AutoSender.
AutoSender is still the easiest way to automatically send e-mail from your FileMaker solutions, with integrated support for multi-part messages with both HTML and plain text alternatives, and the possibility to include enclosures from a local network path, or an FTP or HTTP path.
What’s new in 2.5.5:
Download the latest version here.
New DoSQL 1.2 allows for more universal SQL calculations
February 5th, 2009We just released version 1.2 of our DoSQL plug-in.
This new version provides a new function:
mFMb_DoSQL_QuoteField( fieldname )
The function converts “FileMaker-style” syntax like my Table::my Field to SQL syntax like “my Table.my Field” (with quotes). The nice thing about this is that it allows you to double-click a field to insert it in a calculation.

Combined with FileMaker Pro 10’s new ‘GetFieldname’ function, this allows you to make the SQL statements much more universal.
Download this example for more details on how this can be used (make sure you have version 1.2 of the DoSQL plug-in installed)
Although the use of spaces in field names is not recommended, this solution will continue to function properly if you do use spaces.
Clip Manager 3.1 now available
January 29th, 2009We just released version 3.1 of Clip Manager. This is mainly a bug fix update, but it also adds some new features, like support for regular expressions.

Download version 3.1 from the myFMbutler downloads page or use “Check for Update” if you are an existing user of Clip Manager.
myFMbutler products and FileMaker 10 compatibility
January 9th, 2009We wanted to give everyone an update on the compatibility status of our products with FileMaker 10:
Initial testing of our plug-ins (DoSQL, DoScript, PrinterSwitch), have not shown any compatibility issues with the FileMaker 10 platform.
AutoSender 2.5 also seems to work fine with FileMaker Server 10, although we’ll be providing a small update that will integrate a new JDBC driver by February.
Clip Manager 3 does have some issues for people trying to ‘Get’ or ‘Set’ a custom function with FileMaker Pro 10 Advanced. We will be releasing version 3.1 later this month. This version will also provide a number of other fixes.
We also recently found issues (unrelated to FM10) when using the ‘Copy to Clip Manager‘ function on Brian Dunning’s CF web site. Starting with a certain build of Flash 9 and all builds of Flash 10, the copying no longer works. We are currently working on a fix and hope to provide it by next week (actually, we already fixed it today).
Special Thanksgiving Promotion!
November 26th, 2008AutoSender 2.5.3 now available
November 25th, 2008We just released a maintenance update to AutoSender.
What’s new in 2.5.3:
Download the latest version here.


