DoSQL Changelog

Back to DoSQL

• - DoSQL 2.0.0.26 - 5th March 2013
  
  • Fixes a bug in mFMb_DoSQL_Parameter( <index> ) returning an error 8 ( empty result due to invalid index ).
• + DoSQL 1.4.4 - 26th July 2011
  
  • fixed issues for Mac OS X Lion.
  • support for passing a text string as the parameter to the functions mFMb_DoSQL_SetColumnSeparator() and 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 - 10th August 2011
  
  • 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 is 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 this download.
• + DoSQL 1.2 - 5th February 2011
  
  • Added mFMb_DoSQL_QuoteField( fieldname ) function for automatic conversion of “FileMaker-style” syntax like my Table::my Field to SQL syntax like “my Table.my Field” (with quotes), which means fields can now be double-clicked to insert them in a calculation – check the file “New in DoSQL 1.2” for an example.
  • Added new function mFMb_DoSQL_GetTableFrom( fieldname ) – check the ‘DoSQL Reference’ file for more details.
• + DoSQL 1.1 - 12th August 2011
  
  • Added new VersionAutoUpdate function for use with FMS AutoUpdate.
  • Added new functions mFMb_DoSQL_LastErrNum, mFMb_DoSQL_LastResult and mFMb_DoSQL_LastSQL – check the ‘DoSQL Reference’ file for more details.
• + DoSQL 1.0.2 - 19th December 2007
  
  • Now supports server-side script scheduling.
• + DoSQL 1.0.1.6 - 12th December 2007
  
  • Fixed an issue with the plug-in always evaluating from the context of the frontmost window. The plug-in now evaluates from the context where it’s called.
• + DoSQL 1.0.1 - 26th July 2007
  
  • mFMb_DoSQL_Configure (“register”) function can now be used with any multi-user version of DoSQL.
  • Fixed bugs in the mFMb_DoSQL_Configure (“register”) function.
  • Minor changes to manual and examples.
• + DoSQL 1.0.0 - 15th May 2007
  
  • First public release.