Archive for the ‘DoSQL’ Category

Hurray, FileMaker 14 is here!

Wednesday, May 13th, 2015


Yesterday FileMaker announced the release of FileMaker 14. We, at myFMbutler, are really excited with this new release.

The new version of WebDirect is a real game changer. Not only does it bring FileMaker to other mobile platforms, such as the Android platform, but with the speed improvements it brings the experience of the desktop to the browser. The new Script Workspace and calculation window are one of the most striking changes in the FileMaker Pro client. However, the client has tons of small improvements and changes, which we will discover and enjoy the next few weeks.

With the release of the FileMaker 14 platform, myFMbutler is releasing several product updates and more is to come in the near future.

AutoSender 4


AutoSender 4 is a tool that runs on FileMaker Server, and allows you to automatically send mail messages from your FileMaker solutions. It supports both HTML and Text mail.

AutoSender also supports automatic sending of faxes or text messages through the use of a third party fax or texting service.

This new release is optimised for FileMaker Server 14, both remains compatible with older FileMaker versions. AutoSender 4 is available on our web site today.

Clip Manager 5 for Mac

We are pleased to announce that Clip Manager 5 is available today.

Clip Manager is an application that allows you to store FileMaker fields, tables, scripts, script steps, custom functions and layouts in an easy-to-use library.

You can copy and store objects that have been copied to FileMaker’s own clipboard, and then reuse them later.

You can also easily make batch changes to the clippings in Clip Manager or in your preferred text editor, and then send the updated field, script or layout back to FileMaker’s clipboard.

This new version brings full support for FileMaker Pro 14. It includes support for themes, retina displays, Yosemite and much more ...

Clip Manager 5 is available on our web site today.

DoScript 4

DoScript is a free FileMaker Pro plug-in for Windows and Mac that allows you to easily trigger scripts from within the FileMaker calculation engine. This new version brings 64-bit support and is compatible with FileMaker Pro 14.

DoScript 4 is available on our web site today.
 
 
 
 
 
 
 
 
 

64-bit: Help, the plug-ins don't load!

FileMaker Pro 14 is now a 64-bit application. This means that the plug-ins you use need to be 64-bit as wel. Most of our plug-ins are already 64-bit, but some are not ready yet and it takes more time to do the transition.

Does it mean you can't upgrade to FileMaker Pro 14 because one of your plug-ins is not 64-bit ready?
No, FileMaker has planned for this, and you can run or install your FileMaker Pro client in 32-bit mode too.

Check out our list of compatible plug-ins:

Plug-in 64-bit mode 32-bit mode
DoScript 4
DoSQL 2
Clip Manager Helper Plug-in
PrinterSwitch 2*
eID**
Clip Manager Bridge plug-in (Clip Manager 4)

* We expect an update of PrinterSwitch this summer.
** eID will be updated when there is better 64-bit support of the eID Middleware.

myFMbutler product compatibility with FileMaker Pro 13

Tuesday, December 3rd, 2013


Today FileMaker Inc. released FileMaker Pro 13. This must be one of the biggest releases in FileMaker's history.
We are very excited with this new release.

Below you'll find some information regarding compatibility of the myFMbutler products with FileMaker Pro 13.

It is important to ensure you are using the latest versions of our products. Download the latest versions here.

(more...)

DoSQL demonstrated at FileMaker Devcon 2013

Thursday, August 22nd, 2013

On Thursday the 15th of August, Koen Van Hulle hosted a session about SQL in FileMaker 12 at FileMaker Devcon in San Diego. This session gives you an insight of FileMaker's FQL engine (no, this is not a typo), and the differences between FileMaker's built-in ExecuteSQL function and the plug-in API.

You can find the slides of this presentation below.

DoSQL 2.0.0.26 Update

Tuesday, March 5th, 2013

We just released version 2.0.0.26 of our DoSQL plug-in.

myFMbutler DoSQL is a FileMaker Pro plug-in for Windows and Macintosh that allows you to to manipulate FileMaker data from FileMaker calculations. The plug-in more info

