Version History
See whats new in SQLGate!
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 highlight keywords do not work properly
1. Patch error when compiling function
Error message> unterminated dollar-quoted string at or near "$function$
1. You can encrypt the PostgreSQL connection between SQLGate and the PostgreSQL DB instance using SSL
patched the error that prevented connection with the error message below.
no pg_hba.conf entry for host ..
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. Make the Windows title bar invisible
2. Patch for a bug where lists of tables, views, etc. are not visible in the object report in CUBRID 11.2 version.
3. Patch for bug in CUBRID 11.2 version where lists of tables, views, etc. are not visible in script export
4. Patch for a bug where lists of tables, views, etc. are not visible in ER Design in CUBRID 11.2 version
1. Provides auto close of special characters in editor options
1. Provides auto close of special characters in editor options
1. Provides auto close of special characters in editor options
1. Provides auto close of special characters in editor options
1. Provides auto close of special characters in editor options
1. Provides auto close of special characters in editor options