1. Fixed grid sorting bug.
2. Added view detail window(F4) feature for Synonym, partition table.
1. ODAC version update
2. DEVExpress version update
3. Fixed a bug related to multilingual.
1. Fixed the menu error in SQL Result window.
2. Fixed connection window didn’t free memory.
1. Fixed misunderstanding ‘CR’ character to ‘CR/LF’ character in the SQL Editor.
2. Fixed the SQL Editor is not editable, after opening a file.
3. Fixed removing the wrong character when user pastes code.
4. Added encoding to ANSI, UNICODE on ‘Export Data’ menu.
5. Fixed cutting the Chinese character.
1. Fixed the drag and drop error in the query builder.
2. Fixed ‘Index Out of Bound’ error, which occurred trying to start SQLGate more than twice.
3. Fixed shutting the SQLGate down when move the tab in the session browser.
4. Fixed the bug, the editor space is not displayed after resizing result window in the SQL editor.
5. Added (FTP/SFTP) feature in the 'TKPROF editor'.
6. Fixed the bug, the application displayed out of the monitor when used one after using multiple monitor.
7. Fixed the bug, shortcut didn’t work after modified by user.
8. Added table filtering feature in the ERD designer.
9. Added ‘SQL Format Option’ feature.
* Login Window
- Fixed login bug at Unicode Mode.
- Added the feature, change the password for expired account.
1. New Connection Window
- Added Unicode in the character set.
- OCI Login : Set character set as user’s local character set automatically.
2. Schema Browser.
- Added Scheduler Job Schema (10g or later).
- Added Materialized view, Materialized View Log Schema
3. Added ‘LogMiner’ feature(Developer version).
4. SQL Editor
- Added ‘DBMS_XPlan’ feature (10g or later).
- Added ‘SQL Tuning Adviser’ feature (10g or later).
- Added ‘AWR Report’ feature (10g or later)
- Added feature, docking result window.
- Added feature, converting results to web-script (ASP, JSP and PHP).
5. Added ‘ER Designer’ feature. (Developer version).
6. Miscellaneous
- Fixed bug, Dateformat didn’t display at gird.
- Added MView,MView Log, Scheduler Job in the Report Tool.
Added support for a simple layout function.
OCI_Invalid_Handle error will not occur in creating more than one Oracle session.
Resolved an issue in importing Text and CSV.
Fixed an issue where SQLGate displays full logs when importing table.
When updating table, SQLGate now displays updated column name.
1. SQL Editor
- Added support for automatic restore from abnormal termination of SQL Editor
- Fixed a bug in locating error when there is a Korean comment in the query statement.
- Added support for a keyboard shortcut Ctrl+Q to toggle between Editor and Result Grid.
- Added support for a keyboard shortcut (Ctrl+Shift+Q) between Result Grid tabs.
- Fixed a bug with grid in thread destroyed after canceling query.
- Improved auto trace function that didn't work properly.
- Added support for MERGE keyword highlight function.
- Fixed a bug in reporting statistics of the query execution.
- Resolved an issue that displays removed table name in the auto-completion list (10g and above)
- Fixed a bug where SQL history wasn't saved.
2. Schema Browser
- Filtering function in opening table works now.
- Resolved an issue that last Korean character was missing in creating table or adding comment to a column.
- Improved table creator to update the table creation script when inputing default value
- Fixed a bug in opening Update DataType window.
3.Miscellaneous
- Improved toolbar to support vertical alignment.
- Report will be updated when schema is updated.
- Fixed a bug in failing login when multiple version of Oracle client installed.
- Fixed a minor bug in import/export function that didn't display log file in its execution.
1. Schema Browser
- Fixed a bug where nvarchar and nchar data type was not reported properly.
- Table Information: Constraint column will be removed if constraint is removed.
- Improved an issue that image for PK was broken in displaying table information.
- Resolved an issue that displays several synonyms in partition table.
- Fixed an issue in schema brower (tab style) whose filter options wasn't displayed properly.
- Fixed an issue that couldn't delete view just crated.
- Fixed a bug that detail information didn't show when user selected table name that contains space and press F4 (Describe Schema).
2. SQL Editor
- Improved saving history file
- Added support for keyboard shortcut Shift+Del (Cut function)
- Added support for keyboard shortcut Shift+Backspace (Backspace function)
- Fixed "Select All" button that was broken in group panel view.
3. PL/SQL Editor
- Fixed a bug that los source changes when switching panel view style.
4. New Connection Window
- Fixed a bug that Oracle registry editor doesn't display.
- Fixed a bug where error occurred in connect after selecting all history.
- Fixed an error 'Use Unicode Option must be set to true for Unicode OCI environment' that occurred in login.
5. Miscellaneous
- Fixed "Create Table" windows that didn't disappear on the logout.
- Added announcement windows in the install program.
- Improved export function to export more than 60,000 records to excel.
1. Automatic Update Program
- Fixed a bug in checking if SQLGate is running.
2. SQL Editor
- Improved handling &(binding) variable.
3. Schema Browser
- Improved importing package feature.
- Added supports for updating and executing package (treeview style)
4. Improved auto-hide feature of object panel.
- Fixed a bug in selecting sub-query block.
- Modifed execution mode of PL/SQL editor to compile.
- Fixed a bug where the options form doesn't display some characters in windows 7.
- Changed the custor to hand pointer style in folding.
- Fixed SQL creation in security manager.
- Improved speed of hiding object panel.
- Fixed a bug where the purchase page doesn't display when user clicks "Purchase" button on the first run of SQLGate.
- Fixed an issue of displaying 'Default is not a valid integer value' message when updating a table.
- Fixed procedure/function/package source viewer which missed ',' in the parameter.
- Improved the speed of showing and hiding object panel.
- Fixed a problem in hiding object panel.
- Fixed no response issue of object brower in finding object by clicking left mouse button with control key in SQL editor.
