Version History

Bug Fixes

1. Fixed a bug where shortcut keys would not be applied immediately after moving the grid after executing a query in the SQL editor.

Improvements

1. Improved the color of column selections when moving focus to the editor after selecting a column in the grid.
2. Improved the readability of the focused cell in the grid.

Bug Fixes

1. Bug fix where shortcut changes in the editor would not apply to open windows and would require a restart.
2. Bug fix where shortcuts in the SQL editor would not be applied immediately after moving the grid after executing a query.

New Features

1. Added a button to reopen all docking windows in the PL/SQL Debugger when they are closed (View Docking Panels).

Improvements

1. When [Auto Show] is selected in the SQL Editor AutoComplete options, [Object AutoComplete] and [SQL AutoComplete] are now clearly displayed for readability.

This release fixes bugs in key features such as the editor, autocomplete, object panel, and data export, and adds new features to improve usability. We've focused on improving multi-session management, code editing stability, and UI/UX.

Editor Improvements

Bug Fixes

1. Auto-complete error when connecting multiple sessions
   • Fixed an issue where keyword auto-completion did not work properly even after disabling one of the multiple sessions.
2. SQL content loss error when opening a file
   • Fixed an issue where the query being written would disappear when opening a file while editing SQL/PLSQL.
3. Focus position error after SQL alignment
   • Fixed an issue where the cursor did not return to its original position after SQL alignment.
4. Fixed a bug where moving focus after SQL alignment did not return to its original position.
5. File A bug has been fixed where drag-and-drop operations do not load into the split editor.
6. When opening a file with multiple editor tabs, tabs are not immediately activated.
7. A bug has been fixed where the last tab is not activated when connecting a session and loading a workspace file with multiple tabs.
8. A bug has been fixed where the contents of an existing file are loaded when opening a new editor after dragging and dropping a file when there are no editors in the main window.

New Features

1. Added [Load Initial SQL] button.
   • Support for retesting the initial SQL after changing formatting options.
2. Added the ability to specify an initial folder when saving a file with a different name.
3. When opening a file in an editor tab, the full file path is displayed in the tab hint. Added

Auto-complete Improvements

Bug Fixes

1. ​Delayed Reflection of Code Template Changes
   • Fixed an issue where template changes were not immediately reflected.
2. ​Multi-line Comment Display Error
   • Fixed an issue where text was broken in multi-line comments.
3. Fixed a bug where text was not displayed correctly in multi-line comments.

New Features

1. ​Added [Auto-Show] option
   • Provides a setting to disable all auto-complete features in the editor options.

Object Panel Improvements

Bug Fixes

1. Tab Style Initialization Error
   • "Single-Line Tab" Fixed an issue where styles were not applied during initial loading when selecting a style.
2. ​Columns not displayed when selecting a trigger
   • Fixed an issue where columns were not visible after selecting a trigger.
3. ​AV error when selecting a foreign key
   • Fixed an error that occurred when selecting a foreign key in a constraint.
4. ​Recycle Bin object information not displayed
   • Fixed an issue where objects were not visible in the [Information] tab after selecting the Recycle Bin.
5. ​Partitioning table partition area error
   • Fixed an issue where sub-partition areas were not displayed correctly when selecting a partitioned table.
6. ​Table annotation editing failed
   • Editing table annotations in the Object Explorer Fix for a bug that caused the feature to not work.
7. ​Improved error code accuracy​
   • Display a specific error code when retrieving object information fails.

New Features

1. ​Support for editing annotations for views and materialized views​
   • Added annotation editing functionality for views and materialized views.

Data Export Improvements

 Bug Fixes

1. ​Folder path error when selecting multiple tables​
   • When exporting after selecting one or more tables, the error "Folder does not exist" appears. Fixed an error issue.

Options Improvements

Bug Fixes

1. Adjusted code template font size
   • Fixed the issue where template fonts were displayed too small.
2. Keyword template label truncation
   • Fixed a UI bug that caused label text to appear truncated.

Debugger Improvements

Bug Fixes

1. Font size errors on extended displays
   • Fixed the issue where fonts appeared too small on extended Windows displays.

Grid Improvements

Bug Fixes

1. Removed Grouping/Summary Menu
   • Removed unnecessary Grouping, Summary Panel, and Column Selection items from the right-click menu.
2. Added Density Margins
   • Improved readability by adjusting margins based on grid data density.
3. Column Text Display Error
   • Fixed an issue where some text within a column was cut off.

Bug Fixes

• Fixed a bug where the Undo function in the SQL Editor did not work properly.
   Fixed a bug where the "Undo" function in the SQL Editor did not fully function in certain situations.

New Features & Improvements

• Added option to adjust main menu font size
  Users can now freely adjust the font size of the main menu for improved readability.

• Added auto-completion for bind variables
  Auto-suggestions are now provided for bind variables in the format :variableName during SQL writing.

• Improved auto-completion performance for bind variables
  The response speed of the auto-completion feature has been enhanced for a smoother user experience.

• Improved theme switching speed
  Theme transitions (e.g., Dark/Light) now occur faster with reduced latency.

New & Improved Features

• Oracle Cloud Wallet Login Support
  You can now log in using Oracle Cloud Wallets directly within SQLGate.

• Improved OCI Login Initialization
  SQLGate now prioritizes loading the TNS_ADMIN environment variable during OCI login, ensuring more stable and predictable connection handling.

• Mixed Connection Support
  Users can now use both Direct Connection and OCI Connection modes simultaneously within the same environment.

• Enhanced PL/SQL Editor Performance
  The PL/SQL editor now loads more than 3x faster, improving productivity and user experience when working with large PL/SQL scripts.

Bug Fixes

• Login Failure on Latest Oracle Versions
  Resolved an issue where users were unable to log in after updating to the latest version of Oracle.

• Object Panel – Missing Packages from Other Users
  Fixed a bug where packages or package bodies owned by other users did not appear in the Object Panel.

• Object Panel – Missing Job Schedulers from Other Users
  Fixed an issue where job scheduler entries from other users were not shown in the Object Panel.

• DBA Recognition Issue
  Fixed a bug where users with the SELECT ANY DICTIONARY privilege were not recognized as DBAs.

• SWS File Load Issue with Multiple Panels
  Fixed an issue where SWS (SQLGate Worksheet) files were not properly restored when using three-panel layouts.

• Session Statistics Display Bug
  Fixed a bug where "Session Statistics" under "Execution & Session Statistics" did not function correctly in the SQL Editor.

1. 1. Remove the feature to retrieve all records when dragging the column header in grid mode.

1. Bug fix for objects selected in Auto-Complete in Editor Options not being applied immediately

2. AV error fix in Object Highlight

3. Message processing when deleting one or more records in F6 mode

4. Bug fix for column sorting not working in grid mode

1. Improved the function to assign auto commit to each session

2. Improved the function to search for objects in the object panel without case
sensitivity

3. Fixed a bug where negative numbers were not displayed correctly in the grid

4. Fixed a bug where object scripts did not work correctly in the tabbed object panel

5. Fixed a bug where objects selected in the object auto-completion in the editor options were not immediately applied

1. Bug fix that prevents data from being modified intermittently in the grid

2. AV error fix when moving columns in table creation

3. Bug fix that prevents skins from being applied correctly when forced to close after changing the theme

4. Improved table script export speed

5. Removed inconvenience of having to add an alias name when the login password is incorrect

1. Fixed a bug where the correct value was not copied when copying to the clipboard after sorting columns in the grid.

1. Added option to add grid column header to SQL editor

2. Fixed issue where compilation error occurs during object recompilation and stops immediately

1. AV error patch when Ctrl+Click is pressed in SQL editor

2. Bug patch where object highlight in SQL editor changes to random color

1. Add CTE auto-completion feature

2. Do not display SQLGate-specific comments when dictionary query error occurs

1. Bug fix for the last logged-in tab not being activated in the free version

2. Bug fix for the compile result not being displayed in the object recompile

3. Add "New View" to the right mouse button in the view menu in the object panel

4. Added a resizing function for the data import window

5. Function improvement for loading login information of the 6.X version

6. Added a "Always on top" checkbox to the binding variable window

7. Added a load function after saving the last position to the binding variable window

8. Other bug fixes

1. Fix bug that prevents Generator64.dll from loading

SQLGate for Oracle Version 10 Released

1. Changed from 32-bit to 64-bit version

2. Oracle client supports only 64-bit version

3. Consolidated connected sessions into 1

4. Improved initial loading speed and database connection speed

5. Provided work area save and open function (sws extension)

6. Added session disconnection function during query execution

7. Added function to change to another session in the editor

8. Provided full grid column selection function in the SQL editor

9. Partial record retrieval / all record retrieval selection is possible in the SQL editor

10. More than 3 million records can be retrieved without memory error in the SQL editor

11. Improved speed of grid display after query execution in the SQL editor

12. Improved grid speed when querying CLOB, BLOB, RAW type data in the SQL editor

13. Improved speed when using binding variables in the SQL editor

14. Added function to move to the position of the ')' character when clicking the '(' character in the SQL editor

15. Binding variable window in the SQL editor Added a function to run without closing

16. Improved Replace, Undo, Redo speed in SQL editor

17. Added an icon to the tab when executing a query in SQL editor

18. Changed the color of the progress bar to the same color as the session in SQL editor

19. Added a function to specify the color of the cell when directly modifying the cell in the grid

20. If you cannot connect to the update server offline, run it without connecting to the update server

21. Changed the function to change the tab name immediately without pressing Enter

22. Added a schema filter function to the object panel

23. If the session is forcibly disconnected, the work area is not closed

24. Changed the XLS format to XLSX format in report export

25. Packaged so that it can be installed on MAC OS
 

Patches

1. Fixed a bug that caused a "database is locked" error when modifying a record

2. Fixed a bug that caused screen afterimages to appear at a specific resolution in a DVI environment

3. Fixed a bug that caused the location of a specific control in a DVI environment to keep changing

4. Fixed a bug that caused data to change when a specific folder does not exist in a virtual environment in a DVI environment Bug patch that causes an error when exporting

5. Bug patch that causes afterimages to remain when there are no records in the grid in a VDI environment

6 SQL history sorting error patch

7. Fixed the phenomenon that some records are not visible when the grid is resized

8. Fixed the phenomenon that blinks when the session is changed

9. Fixed the phenomenon that blinks when the editor tab is changed

10. Focus error patch when executing F5 in the grid tab

11. Error patch when pressing the cancel button when changing the server character set

12. Export error patch when there is no folder when exporting data

13. GDI error patch when setting Grid mode in the grid

14. Handled so that driver errors do not appear at startup when the printer driver is not set correctly

1. Bug patch where colors are not displayed correctly when columns are sorted in the new connection window

2. Import data > Excel file > Change the default value to not select automatic column mapping when UPLOAD

1. Patch AV error when closing last tab in SQL editor

1. Patch for bug that does not enable subquery block execution

2. Patch for bug where OCI/Net Login tab does not open as last environment

3. Improved data import speed. Speed ​​improvement of more than 10 times when executing updates when importing data

4. Bug patch that prevents DBMS_OUPUT results from being retrieved

1. Patch for bug where duplicate connections are intermittently displayed as existing connection information

2. In the actual execution plan, set the record fetch option to “fetch all records”

1. Patch for bug that does not display when number of records is 0 after SELECT

2. Patch for bug where actual execution plan and AWR report do not work properly
3. Patch for bug where ) in (a) is not closed in auto close
4. Patch for bug where special character auto-close option does not work properly

1. Changed the function to maintain records in the data tab after executing the execution plan

2. Patch for bug where multilingual characters are not saved in SQL history

3. Change the window so that it does not close even after the session is terminated.

1. Improved function to prevent other functions from running while a query is running

2. Show in progress icon in editor tab when query is running

3. Speed ​​improvement through editor deletion of binding variables

4. Added the ability to change tab names on the main taskbar

