Version History

1.Fixed a bug where shortcut keys (Ctrl + /) were not assigned in the editor

2. Fixed a bug where column sorting is not saved in the login window

1. Patch a bug where sequence scripts are not output in the object panel

2. Add "procedure" object in Objects panel (PostgrSQL 11+)

1. Change the column comments can be edited directly in the detail window to edit mode with F2 key

2. When double-clicking a column in the detail window, add it to the editor and change the editor focus so that it does not move

3. Change to ASC=>DESC=>None when clicking the column header in the detail window

4. [Online Support] Add speed icon

1. Private key available for SSH connection

1. Fixed a bug where continuous AV error occurs when the program is closed

1. Patch a bug where autocomplete no longer works due to autocomplete error in join clause

1. Suppress error message when query is stopped

2. Patch a bug where autocomplete no longer works due to autocomplete error in join clause

1. Fixed a bug where query results were not displayed in the grid intermittently

2. Improved to display a highlight when there is a # character in the table name

1. Eliminate flicker during initial loading

2. Improved the function of the Korean table name to be a highlight

3. Automatic completion of Korean table names eliminated the phenomenon of double quotation marks

4. Added highlight border option to editor options

1. Fixed a bug where the tab of the last connection information was not activated in the new connection window.

2. Removed the Ctrl + Mouse Over function in the SQL editor due to frequent bugs

3. Fixed a bug where SQL records are not used at the same time when executing two SQLGates.

4. Fixed a bug where user folder does not appear in SQL history

Fixed memory error bug while using autocomplete

1.Fixed a bug where the data export/data import menu does not appear

2. Fixed a bug where PK information was not loaded in data import

3. Add "extended import mode" to data import

4. Fixed a bug where table scripts could not be imported in PostgreSQL version 13

1 Fixed a bug where data is not displayed even after querying after copying a table

2. Fixed a bug where data is not displayed even after querying after successful table import

1. Add PK, Not NUll display function to grid

2. Added "Highlight text with cursor" color change function in editor

3. Added "Data first view" option in Object Explorer

4. Improved the speed of opening the SQL History window

5. Improved the speed displayed in the grid after query execution

6. Improvement of movement speed when changing application resize

7. Change the tap location to the last connection information when connecting to the cloud

8. Match one transaction after connecting SQL session to the table object in the upper body window

9. Improvements so that double quotation marks are not displayed in the object name in the table tab in the detail window

10. Fixed a bug where groups were displayed incorrectly after clicking Favorites on the login window.

11. Fixed a bug where the total was not displayed correctly in the status bar at the bottom of the detail window.

1. Corrected error that does not allow offline authentication in some environments.

2. Corrected error that caused ERD files to not display normally when imported.

3. Corrected error where the table 'script' is not output properly.

4. Corrected error that caused failure to operate normally during connection test.

1. Corrected offline authentication failure error
2. Corrected error with information entered not reflecting in SSH connection
3. Corrected error occuring when modified query data leads to program crashing when query runs

1. Added function to store access information in the Cloud (Beta)
2. Improved Editor Speed and Stability
3. Corrected errors in the Editor 'Find' Window
4. Added support for PostgreSQL v12

1. Free Version Restriction Adjustment
2. Improved location process when creating a new SQL Editor
3. Corrected screen movement errors when disconnected from multiple session connections

1. Improved offline use speed
2. Bug patched: Grid not properly displayed during multi-query iteration
3. Bug Patched: ‘Copy Clipboard to RTF’ function not working properly
4. Bug Patched: Focus not changing correctly after selecting the grid panel
5. Bug Patched: In some situations, the ‘Run Subquery Block’ function is not functioning properly
6. Added Editor Option “automatically search selected text”
7. Added Editor Option “highlight text with cursor”

1. Added session end function when 'Disconnect' is selected
2. Added Editor zoom in/out
3. Editor supports 'ligature font'
4. Bug Patched: 'Stay Connected' feature not functioning properly
5. Bug Patched: Error messages not displayed properly when running 'SQL Validation' from the 'Create View' window

1. Bug Patch: 'Object reports', 'Export script' issue fixed
2. Bug Patch: 'New Connection' Access information not correctly displayed

1. Bug patch: Mouse scrolling function not working in the editor area issue
2. Bug patch: 'Software License Agreement' is not properly displayed issue

1. Bug Patch: When exporting data, time-related columns are quoted in a duplicate output
2. Improved product authentication errors while offline
3. Improved Grid Selection Speed
4. Added Grid 'Automatic selection calculation' options
5. Improved Editor Speed
6. Change 'Use Unicode' to default setup values

1. Bug Patch: When using "Data Export" to export as an Excel file, if the value of an integer field is zero it is saved as 'Blank'
2. Improved access information and History File security processes

1. Fixed License Authentication Error while Offline

1. New Function: Find Previous
2. Enhanced information and History file security
3. Null value processed when using ‘Data Import’
4. Bug Patch: Error when ‘Processor’ is changed
5. Bug Patch: Unable to save when modifying open documents after 'Drag & Drop'
6. Improved SQL Transformation functionality
7. Bug Patch: Editor tab numbering error
8. Editor-related Error correction and enhancements
9. Bug Patch: Screen does not display normally in Setup window
10. bug Patch: Error when selecting a function of the same name on Object Panel
11. Modify SSH Connection Error

1. New function: Able to rename tabs on the taskbar

2. Bug Patch: Enabling subquery blocks issue fixed

3. Improved options for deleting stored access information during uninstallation

4. Bug Patch: Program window minimizing and restoring issue fixed

5. Bug Patch: Editor Options run at setup issue fixed

6. Bug Patch: ‘Out of Memory’ issue fixed

7. Bug Patch: Expanding ERD issue fixed

8. Improved ‘Transaction Block’ after incorrect query execution

1. Education License Certification available

2. AutoUpdater icon modified

3. Improved program execution in case of corrupted setup files

4. Fixed: Editor color does not match the theme after change

5. Added option : subquery background color selection

6. Improved certification procedures when running a product.

7. All saved connection information deleted once product is uninstalled.

8. Fixed: Multiple tabs open in SQL Editor workspace.

9. Improved tab-related features in SQL Editor.

10. Fixed: After clicking [show blanks/tab characters/carriage returns] results display incorrectly.

11. Fixed: In SQL Editor, in [Run and Modify Current SQL] if the subquery is present then it will not be modified.

12. Fixed: Unable to highlight when fit option is enabled in Main Menu.

13. Added features and bug fixed for SQL editor option.

14. Fixed: Editor Tabs and Saving Workspaces.

Update date: 08/31/2018

Update contents

1. Add SQLGate startup option (auto-connect)
   sqlgate.exe -s alias