Changes in RemObjects Data Abstract Schema Modeler 7 for Windows

This document lists the changes introduced by new versions of chema Modeler 7, included in Data Abstract for .NET, Cocoa, Java, Delphi and JavaScript.

   

New in the “May 2019” Release, Version 9.7.115 (Build .1441)

(Built: May 29, 2019)

Enhancements

• 82095: DASM: Simplify the way used to pass .relativityClient and .remoteSchema files as command-line arguments

 

New in the “March 2019” Release, Version 9.6.113 (Build .1413)

(Built: March 20, 2019)

Fixes

• 81592: SQL Statement is empty warning is triggered for a wrong Schema Table
• 81675: Statement Editor marks string constant elements as parameters

 

New in the “November 2018” Release, Version 9.5.111 (Build .1397)

(Built: November 16, 2018)

Fixes

• 80594: App crashes if metadata request for Schema Table returns null
• 81111: Fix for the Decimal type settings GUI
• 81068: New Schema Wizard crashes if data table structure cannot be retrieved
• 81379: NexusDB driver causes some problems with Schema Modeler
• 80944: Statement View doesn't display SQL statement for commands
• 80370: Use StoredProcedure statement type for tables defined based on StoredProcedure data source
• Elements v10 compatibility fix

 

New in the “July 2018” Update Release, Version 9.4.109 (Build .1375)

(Built: July 6, 2018)

Fixes

• 80265: Connections are being checked in the main thread
• 80310: Crash when an Update Command is created for a Schema Table containing less fields than the corresponding database table
• 80294: Provide better error reporting if a Table metadata cannot be obtained from the database
• 80322: Provide more consistent API for the connection test method
• 80321: UnhandledExceptionReport dialog prints exception stacktace into an editable text editor
• Split IConnectionInformationProvider.pas into separate files
• SQL Generator code cleanup

 

New in the “March 2018” Update Release, Version 9.4.107 (Build .1363)

(Built: March 23, 2018)

Fixes

• 79631: Cannot obtain metadata for Schema Table with Statement defined as a Stored Procedure
• 79525: Cannot validate Schema Table SQL statement with parameters defined
• 78892: Connection editor crash when testing not yet defined connection
• 79472: Connection editor loses parameter named 'Schemas'
• 79474: Connection Wizard - Avoid resetting database name field after changing driver
• 79530: Modeler doesn't save changes made to Relativity Domain schema opened via .relativityClient file
• 78893: Show error message in Unhandled exception window

 

New in the “October 2017” Release, Version 9.3.105 (Build .1337)

(Built: October 17, 2017)

Fixes

• 76524: Bugs in Schema Table relationship management
• 77688: Connection Editor is very slow for Oracle Connection
• 78087: Do not reset database name after changing aux driver
• 77955: On data preview statement parameter values aren't applied properly to connections with sequential parameter value binding
• 78544: Schema Command loses parameter value for XML parameters sent as plain string value
• 77967: Statement Validator extracts parameter name from a DB object identifier like "COMPOSITE@NAME" 

New in the “July 2017” Release, Version 9.2.103 (Build .1311)

(Built: July 11, 2017)

Fixes

• 78068: Schema Modeler cannot connect to Relativity Server if its AES password doesn't math the one previously saved
• 77757: Schema Modeler: SQL editor loses changes made in the SQL statement

 

New in the “April 2017” Release, Version 9.2.101 (Build .1295)

(Built: April 13, 2017)

Fixes

• 76833: AES password for custom server connection is stored as plain text
• 76835: Auto-set the 'Remember me' flag for connections loaded from file (either Relativity Client File or custom server connection file)
• 76898: Cannot connect to a SSL-protected DA server
• 76899: Crash while connecting to an AES-protected Relativity server
• 76823: It is not possible to pass the Relativity Server URL as command parameter
• 76822: Login dialog refactoring
• 76903: Possible deadlock in the Relativity Server connection code
• 76837: Race Condition when Schema Modeler connects to Relativity Server
• 76574: Redesign the Server Login (for both Custom Servers and Relativity Server) process management
• 76910: Refactoring of the Remote Server (both custom and Relativity) server connection code
• 76900: Relativity AdminTool cannot start the SM instance
• 76573: Schema modeler cannot access AES-protected Relativity Server
• 76901: Should be able to connect to any server channel type (currently only Http is supported)
• 76971: Wrong field mappings are created for tables based on static SQL statements with JOIN clauses

 

New in the “November 2016” Release, Version 9.1.99 (Build .1273)

(Built: November 1, 2016)

Enhancements

• 76097: Update New Schema Wizard UI to new styles used by the New Project Wizard

Fixes

• 76088: Break the dependency between RO.DA.IDE.Wizard and Schema Modeler core
• 75945: Correct the doc url in the About dialog
• 75949: Existing parameter lengths are cleared when the parameter list is updated
• 76146: Internal code cleanup
• 76201: Owner window was not set for the New Schema wizard dialogs
• 75824: Recreated parameters order doesn't match the SQL statement
• 76198: Refactor the Wizard code to make it more manageable
• 75242: Refresh Relationships
• 76169: Remove duplicated Service Locator code
• 75905: Schema is not marked as modified when text is pasted into the statement editor
• 75688: Schema Modeler crashes with NRE on dragging table from the DB connection
• 75090: Schema Modeler should force user to rename tables with incorrect symbols in their names once they are dragged into the tables list
• 75944: Sorting parameters in the preview pane throws cast exceptions
• 75698: Unwrap TargetInvokationExceptions in Schema Modeler exception reporting
• 76453: Update obsolete Wiki links
• 76203: Update Relativity interface files to get rid of numerous warnings

 

New in the “May 2016” Release, Version 9.0.97 (Build .1245)

(Built: May 2, 2016)

No changes for Schema Modeler, in this release

 

New in the “March 2016” Release, Version 9.0.95 (Build .1233)

(Built: March 25, 2016)

• 74571: Exception on attempt to copy info to clipboard
• 74501: Schema Modeler throws NRE when one tries to preview a StoredProcedure-based table
• 74275: DASM should show drivers only for installed platforms
• 73922: Mapping isn't updated after recreating fields
• 73920: Union mapping isn't saved into .daschema
• 73918: AuxDrivers are missed for delphi drivers
• 73669: DASM crashes when it tries to save a .daConnections file
• 73656: Switch to the new metadata access API for the "Data Preview" and "Redefine Fields" operations
• 73647: Oracle Cursor data type support - DASM: Placeholder for a future Oracle RefCursor support
• 72007: Schema Modeler data table preview tries to load fields that aren't present in the Schema
• 71721: DASM raises System.FormatException
• 71177: DASM resets connection manager properties
• 70322: Bug with Log Changes checkbox
• 67070: When openinf .relativityClient, "remember me" checkbox is disabled

 

New in the "May 2015" Release, Version 8.3.91 (Build .1167)

(Status: May 26, 2015)

No changes for DASM, in this release

 

New in the "March 2015" Release, Version 8.2.89 (Build .1153)

(Status: March 2, 2015)

Fixes

• 71182: Schema Modeler connection problem
• 71134: Schema Modeler can't save edits
• 70623: Schema Modeler crashes when table field properties are open
• 70817: Don't add parameters of result type to schema parameters for stored procedure
• 70816: Combobox with stored procedures did not show

 

New in the "September 2014" Update Release, Version 8.1.85 (Build .1143)

(Status: September 25, 2014)

Fixes

• 69541: DA SQL Browser tool offers jsonStreamer by default while must use Bin2Streamer
• 69415: Preview for parametrized SQL returns no data
• 69096: DASM eliminate using System.Web.dll which is absent in .NET4 (client profile)
• 68882: Add support for session-value macros

 

New in the "Summer 2014" Update Release, Version 8.0.81 (Build .1131)

(Status: June 24, 2014)

Features

• 64402: Allow launching of Schema Modeler from Relativity Server Web Admin
• 67962: Dialog to create AWS config file for Relativity Server in the Cloud

Fixes

• 67489: No items in the connection manager after schema wizard
• 63960: Confusing error message (updated message string)

 

New in the "Spring 2014" Update Release, Version 7.0.75 (Build .1117)

(Status: March 28, 2014)

Fixes

• 67173: When opening .relativityClient file, Schema name is ignored
• 67070: When open .relativityClient "remember me" checkbox is disabled
• 67036: Doesn't show preview for some schema tables (or connections?)
• 66946: Access violation when trying to preview sqlite table
• 66906: When run with "/readonly", still allows to make changes
• 66142: Implement registration of relativity:// protocol

 

New in the "Winter 2013" Release, Version 7.0.73 (Build .1111)

(Status: December 13, 2013)

Fixes

