Version 3.0 (R14) Database Toolbox Software

This table summarizes what's new in Version 3.0 (R14):

New Features and ChangesVersion Compatibility ConsiderationsFixed Bugs and Known ProblemsRelated Documentation at Web Site
Yes
Details below
Yes–Details labeled as Compatibility Considerations, below. See also Summary.Fixed bugsNo

New features and changes follow.

New Data Types Supported

This toolbox software now supports Sun™ Java BINARY (BLOB or Binary Large Objects) and OTHER data types, such as bitmap images and MAT-files. For more information about using these data types in the Visual Query Builder or with functions, see Retrieving BINARY or OTHER Sun Java SQL Data Types in the Database Toolbox documentation.

Export Using Visual Query Builder (VQB)

You now can use the VQB to export data from the MATLAB workspace, and insert it into new rows in a database. For more information, see Exporting Data from the MATLAB Workspace to a New Record in a Database in the Database Toolbox documentation.

Display Menu in VQB Now Works for Structure and Numeric Formats

You now can use Display menu items in the VQB with structure and numeric formats for retrieved data as specified in Preferences or with setdbprefs. In previous releases, you could use Display menu items only for the cell array format.

Spaces in VQB Tables and Fields Now Allowed

You now can use the VQB for tables and fields that contain spaces in their names. They appear inside quotation marks in the VQB lists.

Open Data from VQB into Array Editor

When you double-click a variable in the Data field of the VQB, it now opens in the Array Editor. In previous versions, the contents displayed in the Command Window. You still can display the contents in the Command Window by typing the variable name in the Command Window.

VQB Query Execute Updates Statement

In the VQB, when you edit the SQL statement field, the query represented by the other fields does not match what is in the SQL statement field. When you then select Query > Save, it saves exactly that mismatch. When you then load that saved query, you again see the mismatch. When you execute it, it updates, theSQL statement field to match the values in the other fields for that query.

Compatibility Considerations

This represents a change from previous versions in which the SQL statement field updated to reflect the values in the other fields when you loaded the query, rather than when you executed it.

Database Toolbox Functions Compilable

Because of changes made to the MATLAB Compiler, you can compile Database Toolbox functions to create stand-alone applications that do not require the MATLAB software.

logintimeout not Supported on Linux Platforms

On Linux platforms, logintimeout is not supported.

BOOLEAN Data Types Now Represented as 1's and 0's

Previously, if you retrieved a BOOLEAN field from a database using fetch, the values were returned as true or false strings. Now they are returned as 1's and 0's, and are of the MATLAB logical data type. For more information, see Importing BOOLEAN Data from Databases to the MATLAB Workspace in the Database Toolbox documentation, and the fetch and insert function reference pages.

Compatibility Considerations

If you have M-files that rely upon the string values for data being true or false, you need to modify your code to use 1 and 0 instead.

  


 © 1984-2008- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS