Toad Beta Change Log
Bug Fixes
- AI:
- Access violation when signing into Copilot and not licensed
- AI: Cannot sign in to copilot in some environments
- Alter Table:
- Access violation when user-defined datatypes exist in table with limited privileges
- Missing Type name for user-defined datatypes with limited privileges
- Automation Designer:
- Auto-backup happened too frequently
- Change connection on app didn't trickle down to all actions
- Connections:
- Change Password dialog showed full TNS entry instead of name in no-client mode
- Connection bar button does not display new container when changed by ALTER SESSION command from Editor
- Color role override not re-checking active roles on reconnect
- Error when connecting to 8i
- Reconnect didn't handle SSH connection loss
- Dark Mode: Some controls missing borders
- Data Compare: False diffs in different-comparison connections with multi-column PK consisting of varchar2 and other datatypes
- Data Grids:
- BFILE not displayed correctly in no-client mode
- Custom Column filter not showing dropdown items (Equals, Greater than, etc) properly when primary display is scaled over 100%
- Custom Column filter on timestamp columns allow only one character of input
- Pivot grids don't show grand totals if scientific notation option is unchecked
- Record Selection Count panel not always up to date
- Text popup editor can lose edits when relaunched
- Edit Login Window: Oracle clients not shown in dropdown
- Editor:
- "Control dpDBMSOutput has no parent window" error shown when changing or closing editor tabs
- Caret position lost after formatting
- Clear Editor does not clear unused variables report
- Find with "Exclude Comments" fails to find text directly below a one-line comment
- Refactor indents too much
- Refactoring does not work with text selection
- Save as dialog showing "All Files" for file type on first save
- Script execution did not run script in some environments
- Status bar customize dialog gave access violation if down button clicked without first selecting an item in the listbox
- Trace tab caption changes after being clicked
- Trace grid's Description column expanding after every run
- Export Dataset:
- Can't export multiple tables to Excel file if "Cancel if file exists" option is set
- ANYDATA columns not exported correctly
- XLSX files give "Repair" message in Excel
- Export DDL:
- Create trigger script incorrect for disabled compound trigger
- Non-unique indexes used for constraints appear after their constraints in the script, resulting in SQL error
- Script incorrect for interval-partitioned tables with all system-named partitions
- High DPI:
- Checklist boxes scaled wrong in some conditions
- Editor zoom dialog not scaled correctly
- Font Size may be incorrect in SQL Recall
- Object Search window sometimes has unneeded scrollbar
- Undocked output/spool SQL window not scaling/sizing correctly
- Import Table Data: Error importing XLS file
- Licensing: Expiration date not using locale settings
- Login Window:
- Access violation when filtering connection color column in grid, but not selecting a color
- Access violation when window opens if datagrid is grouped and filtered so that all connections are filtered out
- Menu: Change Session menu item in windows does not always match connection bar
- Misc: Access Violation when closing dialogs on Windows Server editions with Text Cursor option enabled and connecting through RDP or VDI
- Options:
- "Check for Updates" false search result
- Data Grids-Visual - Importing styles does not work well and results in access violation in some cases
- Editor Font/Styling - changing one of the background colors from a color to "None" results in access violation
- Privs Required Dialog: Not visible if a color theme is used, causing Toad to appear locked
- Project Manager: Multi-DB User creation caused error
- QSR:
- Mouse ineffective in grid
- Toolbars not colored correctly in dark mode
- Schema Browser:
- IN ROLLOVER status not recognized for users
- Invalid Objects RHS does not update when switching between package spec and body in LHS
- LHS Tab style is multiline after importing settings from single-line tabs
- Report Wizard opening when double-clicking in some grids
- Script tab for foreign key constraints not showing the create statement
- Session Browser: Blocking/Blocked sessions not appearing correctly in RAC
- Sign-in Dialog: Standard Toad shortcuts causing error
- SQL Recall:
- Font size wrong in some display configurations
- Recall: Semi colon added after slash
- Subscriptions: Cannot generate offline license key
- Team Coding
- Admin window not closing with ESC key
- Can't drop table via script without VCS provider configured
- TNSNames Editor - Font size wrong when Toad run on non-primary display
- TNSNames: Connections with multiple names not fully supported
- Toad jumps to the active virtual desktop when license check occurs
Enhancements
- Administer Tablespaces: IO tab added
- Automation Designer: Backup files in AppBackups folder now match app names
- Connections Bar: Added "Close Connections" option to right-click menu
- Connections: Added Connect Mode to connection error dialog
- Data Grids:
- "Word Wrap" state now remembered in popup text editor
- Add ability to save/load column layouts
- ANYDATA values now displayed and can be edited via popup dialog
- Column filter only allowed 1 character of text in some cases
- Hiding of column after being grouped is now optional
- Database Browser: Added lock icon and details about blocked/blocking sessions
- Editor:
- Default tab style changed to match lower tabs (if you prefer the old style, change
Options -> Display -> Document tab styletoSkin) - Fixed feedback message for a few statement types
- Default tab style changed to match lower tabs (if you prefer the old style, change
- Execute Procedure: PL/SQL Cursor output is now an embedded grid, no longer a modal popup (you still have to double-click to show it)
- Export Dataset: Select, Insert and Merge formats have a new "Multivalue" option which causes the SQL to produce multiple rows per SQL. This makes Insert and Merge statements run a LOT faster now you can have multiple rows per statement. It's a lot more compact too. Oracle 23 and newer only.
- Find in Files/Editor Tabs: Can now be launched from the Editor's find dialog
- Icons: Improved the look of a dozen or so icons
- Installer: Sensitive Data Protection option removed (still exists in Toad options)
- Login Window: If "Favorites Only" is checked, new connections automatically marked as favorite
- Minor optimizations
- Misc: Shift+Options now opens Toad.ini in default text editor
- QSR Script timing added
- QSR: Added caret position to status bar
- QSR: DBMS Output added
- Recover Documents: Auto-open windows when a connection is made
- Schema Browser:
- Add "Password Expire" option to "Account Lock" dialog and vice versa
- Selected count on the status bar includes LHS and RHS
- Shift+Del now checks "purge" option in delete table dialog
- Session Browser: Many enhancements, see this document for details Toad 26R1 Session Browser.pdf (1.5 MB)
- SQLNet Editor: Added support for Data Encryption and Integrity Parameters
- Team Coding:
- Added option for git history revision limit
- Check in/out no longer forces the Output window to be visible
- TNSNames Editor:
- Added ability to sort entries
- Added filter
- Now non-modal when launched from main menu
- Toad Advisor: Oracle terminal releases updated
- Trace File Browser: Identify DML and COMMIT inside of a loop
- Window Menu: Added "Back to prior window" item
- Workspaces: Added Import/Export of selected workspaces
The change log for Toad version 25.3 is here