• 65409: Writes schema to .relativityClient
• 64632: Schema windows is empty in the latest stable (testing purposes)
• 64626: Update Fields caused Doubles Field Maps?
• 64162: add possibility to [auto]refresh parameters for commands
• 64140: onValidateCommandAccess event should return true by default
• 64138: Enable possibility recreate parameters from SQL
• 63960: Confusing error message
• 63835: Generator name field for command view should be hidden
• 63834: Generator name should be enabled only for Autoinc params
• 63815: Problem with unused parameters in stSQL mode
• 63805: Wrong parameter type is set for parameters referring to table fields of type AutoInc
• 63779: Fill TargetTable for auto-generated delta command
• 63740: GUI should allow to change order of UpdateRules via drag&drop
• 63663: About Box: Make minor tweaks
• 63434: Parse parameters types for fields like TableName.FieldName
• 61856: Add reordering fields as in old SchemaModeler
• 60215: Documents that fails on loading should not be opened
• 59670: Create nicer dialog for unhandled exception
• 59013: Reveal in Explorer command should work for *.relatvityClient & *.daRemoteSchema
• 58989: Connection String wizard should not be opened on Internal connections

 

New in the "Fall 2013" Release, Version 7.0.71 (Build .1093)

(Status: September 10, 2013)

Fixes

• 63776: Auto-generation of delta command is broken
• 63704: Exception on attempt to Recreate Paremeters from Command Collection view
• 63600: Need to initialize ConnDef for statement not only after statement view is loaded
• 63435: Implement "Recreate Parameters" button
• 63432: No metadata after updating SQL
• 63371: Leave fields names as-is during Update Fields
• 63255: Change Connection for the statement after Drag & Drop
• 63233: List of Generators is empty
• 62535: Show 'Copy/Paste' context menu for all editor areas (f.e. script editor and SQL editor)
• 61754: Set target table when dropping DB table onto the statement view
• 61752: Wrong SQL generated on drag&drop stored procedure onto statement
• 61751: Generated SQL is not set as model property when drag & dropping DB table to statement
• 61258: Add About dialog
• 59012: Persistence of Recent file list and windows size and position

 

New in the "Summer 2013" Release, Version 7.0.69 (Build .10781)

(Status: May 31, 2012, Revision master-fd904d8)

Fixes

• 62495: Running SM from commandline without admin rights with /register argument throws an unhandled exception
• 62494: .daRelativityClient schema and connections are not saved from VS IDE
• 62473: Unions - adding new source table fails when all the data tables have been added already
• 62450: Failed to open .daRemoteSchema of server protected with AES password without login service
• 62419: Unable load huge schemas (>8MB) from Relativity and custom DA servers
• 62083: Return back Value property for Parameter view
• 61981: Add check for driver initialization
• 61834: Metadata does not loads for statements based on views
• 61796: Need to Update instead of Recreate fields after statement SQL was changed
• 61793: Changes in statement SQL does not set for model when perform File-Save just after change.
• 61760: Wrong positioning Schema window when open RemoteSchema files
• 61757: Connections dialog shown before refresh relations even in case of one connection
• 61755: Order of connection definition content was changed
• 61753: Wrong focus logic in the Schema document tree
• 61617: Connection Definition dialog overwrites existing connection name
• 61530: .relatvityClient: App stays in memory after closing
• 61439: Show field for entering RelativityClient password only when it required
• 61308: Need to allow manually editing database field in mappings
• 61276: Delete Delta-command for data table generate parameter without OLD_ prefix
• 61248: Failure on renaming schema tables.
• 61247: Failure on renaming connection.
• 61187: Add ability to discard changes made inside document
• 60942: Improve error message when tring to obtain metadata without Target table and SQL
• 60154: Allow to navigate to tree items without losing focus in its editor
• 59538: After deleting field, parameter or statement from table view it is changed
• 58986: Connections manager: Sort connection definitions alphabetically
• 58282: GeneratorName should be as combobox with prefilled generators (fields)
• 58278: ConnectionManager: Remove error hint after successful operation
• 58126: The document should be in recent if saved first time after creating
• 57822: StatementView: Implement regenerating fields for stStoredProcedure statements
• 52578: stStoredProcedure should show recordset in preview pane for DataTable statements.

 

New in the "Spring 2013" Release, Version 7.0.67 (Build .1073)

(Status: March 5, 2012, Revision master-5a9d861)

Fixes:

