Skip to content

Development Tool Build Notes - 19.0

Build 19.0.3.0

  • The three CLI conversion wizards are merged into a single CLI convert wizard, which can be called from DBB or directly from the Studio.
  • The database menu in DBB has been simplified so that there are no more automatic menu items appearing at the top of the menu based on your default database.

Build 19.0.2

  • Better support for long field names in the “Print File Definition” report.
  • Some improvements to the “Check Relationships” report:
  • Removed FROM table name as this is a value already in the header of each group.
  • Changed the margin to 1 1 1 1.
  • Moved the FROM and TO columns a bit to make space.

Build 19.0.33

  • Fixed the problem that the current index bitmap in the filelist wasn't updated when you click a column in the grid that is indexed.
  • Fixed a problem that changing the filter value for the 2nd or more filter updated the value of the 1st filter.

Build 19.0.32

  • Problem fixed when 'open related-to tables' is selected and the related table is not in the filelist (caused error 74), should not cause this undetected error.
  • Problem fixed when 'field tab-page' builds the relation column when the related-to tables are not present in the filelist or not there at all. Error should not be given and table indication was incorrectly displayed.

Build 19.0.31

  • Insert separator lines between save and delete button (see discussion at Data Access Forums) and BT 6792: Save and Delete Icons are too close to each other.

Build 19.0.30

  • Added a floating menu to the filters grid which can pop up when there are no filters defined.
  • Fixed a bug in the filters grid that caused the explanation grid style to not appear.
  • Removed two false GetSystemMetrics() instructions from the Imagelist objects.

Build 19.0.29

  • In modify connection MSSQLDRV group, the test connection button now first attempts to login to the server and produces a clearer status message in modify connection when login to the server fails. If the server login is successful, it tests if the database can be reached and if not, produces a better status message.
  • The status line of the main panel shows login attempt status information when loading managed connection information; previously, there was only a spinning hourglass cursor to indicate something happened. It turned out that if you cannot login, it takes quite some time before a login dialog appears.
  • The index information for the filelist has been extended with index number (as in the Studio).

Build 19.0.28

  • New icons for selected vs non-selected table column entries in the filelist.

Build 19.0.27

  • Fixed three places where a bad file number could occur.

Build 19.0.26

  • Fixed a problem in the connection manager reported by Chris Spencer.

Build 19.0.25

  • Fixed a problem around field_map.
  • Fixed a should_save error when opening the database pull-down while no tables are opened.

Build 19.0.24

  • Fixed an error reported when invoking sort list of tables. Reported by Marco Kuipers.
  • Implemented a suggestion from the forum.
  • Fixed a problem with parent table data display in the columns grid tab-page. It duplicated the number of columns in the grid.

Build 19.0.23

  • Made the connection IDs configuration dialog resizable. It did not work correctly in the past but has been fixed.

Build 19.0.22

  • An icon appeared in the status bar when the table that was just opened contains more columns than configured in the Miscellaneous tab-page of the configuration dialog. This feature is now extended with:
  • Clicking the icon in the status bar opens the configuration dialog with the Miscellaneous tab-page shown, only when dbAdminMode is not OFF.
  • Opens a modal dialog explaining what is happening. The modal dialog contains a checkbox to suppress this message box in the future. The explanation text contains a hyperlink to the configuration dialog (same action as 1).
  • The configuration dialog contains a new checkbox (next to the max columns setting spin form) to disable the modal dialog as mentioned under 2.
  • Removed cursor_wait / cursor_ready operations. Did not work correctly with message boxes.

Build 19.0.21

  • Made resizing of the connection IDs dialog impossible by setting piMaxSize / piMinSize.
  • Disabled the option to open the connection IDs dialog if changes are present in the data controls.
  • The Connection IDs dialog can only be opened if dbAdminMode is ON or DDB.
  • The export data file menu option can be hidden with a configuration flag. The default for the option is based on dbAdminMode.