uses SQL statements to select, update, create or delete FileMaker records.

  • Version 2.0.0.26 fixes a bug in mFMb_DoSQL_Parameter( ) returning an error 8 ( empty result due to invalid index )

DoSQL 101: FileMaker Data Types

Monday, February 25th, 2013

Last week, we have seen how we can query data in FileMaker Pro 12, using SQL. This time we will focus on the data that returns from the ExecuteSQL function and the plug-in.

(more...)

DoSQL 101: Querying data

Tuesday, February 19th, 2013

Last week, we welcomed a new version of DoSQL. Starting this week, we are going to discuss the new features of doSQL and compare them with FileMaker’s native function. Today we will start with a simple example.

(more...)

myFMbutler DoSQL 2.0: Do more with SQL in FileMaker Pro 12

Monday, February 11th, 2013

myFMbutler doSQL 2
In FileMaker Pro 12, FileMaker inc. introduced a new calculation function, called executeSQL(). With this function you can execute a specified SQL statement within a FileMaker Pro database.
The benefits are legio. You can now write calculations or scripts that get related data independent of the relationships graph. It allows you to combine data and calculate with the results.

We, at myFMbutler, are very pleased with this new feature. It will fit most needs for a lot of the FileMaker developers. Does it mean the myFMbutler doSQL is no longer required and obsolete?
No, although the new function is fast and straightforward, there are still some caveats.

So, today we are proud to announce our newest version myFMbutler doSQL 2.0.

About myFMbutler DoSQL 2.0

myFMbutler DoSQL 2.0 is a FileMaker Pro plug-in for Windows and Macintosh that allows you to manipulate FileMaker data from FileMaker calculations.

• uses SQL statements to select, update, create or delete FileMaker records.
• writes to FileMaker fields directly, using a calculation with SQL statements
• does complex portal filtering
• easily updates data in unrelated tables
• keeps a change log of your records, add rollback functionality, audit trails, etc.
• limits the number of tables, relationships, fields, and scripts required for certain tasks
• doesn't require any drivers

What is new?

• Faster
• New DoSQL functions with simplified syntax, allows you to query and manipulate data without any SQL knowledge
• Returns native FileMaker data types like dates, images, formatted text, …
• Execute queries with parameters, to prevent SQL injection.
• Functions to work with result sets
• Debug tools to help you find SQL issues in your solution

System Requirements

FileMaker Pro 12 or FileMaker Pro 12 Advanced
FileMaker Pro 11 or FileMaker Pro 11 Advanced
FileMaker Server 12 or FileMaker Server 12 Advanced

Pricing and availability

myFMbutler DoSQL 2.0 is available today. DoSQL 2.0 prices start at EUR 29,- (about USD 38,-) for a single user version for Windows and Macintosh. Multi-user and developer versions are also available.
A demo version of DoSQL 2.0 is available for download on the myFMbutler web site.

myFMbutler product compatibility with FileMaker Pro 12

Thursday, April 5th, 2012

As you probably noticed, FileMaker Inc. released FileMaker Pro 12 yesterday. We are very excited with this new release.
Below you'll find some information regarding compatibility of the myFMbutler products with FileMaker Pro 12.

It is important that you ensure you are using the latest versions of our products. Download the latest versions here.

(more...)

DoSQL 1.4.4 Update

Tuesday, July 26th, 2011

We just released version 1.4.4 of our DoSQL plug-in.

myFMbutler DoSQL is a FileMaker Pro plug-in for Windows and Macintosh that allows you to to manipulate FileMaker data from FileMaker calculations. The plug-in uses SQL statements to select, update, create or delete FileMaker records.

What's new in 1.4.4 ?

  • fixed issues for Mac OS X Lion
  • support for passing a text string as the parameter to the functions
    • mFMb_DoSQL_SetColumnSeparator()
    • mFMb_DoSQL_SetRowSeparator()
  • the function mFMb_DoSQL_DataType() returns the data type of any field, value or variable. This helps when constructing correct SQL statements, since the new SQL engine is much more strict on data types.

 

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.