Archive for August, 2010

Clip Manager 4 Pre-release for Mac OS X

Thursday, August 12th, 2010

We are pleased to make a pre-release version available of Clip Manager version 4. Clip Manager 4 is an application that allows you to store FileMaker fields, tables, scripts, script steps, custom functions and layouts in an easy-to-use library.
A year ago, our development team started from scratch with the development of Clip Manager 4 to make the best and most powerful release since the first version. Clip Manager 4 was built for FileMaker Pro 11.

CM4_icn.png

What's new in Clip Manager 4 ?

  • New fresh user interface
  • Growl Support
  • Clip View shows a clip in a more readable format in addition to the XML view
  • Clip Info via a new Inspector Window
  • Improved XML Editor
  • Clip Manager Status Menu Bar Item
  • Improved History
  • Snippets
  • Occurrence Selector floating palette
  • Spotlight Search
  • Custom Function conflict resolver
  • Support for the new XMFN format
  • Automatic conversion of older Clip Manager formats
  • Set clip in Clipboard without opening the clip, using the contextual menu

Download the pre-release for Mac OS X here. Updates to the app will automatically become available via the update mechanism.

FileMaker DevCon in San Diego

myFMbutler will again have a booth at this year's conference. Those who are attending may want to drop by the booth to get a preview of Clip Manager 4.
Also, during DevCon, myFMbutler products will be offered at a 25% discount when customers use the coupon code 'DEVCON10' in the myFMbutler web store. That way you can purchase Clip Manager 3 at a discount now and get a free upgrade to version 4.

DoSQL 1.4 for FileMaker Pro 11 released

Tuesday, August 10th, 2010

This is a simultaneous release of DoSQL 1.4 for FileMaker Pro 11 and DoSQL 1.3.1 for FileMaker Pro 10 and earlier.
Version 1.3.1 uses the older FileMaker SQL engine, version 1.4 uses the new engine in FileMaker Pro 11.

About some of the changes in this version:

  • 1.4 solves the problems under FileMaker 11 with SQL statements that feed the result of a SELECT into an INSERT
  • Fields starting with an underscore "_" have to be quoted
    e.g. mFMb_DoSQL ( "select \"_k1\" from myTable" )

  • Number values cannot be quoted: if you have a number field, you cannot write or update it with a single-quoted value. '1' is forbidden, 1 is OK. Use NULL for empty fields.
  • Date, time and timestamp fields have to be casted. Simply single quoting a date doesn't work anymore. It's good practice to replace a single quoted date with
    "CAST ( " & mFMb_DoSQL_Quote ( Year ( theParameter ) & "-" & Month ( theParameter ) & "-" & Day ( theParameter) ) & " AS DATE )" in a custom function.

  • Error reporting with the new engine is different. The new engine now returns error values 8309, 8310 and sometimes a few others. The first indicating a semantics error, the other a syntax error. There is also additional error reporting in the FM11 SQL engine. You can get that information using the mFMb_DoSQL_lastresult function. A list of the possible FQL errors is included in the DoSQL download.
  • For more details about the new SQL engine and the SQL statements that are supported, please refer to the FileMaker documentation available here.

    More information is available on the DoSQL product page.