Build 19.0.20

  • Index name query in indexes tab-page only when configuration option to query index names is true.
  • Exclude table names gave an error when all tables were added to the excluded or included list.

Build 19.0.19

  • Fix for default width form objects.

Build 19.0.18

  • Removed resizing feature of manage connections dialog.

Build 19.0.17

  • Extended index tab-page with clustered index, index name, and backend information.
  • Merged Studio's ModifyConnections.dg code regarding DB2.

Build 19.0.16

  • Fields grid extended with native column type name column, hidden when not one of the CLI drivers is used.
  • Fields grid auto column sizing disabled, columns with new fixed width.
  • Fields grid restore layout added.
  • Fields grid current text color fix.
  • DDO Filters grid restore layout added.
  • DDO Filters grid auto column sizing disabled, columns with new fixed width.
  • DDO Filters grid checkbox columns with centered label.
  • DDO Filters grid header now 2 rows high.
  • DDO Filters grid current text color fix.
  • Index page checkbox columns header now centered.
  • Bold, Italic, and no tables icon renewed.
  • Size logic for fields & DDO tab-page corrected.
  • Added anchoring for some of the table attribute boxes.

Build 19.0.15

  • The current filters grid did not show a context menu when empty. A right mouse click on the header showed a useless default floating menu. This is now changed, and a right mouse click on the header gives the same floating menu available if one or more rows are present in the grid.

Build 19.0.14

  • New icon for no tables in the filelist.

Build 19.0.13

  • Text color in data grid changed; there was/is a difference between the color in the DBE’s grid class and the color configuration options.
  • Save button (and delete) were not directly showing the right status.
  • Found and fixed a problem when answering “NO” on save confirmation in the data grid. If you answered NO, you got an assertion error. This was a DBE only issue as the confirm question offers YES, NO, and CANCEL. The fix changes the behavior between older versions so that NO does not move to a different row. In the old case, it re-found the record in the table and moved to a different row; the new behavior is to re-find the row in the table and stay on the same grid row.
  • Updated an icon and PNG.

Build 19.0.12

  • Replaced Italic16.ico for Italic.ico scalable.

Build 19.0.11

  • New icons.
  • Removed show field and index attributes options from floating menus. Not needed anymore and caused CJ errors.
  • Removed CJ DPI scaling option added in 19.0.9. Caused blurred icons.

Build 19.0.10

  • New icons.

Build 19.0.9

  • New icons.
  • Added DPIScalingOptions setting in command bars.
  • Removed ShowFieldAttributes menu item from Fields Floating menu. Gave errors when the table was not open; similar options (for indexes etc.) were not there, and a user can click the attributes tab-page.
  • Moved the Tips dialog button from tool-bar to help pull-down.
  • Closed tables when opening managed connections dialog.
  • Changes in DB2 and ODBC connection strings.
  • Removed the option "Show Column Attributes" from "Columns floating menu" in the list of tables.

Build 19.0.6

  • Default value for text color was incorrect; needed to be clWindowText instead of clWindow.
  • Removed TODOs.
  • Only set the psMask of DF_ASCII and DF_TEXT grid columns if the OemTranslateState is set to false.