• 61175: Problem with dbx driver
• 61095: NRE if try to drag SP to Tables
• 61042: Internal connection gives "Unknown driver Internal"
• 61041: Connection manager. Refresh of collection fails
• 61040: Union Source Table view. Source table combo is not sorted.
• 61039: StatementView. Target table change not saving
• 61032: If server requires login - unable to press Cancel
• 61031: Extra message before choosing statement on Recreate/Update fields
• 60900: Offer to remove reference to non-existing file in the recent files list
• 60898: DASM fails badly when opening .remoteSchema and it can't find service
• 60894: Unable to open .relativityClient file
• 60882: Commands for tables are creted with validation errors
• 60880: Unable to remove first command on Command collection view
• 60826: Unhandled exception on opening new schema wizard
• 60825: Unhandled exception on creating new connection
• 60812: Random crashes on expanding tables in the connection manager
• 60748: Cannot obtain metadata for IBX stored procedures
• 60735: Unmanaged ADO driver returns wrong relationships
• 60734: MainFormViewModel.SaveAll looks over-complicated, need to refactor.
• 60733: Add "Save All" command to connection manager window
• 60732: Sometimes "Recreate fields" action does not work
• 60731: Save All shortcut does not work
• 60683: Sometimes SQL tab disabled even when state is stSQL
• 60669: Add method for getting metadata from parametrized SQL
• 60623: Unmanaged Driver: Add method for getting matadata from parametrized SQL
• 60598: Cannot obtain metadata for parametrized SQL for AnyDAC
• 60596: Improve extracting parameters from stSQL
• 60371: Drag and Drop fails on attempt to drag items with different types
• 60368: TableViewModel.FindStatementForConnection can return wrong statement
• 60314: Unable to recreate or update fields if corresponding statement was not loaded
• 60248: Create New Item combobox item only when nessesary
• 60246: Error creating Delta-commands
• 60018: Unmanaged Driver: Change LazyLoading aux drivers implementation
• 60015: Implement Lazy Loading pattern for getting auxiliary drivers
• 60013: Use threadpool for all async operation in the ConectionDefinition
• 59911: Unmanaged driver: Implement getting sub-driver infos
• 59903: After refactoring. Add Boolean result to Recteate/Update fields/mapping methods
• 59882: After refactoring. Broken connection hangs on 'Loading...'
• 59880: After refactoring. Preview for parametrized queries fails
• 59879: After refactoring. Validation does not work for statement
• 59878: After refactoring. No metadata - but recreate fields command also asks to recreate mapping
• 59877: After refactoring. Metadata was loaded, but can't be found
• 59875: Clear metadata cache on any change in ConnectionString
• 59854: Error recreating fields
• 59842: Cannot recreate fields from fields view for stSQL tables
• 59839: DidLoadView calling several times
• 59830: Cannot obtain metadata for non-parametric tables for Delphi Oracle driver
• 59814: StatementViewModel. Implement caching metadata. 58648: Refactor StatementViewModel. Make async calls more clear
• 59794: Make validation imported object name Case-Sensetive
• 59783: Managed driver. Read SPExecuteWithoutParams information
• 59782: Unmanaged driver. Read SPExecuteWithoutParams information
• 59779: Incorect SP EXEC SQL command generates for Firebird connections
• 59673: Create new project if New Schema Wizard was cancelled
• 59478: Add views to the TargetTable dropdown list
• 59010: Add ability to create delta command directly from the table view
• 58975: Should show only one save dialog when closing
• 58956: Add Content section to the CommandView
• 58648: Refactor StatementViewModel. Make async calls more clear
• 54094: Implement Refresh relations on the relations collection view
• 54093: Create relations automatically when dragging several related tables from connection manager
• 53993: Offer to create new relation when dropping one schema table to another

 

New in the "Winter 2012" Release, Version 7.0.65 (Build .1065)

(Status: November 30, 2012, Revision master-1925959)

Fixes

