New Features

• New INM VizionDB Editor offers the most intuitive workflow for creating databases and massaging data:
  • Create new VizionDB databases from scratch, from template, or from existing databases
  • Convert directly from MS Access, MySQL, V12 Database and Valentina formats
  • Import table data from text files and XML-formatted files
  • Automatic data validation mode highlights values that do not conform to field definitions
  • Add and edit data in an Excel-style data sheet
  • View subsets of records through filters and queries
  • Modify the database structure at any time
  • Add relationships between tables
• Database and Recordset objects are represented by Director cast members (as in asset Xtras), with dialog boxes to access their properties
• The INM SnapGUI™ technology tightly integrates Behaviors, UI components and events triggered by the database, to provide a rich and powerful development environment that you can use without having to code or even know Lingo
• Includes support for SQL, as well as the traditional V12-style Lingo API
• Supports complex Boolean queries with multiple criteria
• The powerful and robust Firebird database engine forms the core of the Xtra

Bug Fixes

• Converting from MS Access, V12 and Valentina databases - memory management issues have been resolved and the speed of database conversion is increased. Also, more precise feedback is displayed in the log window during conversion
• A limit of 23 characters has been identified for INM VizionDB table names; field names and index names are limited to 31 characters
• When converting databases with table and field names that are too long, or contain invalid characters, the invalid names are now changed automatically by the INM VizionDB Editor and appropriate messages are displayed, stating the old name and the one that has been substituted
• In the INM VizionDB Editor, when adding or editing records that are in a Relationship, if the value entered would violate the relationship, an error message is displayed
• When using the INM SnapGUI Behaviors, there was an issue that prevented Adding, Updating or Deleting records from a Recordset that was "filtered". [fixed]

Known Issues

• With INM VizionDB databases that are delivered for cross-platform (Windows and Mac)
  projects, if your table contains LongVarchar or Media fields, you can only modify that table's records on the platform on which the database was initially created. If you attempt to modify the values of those records on the other platform, it will corrupt the database.
  There is no problem if you only need to read data from the database and there are no problems modifying tables that do not contain LongVarchar or Media fields. We expect to resolve this issue shortly
• In the Query Designer of the INM VizionDB Editor, you cannot specify a query containing more than two related tables. You will not get the correct result. You can, however, specify a SELECT query with more than two related tables in Director, inside the Recordset member properties dialog or using the SQLSelect() method
• Searching for text that contains a quote character will fail.
  (example: SELECT * FROM EMPLOYEES WHERE Last_Name = 'O''Malley')

Additional Notes

• The Desktop version of INM VizionDB does not support Shockwave (web) delivery or database access over a LAN. This version is for single-user database access, from CD-ROM, Kiosk, or applications installed to the user's hard drive
• When using the INM VizionDB Behaviors (INM SnapGUI™) with Flash-based components, you will get better performance if you use the Macromedia Flash 8 Asset Xtra, released in March 2006