Release Notes for Alpha Five V11 Update. Click here to see all fixes made to Version 11 since last Version 10 release. VERY IMPORTANT: Before using this upgrade you. SQL Workbench/J - Release History. Build 122 (2017-02-04) Enhancements. Conditional execution of Workbench commands now support -isDBMS and -isNotDBMS. I loved the speaker's gift, as well! This show was a lot of fun and I certainly hope to be invited back next year! In the meantime, though, I am very excited to be.
Release Notes for Version 1. Click here to see all fixes made. Version 1. 1 since last Version 1. VERY IMPORTANT. Before using this upgrade you must publish as least. This will cause a new version of the. If you do not publish at least one file. This is because Windows Server. CLR. The 2. 0 CLR is used. Alpha Five for all SQL Geography functionality. This bug was. introduced in a recent update, and only impacted the. Detail View. Lookups - Grid Component - Dynamic Filtering - . Under some circumstances, the first time you opened a. Grid that had a dynamic filter, the lookup would. Dialog Component - Tab Control - Genie Style - . Repeating Sections - In a 'genie' style tab object. Repeating Section on it, the. Page x of y' would not get updated. These files matched this. Now, the server automatically cleans up orphan temp. To turn on this feature, you will need to edit. Chrome Browsers - Selecting Static Text - Global. Setting in Web Project Properties - In Build 3. CSS to the generated CSS. Grids and Dialogs to prevent static text from. This was done because it is desirable. We described. how you could add the following CSS to the local CSS. See the 'Webkit. (Chrome/Safari) Specific' property. Let's assume you want to set the initial. You cannot do this by. Default Value property of the control. This bug was introduced in. Grid Component - Static Text Objects - Javascript. Events - Javascript events were not being generated. Grid. Grid Components - SQL Tables - DISTINCT - If the. SQL Select statement for a Grid included the DISTINCT. Grid were correct, but. Grid was not. correct. This bug was introduced in a recent patch, but. This is now fixed. We have. determined that this occurs ONLY under the following. The Security Framework is turned on and you are using a SQL database. If you use the recommended policy, you will. Assume also that you have a button in the. Grid row that performs some action. When the user clicks. This is probably not what you want. The. reason that this happens is that the click on the button. To solve this problem you need to tell the button to. Here is how. you can do this: If the button was defined using Action Javascript. Inline Javascript' action as the last action. Propagation). In some cases, this is desirable, and in. R6 - Reports - Suppressing Blank Lines in a Static. HTML Control - When using a Layout Table report, the. HTML. field. In this video we show how blank lines in the. M6. 0 - Three state logical checkbox - Video shows how. NULL. For example. Instead of. returning a character value, it returns a pointer with. OK or Cancel. value - value entered by user. Because support for. V1. 2, we have started. Alpha Five (such as the Export. Chart feature in the Dialog component) to use the. Windows temp folder for temporary files that are. This was. because the list of authorized folders did not include. Windows temp folder. Now, files in the Windows temp. Dialog Component - Data Bound Dialog - List Control. Showing Primary Key Values - Set Current Row in List. Control to Specified Key - If you have used the. Dialog component primary. List control, you can now use a new. List. control. This will, in turn, populate the dialog with. For example. . The Dialog requires controls for user. It can also. use a confirm password control for double entry of a new. The action . Messages to display after. Fedex. Setting session variables in the query string has. V1. 1 shipped. Now, if you try to do. Alpha Five will generate an error. Previously, the. value for the session variable set in the query string. The. permanent value of the session variable was, however. Ascii Import - Quotes as Field Delimiters - An. For example, the following data will can be. You can. specify an absolute or relative (to the webroot) folder. Tabbed UI Component - Auto Launch - Auto Launch. Delay - When an object in a Tabbed UI is set to. Javascript that launches the tab actually. Javascript that might be. A new property allows you to. By default, the delay. Dialog Component - Tab Control - Embedded Objects. When an embedded object (e. Grid component, Dialog. Tab Pane of the tab object, you might want to introduce. Javascript that loads the embedded. Javascript to complete. For. example, the other Javascript that you want to complete. Dialog that. the embedded object is filtered on. For example. dim ssdef as c = < < %css%. Item . Previously the save record action. Doing the work to display the new record as part. Xbasic - Improved Error Message - The following. Xbasic expression now returns a more meaningful. Previously. the error was a somewhat less helpful 'token corrupt'. File. zip. This is. Data. The data to be zipped up. Note that if the connection. Version 2. 00. 0 Native Client, the. Grid - Export to Excel - Use Column Headings for. Excel Column Names - Language Tags in Column Headings. If the replacement strings in the language definition. Web Applications - Calendar Component - Multi- day. Events - Multi- day events were not displayed. Day view. Workspace Files - Hidden Folders - If the. Workspace files are located has been. Alpha Five displayed an error. This is now. fixed. Browse - Data Entry - Focus Row - When doing data. Browse Layout, the row you were editing. This is significant because even if. SQL databases (as most. The security tables can. SQL tables. Click here for. Web Security Framework - User Names - Accented. Characters - Accented characters are now supported. As a result of this, if the Javascript that. Tabbed UI would be closed. If you select the. As a. result, the HTML editor does not see the control as. There is no work around for this. As a. result, the right click menu has been disabled. This. means that if you want to paste into the HTML editor. Ctrl- V shortcut. Dialog - Data Entry in Data Bound Dialogs - . Consider a dialog that is bound to a database. The. dialog has a repeating section, so the data model is. Table==> child. Table (where ===> indicates a. The user then. makes an update to a field in the repeating section but. Previously this would generate. Consider again that same dialog. Table===> child. Table data model. Now. assume that the user has committed the dialog after. Table, but no edits to the. After the update the dialog is set to. The dialog is. therefore showing an existing parent. Table record and no. The user then makes an. Table, and commits the dialog. This no longer. occurs. Javascript Windows - Displaying a Modal Window from a. Modeless Window - The modal window would display. This has been fixed. The modal. window will now always display on top of the modeless. Dialog Component - Data Bound - Default Value for. Repeating Section Fields - When populating a. Dialog component with data from a record, if. Repeating. Section, the Repeating Section shows one record (which. Repeating Section. Forms and Browses - Duplicate - Selecting the. Duplicate' command from the Control Panel did not. Form or Browse. The second class inherits. Says class. Both classes are defined in. DEMO namespace. As you can see, the 'say. What()'. method of the child class calls the 'mom. Talk()' method. of its parent class. As a result, any Ajax callback. Dialog would fail. Grid Component - Linked Content Sections - If a. Grid shown in a Linked Content Section also had Linked. Content (in other words you are displaying a. The situation. was limited to the case where the grandchild Linked. Content was actually two or more Grids shown in a tab. This is now fixed. Desktop Applications - Forms - Sets with Grandchild. Links - Fixed a problem entering data into a form. Reports - Layout Table Reports - HTML Memos - . HTML Memos now inherit the default font from their. Reports - Layout Table Reports - Cell Padding. All memo fields now honor the cell padding settings. Reports - Layout Table Report Editor - Expression. Editor - Edit button for the pop- up expression. This is easily. accomplished by setting the Label's 'In- line style'. Of course, you can set whatever size you want for the. In the above example, we have set the window. Web Applications - Selecting Static Text - Chrome. Browsers - As a result of a change made in the CSS. Grid and Dialog. components, static text on a page is no longer. Chrome. This change was made to so that. If you want. to turn on the ability to select static text on the page. Chrome, you can edit your components and. CSS to the local CSS definitions property: html . For example, a style of 1 indicates exact match, 2. In. a recent update, support was added for negative search styles. For. example, - 1 searches for all records that do NOT equal the search. If QBF mode was turned on and the search style was negative. MA,CA,NY' in the 'state' field, the. OR operator, rather. AND operator. Now, if say the search style was set to - 1 and the user entered 'MA,CA,NY'. MA' AND state < > 'CA' AND state < > 'NY'. Features. Grid Component - Export to Excel - File type of the exported. As a result, the 6. K row limit. on export is now removed. Grid Component - Export to Excel - Spaces in Column Headings - . If column headings in the Grid are uses as the Excel column names, then. Grid column names are now preserved. Build 3. 03. 6- 4. Released - . 3 Nov- 2. Features. Grid and Dialog Components - Dropdownbox Controls - . Cascading Dropdowns - 'Explicit' Cascading Filter - . A new option is available when you define a cascading. You can specify an explicit filter for the. For example, say you have a. When you define the choices for the 'city'. This gives you much more. The. report will therefore print the correct set of records. To get this new functionality, it will be necessary to edit and. This will regenerate the. Javascript. NOTE: The functionality (i. It was not present for reports. Previously, the Report Server could not. Web Control Panel - New option to recalculate all Dialog. Controls in batch mode. See the Edit, Bulk Operations menu. This is. useful if you want to recalculate all controls on the Dialog for a large. Dialog components. It beats opening up each Dialog component. Menu, Recalculate all controls menu item. SQL Workbench/J - . Release History. Release History. Show list of all builds. Build 1. 22 (2. 01. Enhancements. Conditional execution of Workbench commands now support - is. DBMS and - is. Not. DBMSAdded basic support for EXAsol. Added support for SSH tunneling per connection profile. When loading a SQL script it's now possible to automatically detect the encoding. It's now possible to filter the output of Wb. Var. List. It's now possible to pin a result tab so that it doesn't get closed even if append mode is not enabled. Wb. Export, Wb. Import, Wb. Copy and Wb. Confirm now support conditional execution. Wb. Trigger. Source now also supports writing the source to a file. For Postgres, dependencies between triggers and tables are no shown in the Db. Explorer and Db. Tree. For Postgres, functions defined as . COMMIT when the connection is set to autocommit. The list of tables in the Db. Tree is now sorted to work around bugs in JDBC driver that do not properly sort the list of tables. For DBMS that support it, two new modes have been added to Wb. Import: - upsert and - insert. Ignore using native . The quickfilter will then use the defined tags for filtering the displayed profiles. Connection parameters specified on the command line now have precedence over the properties defined through a Liquibase defaults file (specified through - lb. Defaults)It's now possible to enable the use of Oracle's DBMS. In that case it's not necessary to provide them to the respective commands. A new action to run all SQL statements in the editor starting from the cursor position is available. It's now possible to use OS environment variable or Java properties in the username of a connection profile. For Postgres, . The default is now to always export all digits, unless the new - max. Digits parameter is used. For My. SQL, when multiple tables with the same name in different databases had triggers defined, all triggers where visible for each table in the Db. Explorer. When importing multiple files using - use. Pg. Copy and one file generated an error, the previous import was not committed. Wb. Connect would prompt for a password for profiles with an empty password even if . Refer to the Chapter . The old parameter - exclude. Lobs has been deprecated. When using . The alternate delimiter is now always assumed to be on a single line. It's now possible to load a different macro file for each connection. The macro popup window can now be configure to be closed using the ESC key. For Oracle and SQL Server the Db. Explorer now shows if a foreign key is enabled. Wb. Run. LB will now also read scripts included with the < sql. File> tag. It is now possible to copy the current result as Db. Unit XML to the clipboard. Thanks to Brian for the contribution. Wb. Generate. Script now supports the - exclude parameter. For Firebird 3. 0 the source code of procedures and packages is now displayed. The bookmarks dialog now also includes procedure and function names if available. The code completion now also caches synonym translation to improve performance. When running in batch mode and not supplying the - password parameter, a prompt for the password is now displayed. The last directory for opening files can now optionally be stored in the current workspace. It's now possible to open multiple files through . If multiple files are selected, each one is opended in a seperate editor tab. For Postgres 9. 4 the new WITH CHECK OPTION is now shown in the view's source. An new command Wb. Create. Profile is available to to create a connection profile (intended for commandline mode)An new command Wb. Define. Driver is available to to create a driver definition (intended for commandline mode)For Oracle the list of indexes in the Db. Explorer now also shows the index status. Bug fixes. When using Wb. Export with - use. Schema=false and - create. Table=true the create table statement still contained the schema in some cases. The detection of the primary key of a table did not work properly if tables with the same name but different primary keys were present in other schemas. The editor and message panel were using the font the was configured for displaying data. For Oracle Wb. List. Indexes did not show the expression for function based indexes. When the option . If text is selected, the selection is duplicated, rather than the whole line. Wb. Generate. Script has a new option to include the table's GRANTs. The generation of table grants and DROP statements in the Db. Explorer can now be disabled through the options panel. A new result annotation (@Wb. Use. Tab) is available that will re- use an existing result tab with the same name if already present. The way the conditions for join completion are generated can now be configured. The Windows launcher now detects JDK only installations that are identified by the JAVA. The options for auto. Filter, auto. Col. Width and fixed. Header now default to false if a target sheet is specicfied. Support for bookmarks defined through the annotation @Wb. Tag was added. Wb. Import and Wb. Copy now support an option to synchronize sequences with the imported values for DBMS that support sequences tied to a column (Postgres, DB2, H2, HSQLDB)Wb. Feedback now supports the options . This new behaviour can be disabled using the new parameter run. Table. Statement. On. Error. In the Db. Explorer the column definition now includes a flag to show if a column is a computed column or not. For SQL Server 2. SQLThe cache for the auto- completion can now be saved locally to speed up the initial auto- completion display. A new option for Wb. Include was added to print all SQL statements before running them. The UI of the Save As dialogue was re- designed to make the dialogue more compact. Changing the font size with the mouse wheel can now be disabled. Wb. Include can now do a simple text replacement when running a script. For Postgres, Oracle and DB2 Wb. Schema. Report and Wb. Schema. Diff now write more details when dealing with TYPEs. Wb. Grep. Data now also supports - compare. Type=is. Null to search for null values. Reworked the driver definition dialog to make defining drivers that need multiple jar files easier. The list of profiles in the connection dialog can now be filtered. For Oracle and Postgres the displayed error now inlcude the actual error position and the part of the statement that corresponds to that position. If that is specified an existing file is loaded and all data is written to the indicated worksheet overwriting any previous content. A single result can now be detached into a separate window. Displaying a tooltip for the corresponding insert value/column now also works for the INSERT part of a MERGE statement. The SQL formatter now handles MERGE statements. The status bar in the Db. Explorer now shows the total number of objects if the content was filtered. Wb. Var. Def now supports assigning multiple variables when using a SQL statement to supply the variable values. ENABLEOUT and DISABLEOUT now support an optiona. L parameter . Wb. Display) can now also be executed in GUI or batch mode and will silently be ignored. Other occurances of the current selection can now be highlighted. The editor can now automatically reload files that were externally modified. For Informix the additional qualifiers for DATETIME and INTERVAL data types are now displayed. The quick filter in the Db. Explorer now supports adding multiple values separated by a comma (if Reg. Ex matching is not enabled)Wb. Generate. Delete now supports - exclude. Tables to not generate DELETE statements for those tables. Wb. List, Wb. List. Procedures etc) using Wb. Export did not work properly. When adding a new SQL tab while a statement was running in a tab that had a file loaded, the . N'foobar' would be re- formatted to N 'foobar' (which leads to a syntax error)Exporting large results that contained LOB columns could lead to an out of memory error. When using . This the same as the . Displaying the SQL can also be disabled. If enabled, the SQL will only be shown on the first page. Added support for Postgre. SQL 9. 3 MATERIALIZED VIEWs. Column headings can now be displayed in bold face (Tools - > Options - > Data display)The editor now supports . If enabled, any column defaults from the source table are ignored. A new option to change the alignment of numbers in the result display has been added. A new option has been added to use an ORDER BY reflecting the current sort order when reloading table data in the Db. Explorer. The new - ignore. Identity. Columns as well as the pre and post- table statements can now be specified in the Data. Pumper. A new option for Wb. Schema. Report - object. Type. Names is available to select objects by type and name (possibly with wildcards)When editing a date or timestamp column, the value is now displayed in the same format that is defined in the options dialog for . CASCADE (if the DBMS supports is) by specifying - drop. Target=cascade (instead of - drop. Target=true)Bug fixes. When replacing text inside the selection, the selection wasn't properly adjusted to reflect the new length of the text after the replacement. Compiliation errors for packages/procedures in Oracle where not shown if the procedure was prefixed with a schema name. When a borken workspace was loaded, the main windows UI was corrupted. Wb. Schema. Diff would fail without an error message if object types without attributes (e. Shift- Insert) were no longer working. When invoking code- completion for a specific schema, the schema name appended twice if the case written in the editor did not match the actual case as stored by the DBMSConfigured SQL statements to retrieve view, trigger or procedure source would not work if they had sub- selects with a WHERE condition. The columns of an index where no longer displayed in the index list of the Db. Explorer. The office libraries (for exporting Excel files) were not bundled correctly in the Mac package. When invoking code completion for an already schema- qualified identifier, the schema would be pasted into the editor again.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |