1. Fixed a bug, which session browser was not refreshed.
2. SQL Query Editor : Added option button, “&” binding variable search or not.
SQLGate 2010 for Oracle Update (4.2.1.3)
1. Fixed a bug of auto update program.
2. Object Explorer : Fixed a bug that data didn’t change when use Table > Data Filter.
3. Object Explorer : Changed a partition index script when execute Table > Script Output.
SQLGate 2010 for Oracle Update (4.2.0.4)
1. SQL Query Editor
- Fixed bug that null is not displayed.
- Improved rate when executing query that has many columns.
- Improved rate when executing query that has lots of data.
- Fixed bug when pasting data.
2. Schema Browser
- Fixed changing view name bug.
3. Others
- Added Online Support and Online Purchase menus.
- Added banner.
- Fixed other bugs.
)
SQLGate 2010 for Oracle Update (4.1.0.3)
1. SQL Query Editor
Display column name when dragging column of query results grid into the editor.
2. Object Explorer
Fixed bug that popup window is not popped up when selecting mouse right button.
SQLGate 2010 for Oracle Update (4.1.0.2)
* SQL Query Editor
1. Added a feature, which paste clipboard data to grid.
2. Improved editing rate of SQL Query Editor.
3. Improved “Execution and Modification” execution rate in SQL Query Editor.
4. Fixed bug that letters typing is not supported in a specific location.
5. Fixed bug that the added group is not visible at tree when adding a group in SQL History.
6. Fixed bug that all arithmetic operations is displayed when grid is selected in SQL Query Editor and Open Table.
* Object Explorer
1. Fixed bug that information of synonym is displayed differently at Object Explorer and Object Panel.
2. Fixed AV bug when unauthorized users modify view.
* Data Import
1. Improved rate of data import for table, which has lots of data.
* Others
1. Find in files : Fixed bug that directory is displayed incorrectly.
2. Program Option : Fixed bug that Chinese is displayed incorrectly.
3. PL/SQL Debugger : Fixed bug that letters are not visible at the selected line.
4. Fixed bug, which occurs when installing on 64 bit windows.
1. SQL Query Editor
- Fixed error of inputted data value when running or modifying current SQL
- Fixed the bug error message wasn’t popped up when violating NULL constraints
2. Import Data, Export Data
- Changed User Interface
3. Update Language Files
1. Main Form / All
- Assigned shortcut keys for Main menu and Creation window
- Changed User Interface of all Creation windows
- Changed User Interface (Tab control, Toolbar button)
- Improved the issue that afterimage is remained when resizing window
- Changed program terms
- Improved program performance
2. SQL Query Editor
- Fixed the screen blink bug at Field Auto Completion
- Fixed the bug when executing current SQL after selecting characters in editor
- Added options for current SQL separator
- Fixed the bug that program shut down when executing binding variables continuously
- Fixed the bug that initial character of editor was selected when occurring error
- Fixed the bug when assigning the shortcut key
3. Others
- Improved download speed when exporting to excel file
- Fixed the bug that window wasn't restored down after minimizing program
- Improved object importing speed in Object Panel
- Changed Recompile object window to MDI type
- Fixed the bug that filter initialization didn’t work in Object panel
- Displayed data filter as default on Data tab in Description window
- Displayed Procedure/Function/Package on new tab in PL/SQL Query editor window when double clicking one of them
1. Display Notice for password change when ORA-28002 error (notice for remaining expiration date) is encountered after login.
2. SQLEditor – Fixed bug that copy&paste feature didn’t work on existing Unique key in SQLEditor.
3. SQLEditor – Fixed bug that cannot find object’s information when click ‘Open describe window(F4)’ for partition table.
4. SQLEditor – Fixed bug that cannot find synonym table on the execution of DESC command.
5. SQLEditor – Fixed highlighting for characters bug.
6. Fixed bug that number type is cut.
7. Fixed bug that cannot open a file on the export Dbase file(dbf).
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.
