Release 3.5.5

Releasenotes 3.5.5

• Reworked the SQLMigrate application to be (again) able to convert an Oracle database to Firebird.
• Added a 'Slow datapump' method to the SQLMigrate program for those drivers that cannot do the tight SQLExecute loop multiple times (Firebird).
• Added a 'Save' button in SQLMigrate to save the settings before running.

Release 3.5.4

• The return type variable in the scripting documentation has been mis-named 'RESULT', instead of 'RETURN'. In this case, the documentation has been updated to reflect the correct state of the program
• NEW: The discovered user datatypes are now displayed in the ODBC object tree, under a new node "UserTypes". There are in total three different types of user types:
  o Enumerator of values
  o Domein type (datatype + constraints on that datatype)
  o Compound type: a number of columns and datatypes
  The user types have been implemented for the following RDBMS types: Firebird, Oracle, PostgreSQL and MS-SQLServer

Release 3.5.3

• When an external editor did change one of the files we are working on, the Querytool prompts
  whether we want to reload this page. This question had to be answered three times. This
  redundancy has been eliminated.
• Fix for navigating to the last lines in the query output view. When scrolling by pulling
  the vertical scroll bars with the mouse, some of the last lines in the grid where not
  accessible. This is fixed by testing for the 'last page' of results.
• The scripting statement ":if" has been expanded to be able to skip the next SQL statement,
  so that the script can decide wheter or not to execute it. See the example in the help page.

Release 3.5.2

Fixes for the MS-Access Jet databaase engine. Discovery of table and columns was broken
Fixes for opnening a extra line in the editor by going a line down. Inserting of spaces
before the text was essentially broken. This makes editting queries a lot better experience.
Fixes for table discovery of a named table in Firebird.

Release 3.5.1

Various fixes for the discovery of databases with quoted identifiers. (Firebird, MariaDB, Oracle, SQL-Server, PostgreSQL). For most ODBC drivers only the SQLTables and SQLColumns work correctly. Other functions such as the discovery of SQLPrimaryKeys, SQLForeignKeys, SQLStatistics, SQLProcedures do not work for case senstive identifiers.

Also various fixes for the Info tree, so that we can now see the compelete view, trigger, function and stored procedure source.

Release 3.5.0

Quoted identifiers have been added to the system. OpenODBCQuerytool now understands the
identifiers (tablenames, viewnames, columns, indexes and such) that are stored in mixed
case format. So "FullName" and "Fullname" are different identifiers.
As a standard rule, all identifiers in one (1) case are understood to be non-quoted identifiers.
These will not be quoted, and standard nameing rules apply.
Per supported database platform the naming conventions are applied, beginning with Firebird.
Stay tuned for next service packs for other RDBMS'es that have case sensitive catalogs.
By default lMS-SQLServer and PostgreSQL can handel mixed cases. These work now out-of-the-box.
Orace, Informix, MySQL and MariaDB need extra work in their respective InfoDB classes.

Release 3.4.5

• Fix for querying decimal number fields after a CLOB/BLOB column
• Performance fix for retrieving columns after the last bound column
• Unicode and SQLDate fixes
• Fix for Firbird databases in getting procedures and procedure-parameters
• Fix for PostgreSQL databases in getting procedures and procedure-parameters
• For PostgreSQL databases it is now also possible to retrieve the procedure/function source text

Release 3.4.4

1. ODBCQueryTool now supports Oracle packages and can discover procedures and functions within packages and can retrieve the package sourcecode (if not wrapped)
2. A small bugfix for discovering procedures in the Firebird 3.x databases.

Release 3.4.3

1. The scripting :if command now has multiple operators: '=', '<>', '<', '>', '<=', '>='
2. The value of a variable can now be printed in the :print command to the output file
3. A variable can be assigned the value of another variable with ":variable = variable;"
4. Fixed a bug in the variables dialog (See menu: Script/Variables)

Release 3.4.2

Updated the libraries to the latest version. After a half year of testing: fixing a lot of small Unicode bugs.
Added the 'mustard' (yelow) and 'dark' themes
Fixed a bug in the object-discovery of the Firebird drivers. Columns of tables and procedure arguments are working again
Fixed a bug in the installer. Check on 'not-yet-installed' added