Sorry, this page is NOT up-to-date.

SQLTools bugs

Existing problems/bugs

• Wrong declaration length of NCHAR and NVARCHAR on Oracle9i (it has been fixed for 8i but not for 9i)
• No support for ddl and database triggers
• Controlbar window (e.c. "Object List") can be moved out of the screen and be not available anymore
• "Next error" is too slow because of output log redrawing
• DDL reengendering fails if reserved words used as object name/column name
• "Open In Editor" command should set a right document type for a new document
• Wrong error positioning for exec
• Query "select *" from object table fails.
• Multiline "EXEC" fails.
• Type & package bodies nodes don't have "Dependent On" & "Dependent Objects" folders in QuickViewer. It's not possible in the current implementation.
• Integer columns looks like number in QuickViewer.

OpenEditor related:

• If text is tabified then cursor position and selection may displace on changing tab size
• Character '-' is not a delimiter for xml tag/attribute name
• "Find" button can be wrong disabled in Find dialog
• Cannot search for \\t.+" and regexp replace works with \\0 instead of \0
• Template dropdown list should not be sorted in Settings

Fixed

• DDL reengendering fails on Oracle9i with UTF8

• DDL reengendering fails if reserved words used as object/column name
• Some oracle 9i privilege are not supported
• No menu shortcut labels on Win95,... because of SDK incompatibility

• Splitter jumps after window resizing with <Shift>
• Find object fails on object name with schema
• File writing error on export schema
• If you are not connected and display the Object List the close button is dimmed.
• SQL context help (Ctrl+F1) does not work
• "Allow multiple instances to run" does not work
• Checking for changes works even the program is inactive - checking only on activation now
• "Find in Files" does not show the output automatically, wrong line positioning
• "Find object" fails on an object name with schema
• "Extract Schema" fails because setup does not contain schemaddl.dat
• A leak of registry key handles - it's a very critical bug for Win95/Win98/WinMe
• Optimization of GDI resources usage - it's a very critical issue for Win95/Win98
• Redundant settings saving
• "Month" is not recognized as a valid token for date format conversions

OpenEditor related:

• Lower/upper/... operation causes an exception if the current postion is on blank space
• Stack overflow on closing a big PL/SQL file with syntax errors
• Some shell highlighter problem have been fixed
• PL/SQL highlighter does not process '&&'
• Wrong columnar selection after undo
• Document-modified status may be lost if undo memory limit is 0
• PL/SQL "IF"-template cannot be expanded if "Always show Autocomplete list if there is an alternative" is on
• Backup file problem if a destination is the current folder
• Desktop flickers when the pogrom is starting
• Start-line comment (prompt & remark) should be separated by delimiter from text
• Special character button does not work in Find dialog
• A workbook tab toltip shows a wrong path if any left tab has been closed
• Autoindent always uses a previous line as base even the line is empty
• Keyword normalization fails in many cases
• Mouse selection fails sometimes on left button click with pressed
• Scroll position fails on delete bookmark lines operation
• Autocomplete template list cannot be activated on word delimiters ( \t"',! ...)
• Autocomplete template list does not show properly on the second monitor
• Infinite cycle is possible on "Count" or "Mark all" in search all windows mode
• PL/SQL match sometimes fails after some edit operations
• Multimonitor support & NT 4
• Cursor position become wrong after document type was changed
• Missing entry in Find what/replace with history
• Mouse click on gutter does not select line (since 16.03.2003)
• Optimization of GDI resources usage - it's a very critical issue for Win95/Win98
• Editor context menu position is wrong on Shift+F10
• The pogrom fails on attempt to open multiple file selection in Open dialog
• "Save all" command is not silent since "Save all on exit" dialog was created
• Attempt to open File dialog for a specified folder in File explorer fails if any file already open from another location