• 59673: Create new project if New Schema Wizard was cancelled
• 59669: Sometimes it fails to recreate parameters with proper data type
• 59613: Unmanaged driver: GetDbSQLDataWithParam should not fail when SQL doesn't have parameters
• 59601: Crash on adding SQL parameter under unmanaged Oracle driver
• 59591: After adding field to table it is shown in tree twice.
• 59537: after restart of MS SQL server, connection manager can't reconnect
• 59487: New schema wizard query overwrites existent schema.
• 59472: Failure when dragging and dropping non-expanded table from Connection Manager to the Statement SQL
• 59469: Add several missing properties to the FieldView
• 59423: Update columns mapping failed after deleting one mapping.
• 59418: Crash when opening of empty .daConnections or .relativityClient
• 59320: Fails on connection change (if SQL is empty)
• 59260: Recreate field silently doesn't work if metadata wasn't obtained (empty name of statement)
• 59252: Cannot open AES encrypted daRemoteSchema files
• 59248: Update Fields implementation should be the same as in old DASM
• 59240: Application fails on creating delta commands from table with broken mappings
• 59228: Master/Detail relationships are ignored in Schema Modeler Wizard
• 59224: Disable New Schema Wizard for remote schema project
• 59223: New Schema Wizard. Statements are created without name
• 59169: Statement. Tables list is not updated after Connection change
• 59132: Changes in schema fields of the table should be automaticaly reflected in mappings
• 59130: If Connections window is hidden, it doesn't appear by command
• 59117: ConnectionStringBuilder wizard need to use .NET drivers only for RelativityClient projects
• 59115: Implement Test Connection for Relativity managed schemas
• 59113: Generates wrong automatic mappings.
• 59112: Try to pick up corresponding fields by index in automatic mappings regeneration.
• 59109: Schema Modeler doesn't save the Field Mappings on the first try.
• 59097: Cannot load just created connection definitions in the RelativityClient project
• 59045: daRemoteSchema fails opening on non-protected DASampleService service
• 59044: Login dialog asks for AES password even when DA service is not encrypted
• 59042: NRE on opening RelativityClient project
• 59014: Select created delta commands for table after Drag&Drop it to commands
• 59011: Open daConnections files from Explorer by double-click.
• 59007: Open Schema filter should contain .daRemoteSchema & .relatvityClient too
• 59006: Changing connection should lead to changin ConnectionType as well
• 58988: Connection Manager. Wrong menu name View->Refresh Connection Definition
• 58985: Change logic of auto-generation Connection Definition Name to make name shorter
• 58979: Failure on loading RelativityClient files with Zeroconf name only
• 58978: Login dialog asks for AES password even when Relativity is not encrypted
• 58951: Add Content section to the TableView
• 58951: Add table Children content on Table View
• 58950: Add GetParent method implementation for Collection View models
• 58914: Modified flag is half-hidden when name of the schema file is long
• 58912: Move field Size to DataType value - in parenthesis (field collection)
• 58910: Do not shows empty schema document if open only .daConnections file.
• 58872: AvalonEdit controls in application (JS/SQL) should use monospaced font
• 58869: UnmanagedDriver: Implement LoadDriverByName method
• 58868: UnmanagedDriver: Implement GetAvailableDriverNames method
• 58867: Add ability to specify empty value for Table Field mapping.
• 58865: Wrong ConnectionType validation
• 58844: Redesign Field view to put more controls there
• 58796: Add DisplayFormat property for float fields
• 58771: Refactor StatementViewModel.CreateDefaultStatementForTable. Wrong signature?
• 58767: Remove Controls.NumericTextBox control since it doesn't use anymore
• 58765: Implement lazy loading of the metadata for database items.
• 58764: Turn off caching of the driver info
• 58763: Improve perfomance of the unmanaged driver by implementing lazy loading its info
• 58762: Load driver information only when it is necessary
• 58761: Connection Driver: Add method for obtaining all information for given driver
• 58760: Connection Driver: Add method returning just names of the available drivers
• 58731: DASM fails with exception on Update Fields, when metadata could not be loaded
• 58725: Statement Collection can have several default statements
• 58724: Statement Collection View doesn't display Connection Type and Default properties
• 58712: Highlight read-only fields in FieldsCollectionView & TreeView
• 58711: FieldsCollectionView: Replace LogChanges text true/false with checkbox
• 58710: FieldsCollectionView: Add Size, Scale & Precision fields
• 58709: FieldsCollectionView: Remove some columns and reorder them
• 58661: Add ability to specify AES password for encrypted services
• 58653: DA changes field/parameter type from String to Memo when it size is 0 or -1
• 58632: Cannot perform preview and generate SQL for tables from Internal connection
• 58428: Hide Validate button for command statement
• 58279: blobtype isn't shown for fields
• 58270: Make Custom Attributes property multiline
• 58210: Change the way of SQL Validation
• 58194: Store password in separate file (*.relativityClient.user)
• 58166: Switch license validation to Everwood.Live
• 58142: /autosave command line parameter doesn't work
• 58141: NRE in ConnectionManagerDocument.ConnectionDefinitionViewModelByType
• 58139: NRE inside StatementCollectionViewModel.GetConnectionTypeForNewStatement
• 58125: Add new menu item 'Save Project' to store Schema and Connections together.
• 57944: Improve positioning of the ConnectionStringBuilder
• 54869: For Table Statement show connection types used in the current Schema
• 54103: Implement unified quick data preview
• 54103: Implement unified quick data preview (Schema Table)
• 52491: Need to specify exact statement from several available for updating & recreating fields

 

New in the "Fall 2012" Release, Version 7.0.63 (Build .1055)

(Status: October 5, 2012, Revision master-cbdb472)

This is the initial release of the new Schema Modeler 7 for Windows