Xojo Conferences
MBSSep2018MunichDE
XDCMay2019MiamiUSA

Release notes for MBS Xojo SQL Plugin

MBS Xojo Plugins 18.3 - 17th July 2018

  • Added InternalCubeSQLLibraryMBS module to use built in cubesql client library.
  • Added InsertRecord and UpdateRecord methods to SQLDatabaseMBS class.
  • Added MemoryUsed, MemoryHighwater, Keywords and isKeyword to InternalSQLiteLibraryMBS module.
  • Added UpdateRecord method to SQLConnectionMBS class.
  • Changed SA_ODBC_SQL_WCHART_CONVERT setting for building SQLAPI on Linux, so we can connect to Microsoft SQL Server here.
  • Fixed a problem with ODBC crashing on Linux with using freetds to connect to Microsoft SQL Server.
  • Fixed auto commit issue for CubeSQL.
  • Fixed bug where SQL Plugin would return date with year 1899 instead of nil for empty SQLDateTime value.
  • Improved InternalSQLiteLibraryMBS.Shell function to reset global settings for further calls.
  • Improved SQLDatabaseMBS.InsertRecord to better handle float and integer number types.
  • Improved SQLPreparedStatementMBS.SQLSelect to not return invalid RecordSet when SQL is invalid.
  • Updated SQLAPI to version 4.3.3 beta with fixed for CubeSQL.
  • Updated SQLite to version 3.24.0.
  • Updated plugin SDK for 2018r2.
  • Added database class for documentation.

MBS Xojo Plugins 18.2 - 22nd May 2018

  • Changed AutoCache for SQL Plugin to not try to cache recordsets if there is no result set.
  • Changed cursor functions for SQL Plugin to return field count = 0 if there is no result set.
  • Fixed problem with SQLConnectionMBS.Options property crashing.
  • Updated SQLite to version 3.23.1
  • Updated to SQLAPI 4.2.2.
  • Updated to Xojo 2018r1 plugin SDK.

MBS Xojo Plugins 18.1 - 6th March 2018

  • Added Options property to SQLDatabaseMBS, SQLConnectionMBS and SQLCommandMBS to inspect options.
  • Added support for SQL Anywhere API v1 in addition to v2.
  • Changed SQLPreparedStatementMBS to accept binding with Xojo.Core.Date objects.
  • Fixed exceptions for SQL Plugin on ARM.
  • Fixed problems with connecting to SQL Anywhere database.
  • Fixed problems with using SQLDatabaseMBS object after calling close method on it. Now you can reuse it for another connection.
  • Fixed SQLDatabaseMBS and SQLConnectionMBS to close an existing connections before starting a new one.
  • Updated SQLite to version 3.22.0

MBS Xojo Plugins 18.0 - 23rd January 2018

  • Added kSQLAnywhereClient and kCubeSQLClient constants to SQLConnectionMBS class.
  • Fixed SQLConnectionMBS.ConnectMT to set SQLite encryption key.
  • Removed warning if using empty sqlite encryption key.
  • Updated SQLAPI to version 4.2.1.
  • Fixed an issue with exception handling on 64-bit Linux introduced in 17.3.

MBS Xojo Plugins 17.5 - 28th November 2017

  • Added SQLConnectionMBS.InsertRecord function.
  • Fixed bug with SQLite Prepare command with extra spaces in SQL commands.
  • Fixed issue in SQL plugin with binding parameters for ODBC.
  • Fixed issue in SQL plugin with getting text fields with FileMaker over ODBC.
  • Updated SQLite to version 3.20.1.

MBS Xojo Plugins 17.4 - 26th September 2017

  • Added MemoryUsed and MemoryHighwater properties to SQLite3MBS class.
  • Added SQL_ATTR_CURSOR_TYPE as one of the options we pass from SQL connections down to all command objects.
  • Removed SQLAnywhere plugin part as that functionality is now available in SQL Plugin.
  • Updated SQLAPI to version 4.1.12.
  • Updated SQLite to version 3.20.0.
  • Changed Linux plugins to include build number in SONAME field so OS can distinguish different versions better.
  • Updated all GTK code to dynamically load GTK+ 3 for Xojo 2017r2 and GTK+ 2 for older versions.

MBS Xojo Plugins 17.3 - 18th July 2017

  • Updated PostgreSQL to version 9.6.3.
  • Updated SQLite to 3.19.3.
  • Disabled linux version script linker option.

MBS Xojo Plugins 17.2 - 15th May 2017

  • Fixed an issue with writing BLOB fields into Firebird database via SQLPreparedStatementMBS class.
  • Fixed bug in SQLNumericMBS.NumericWithCurrency when using small negative numbers.
  • Updated PostgreSQL to version 9.6.2.
  • Updated SQLAPI to version 4.1.11.
  • Updated SQLite to 3.18.0.
  • Removed PPC code.

MBS Xojo Plugins 17.1 - 14th March 2017

MBS Xojo Plugins 17.0 - 23rd January 2017

  • Changed SQL plugin to detect ODBC to FileMaker and handle that better for reading text fields and avoid a crash.
  • Updated SQLite to 3.16.2.
  • Changed plugin file names to include name of plugin and name of part.




Links
MBS FileMaker Plugins