5. Improved function to allow access to the same session

6. Added session name duplication function when the same session connects

7. Speed ​​improvement by removing user analysis function

8. Patch where workspace is not saved correctly when connected to multiple databases at the same time

9. Patch for bug where SQL editor tab leaves an afterimage when session is changed

10. Patch for a bug that leaves an afterimage when there is one session and the session is closed

11. When connected through multi-session, patches are not selected at once when moving to another session's tab.

12. Patch for bug where editor font changes after pressing Tools>Options>Editor Options>Ok

1. Patch for a bug that leaves an afterimage in the work window when disconnecting a single session

2. Improved slowdown in binding variables with many binding variables

3.Patch for bug where table autocompletion does not change when there is more than one session

4. Improved screen switching speed when switching sessions

1.Remove the main title bar

2.Improved workspace loading speed

3. Add brief layout, theme, and option menu

4.Improved autocompletion speed in SQL editor

5.Improved automatic closing of special characters in SQL editor

6.AV error patch when entering “..” in SQL editor

7. Modify the CHAR and VARCHAR keywords so that () does not appear automatically in the SQL editor.

8.Set scroll font size as default in SQL editor options

9.If the column type is NVARCHAR, do not use CHAR, BYTE keywords

10. Ability to add Indent when executing a code template if the template has more than one line

11. Add parameter auto-completion option - Add general function hint function

12.Improved speed of retrieving the first record for tables with many columns

13. Patch for a bug where the read-only option does not log in in security tools such as DBSafer and QueryPie.

14.Patch for bug where COLUMN <> NULL is displayed when filter is set to COLUMN IS NOT NULL

15.Patch for a bug where when you Ctrol+Click a package in a package.function, the package is recognized as Owner and the package cannot be found.

16.Bug where the DEFINE command does not work properly

17. Bug where the editing window disappears when connecting/disconnecting the DB alternately

18. AV error patch when entering “..” in SQL editor

19.Patch for a bug where the editor’s menu bar does not appear consistently when using a simple layout

20. Patch for a bug where the window would not close intermittently in Options and Editor Options.

1. Provides auto close of special characters in editor options

1. Eliminate the phenomenon of the main split moving when activated in the SQL editor.

2. Improved the SQL editor to highlight table names after CREATE TABLE and DROP TABLE commands.

3. Improved the speed at which autocomplete appears when there are long queries in the SQL editor.

4. Removed the phenomenon of the scrollbar being obscured when there are many grids after multi-query in the SQL editor.

5. Improved the phenomenon in which the grid is not converted correctly when converting horizontally or vertically after a multi-query in the SQL editor.

6. Improved the SQL editor so that table auto-completion appears after ALTER TABLE.

7. Remove flickering phenomenon when moving Ctrl+Tab in main form

8. Remove horizontal and vertical menus from Main>Window

1. Patch for a bug that does not work if there is a binding variable when exporting data from the SQL editor

1. Add “New Connection” menu to the connection window

2. The SQL editor provides an automatic closing function for special characters ((),[],<>,'',"")

3. Added auto-connect character set restore function in new connection to avoid seeing again

4. Added a function to allow multiple clipboard values to be input simultaneously into binding variables.

5. Improved performance of exporting large records when exporting data after selecting a grid in the SQL editor

6. Improved the “Connect” toolbar not also displayed in Quick View

7. Improvement so that keywords are selected even if you select Enter and Tab after typing all keywords in the SQL editor.

8. Improved the SQL editor to not convert case to lowercase if the column of the table is a specific keyword.

9. When deleting all connection information in a new connection, enter “Delete me” and then delete it.

10. Improved the “Connect” toolbar to disappear from the main menu toolbar.

11. Fixed a bug where Korean messages were not displayed in the annotation editor.

12. Patch AV error in grid filter

13. Bug fix where the cursor in the grid does not move after “stop” in the SQL editor.

14. Patch for bug that changes to another language when changing display language in options

15. Bug fix showing as no permission in the table's Constraints tab.

16. Bug fix where local partitioning index script is not displayed correctly in table script