Build 19.0.5

  • The data grid now uses the CodeJock cDbCJgrid class instead of the dbGrid class.
  • The list/grid with filters on the DDO Tree tab-page now uses the cCJGrid class instead of a Grid class.
  • Editing of a new filter is now easier; it does not require a popup dialog:
  • The edit filter option from the floating menu in the DDO Tree tab-page was removed.
  • Adding a filter does not open a define filter dialog but "just" adds a new line to the grid.
  • The number of filtered rows displayed in the status bar is now auto-sizing to its contents; other status bar panes are auto-sizing too.
  • The tool-bar buttons for sorting the data are now always visible. The action will be disabled if it cannot be chosen. Had to be done to get the CJ grid working.
  • Fixed painting bug in status line when displaying an error text like "find prior to beginning of data". The text color changed from red to default but added an icon to indicate there is a message to read.
  • The grid on the columns tab-page is now a cCJGrid object. Removed the floating menu. Removed the dialog to select what columns you want to see (it is now making columns visible in the CJ way). Removed the option to turn on/off column resizing; it is now always turned on.
  • The attributes tab-page contains a scrolling container so that you don't have to resize the main dialog to see some of the attributes; it now scrolls.
  • The indexes tab-page grid is now a CJ grid and contains a splitter container.
  • The in/exclude tables dialog now uses CJ grids and a splitter container. The buttons between the two grids have been replaced with a tool-bar with icons.
  • Use of the same visual theme as DataFlex Studio.
  • Many (not all yet) icons are now scalable.
  • Removed the sort up/down tool-bar buttons as it can now be done in the data-grid headers.
  • Made changes to the single record view mode to create a good-looking layout when using on higher DPI monitors.
  • Improved the managed connection logic added in 19.0.4.
  • Added more color preferences for grid colors. Import of old color references renames the old names.
  • Added new configuration option named "multi line" to be used with text columns in the CJ grids.
  • Removed Add/Remove Row MenuItem in record pull-down. Logic not supported in CJ grids.

Build 19.0.4

  • Implemented managed connections. The way it works is as follows: When you load a workspace and DfConnId.ini is present, this will be loaded and used. If the file is not there, it will check if there is an old style connections ini file (ConnectionIDs.ini) in the workspace. If this is present, you will be asked if you want to convert this to managed connections. If not, it will use the old way. If yes, it will convert it to dfconnid.ini and use that. When you open the database connections dialog, it figures out whether you use the old or the new style connections and displays the right information for viewing and editing. This dual approach is used as people will use DBE in mixed version environments where it does not work if it always converts the ConnectionIDs.ini file.
  • Updated the drivers dialog where you can load and unload drivers.
  • Changed the creation of selection lists in DBE from dbList to CJ prompt lists.

Build 19.0.3

  • Added an option to log changes made to data. The option can be enabled in the configuration dialog. The name of the logfile is fixed as "Database Explorer Data Changes.log" and the location is the IdeSrc folder of the workspace. If there is no IdeSrc folder, there will be no logging and no errors. The logfile contains a line per change containing tablenumber, tablename, rowid, timestamp, network user, operation (create/edit/delete), columns containing a change in the case of edit or create and looks like:
254,"CODEMAST","","12-7-2016 09:18:36,603","SecretUser","Create",1
254,"CODEMAST","01000000","12-7-2016 09:18:39,024","SecretUser","Delete"
254,"CODEMAST","","12-7-2016 09:18:44","SecretUser","Create",0,1
  • Changed stored information about a maximized db explorer panel. Should work better on multiple monitors.
  • BT 7095: Fixed by closing the table again.

Build 19.0.4.0

  • Right mouse click on headers in pages with cCJGrid gave a command bars not attached error, fixed.
  • Sorting of table and index entries by header mouse click implemented.
  • Fixed problem with getting db explorer's defaults for what names to be displayed in the grid, max columns setting, etc.

Build 19.0.3.0

  • Fixed problem with selecting a workspace from the Database Explorer workspace list.
  • Fixed problem with index selection page. You could not continue without explicitly selecting an index. Staying on the first row resulted in "no indexes defined" error.

Build 19.0.2.0

  • New icons for workspace selection page.
  • Added managed connection support to wizard.
  • Added managed connection support to code that creates a DataFlex application.
  • Replaced List object with table names with cCJGrid object.
  • Replaced indexes selection tree view with cCJGrid object.
  • Added error condition that a table without indexes cannot be exported.

Build 19.0.3.0

  • Finished scalable icon work.

Build 19.0.2.0

  • Introducing resizable icons.
  • Switch to new visual theme.
  • Small corrections to the panel size.
  • Error number creation dialog visual corrections.