OraEdit & OraEdit PRO Ver. 4.0 Release Notes RELEASES CHANGES ============================================================================ Ver. 1.0: Original Release (beta). Ver. 1.1: -The comparison performance has been increased, and output decreased. -Segmentation fault when closing all tabs - fixed -Segmentation fault on Window menu - fixed -Help is now available -Feature to automatically check for new versions -Tip of the day functionality -Auto open workspace now remembers password when applicable -Edit preferences now saved only when required -New option to always open object in new tab -New option to constrain or not the cursor to the text Ver. 1.2: -Click on error screen not always displayed correct window - fixed -Weird characters on search results removed -Workspace open segmentation fault - fixed -Reload from database truncating extra spaces - fixed -When just saving a new workspace, auto reload would load previous workspace - fixed -Context sensitive help added Ver. 2.0: -Browse through multiple owners on the database -Ability to export and compare code owned by other users (provided privileges are properly set) -Single line triggers not displayed properly - fixed -Scroll bars were disappearing at times - fixed -Updated Help File Ver. 2.1: -Multi-threaded loading of database objects for faster access -Updated help file -Compiled optimized for speed -Database name not displaying in compare dialog if loaded through workspace - fixed -Export of triggers not adding "owner" to trigger name - fixed -Display of end of lines in error dialog - fixed -Added icon for owners Ver. 2.2: -Problem with Oracle not disconnecting when closing workspace - fixed -File name default on save as not always given - fixed -Added option to always include owner name in object -Updated help file -Added ability to change database without having to close tabs -Added some options to the right click menu on edit section -Now able to truly close all tabs (last tab is replaced by a new empty one) -Fixed problem with "Add Tab" Toolbar entries not working on first database -Added ability to know if another instance is open and therefore NOT open last workspace again Ver. 2.3: -Enabled Ctrl+tab to switch tabs -Find dialog remains open after finding string - added -Fixed problem with old errors showing when disconnected from oracle after compile -If Connection to database is dropped during an export, the tool will terminate and report a warning -Fixed location of screen when display is resized to prevent screen from appearing outside the viewport -When connecting to sys or system if flag was set to not show sys/system it wouldn't show objects - fixed -Even after refreshing source browser, edit will reconnect to the tree after compile -Trap ; after object name. -Added automatic detection of latest OCI DLL -Added object browser to navigate through all user objects and help editing -Added parsing for functions and procedures within packages. Ver. 2.4: -Added reload button to Object browser -Update of help file -Fixed problem with Saving "untouched" templates As... -Added options for automatic load of sub functions and procedures in source browser -Added option to comment/uncomment selection Ver. 2.5: -OraEdit PRO merged with OraEdit which fixed some bugs and added functionality. The following is a detailed description of all the changes: Build 128: ----------------------------- * Dependencies are now properly shown for packages and package bodies * Problem with selecting correct property page on settings - fixed * Ability to define dbms output buffer size * Parsing for tips was taking too long on large packages * Added ability to change font and size * Fixed problem with newly created objects appearing upper case in export dialog * Accelerator for Change Database was not working - fixed * Pressing '. was giving core dump - fixed * Password is no longer showing on logon dialog * Added option to go to matching brace or parenthesis * Now if DBMS Output window is closed when exiting, it does not open automatically next run * Fixed highlight position when debugging triggers with comments * Proper parsing of cursor variable values during debugging, both for Watch and Tips Build 129: ----------------------------- * Compare while debugging is now fixed * When debugging a function within the same package call now cursor position is correct * Performance improvements during connect and object retrieval (added new mode) * Fixed problem with replace dialog not enabling Find button when needed Build 130: ----------------------------- * Now OraEdit does not allow you to close connection while debugging is executing * Export dialog now remembers last destination * Added missing options to menus (Compile Debug+Execute+Dependencies) * Default on Add Watch dialog now provides proper default when selection exists * Spelling and alignment of some controls in settings dialogs now fixed * Added ability to delete variables from watch * Added help button to Execute Dialog * First build with Help Documentation (Context Help) Press F1 for help * Fixed Core dump when debugging with output multiple times in a row * Solved Refresh problem on watch dialog * Fixed problem with Breakpoints not being deleted properly * Problem when search before retrieving objects, double-click did not open object - fixed * Functions of type user.package.func were not displaying prototypes * Added caching for owner objects to be used in code list for better performance Build 131: ----------------------------- * Significant performance improvements * Ability to delete entries from the Recent Login list by pressing the DELETE key * Fixed display problem when clicking on Variables side on watch dialog * Fixed floating tip while debugging for cursor variables * Fixed problem where modifying a view and then successful compile, sometimes marked it invalid * Added debug option "Run to Cursor" * Added Debug property page on settings with 3 new options and ALTER was moved from Database to Debug Build 132: ----------------------------- * Fixed problem with date being in UTC time instead of local * Updated help file * Added ability to change colors and styles for keywords, text, comments, string, operators and line numbers * More performance improvements * Ability to load and compile objects even while OraEdit is loading * Option to have object type included in tab caption * Ability to change the tab's captions (rename tab) * Added option to drop objects * Added option to select sub-program in auto-code-builder for executing or debugging packages or package bodies * Added data type to object browser table and view columns * Added check for anonymous blocks on compile Build 133: ----------------------------- * Fixed weird characters showing on result of database search * Fixed menu entry Rename Tab not enabled under some circumstances * Fixed problem when hitting tab twice in a row, or after escape * Problem compiling object that included the % symbol - fixed * Added option to show only users with accessible objects * Updated Help file Ver. 2.6: -Added SQL Worksheets -Fixed objects missing in code list -Fixed problem with uppercase names on tabs -Added SQL Library -Update Help File Ver. 3.0: -Added Table Browser (with insert, update and delete) -Added ability to change font for Grid (Table Browser/SQL Worksheet) -Updated Help File -Performance update for SQL Worksheets -Added elapsed time counter to SQL Worksheets -Added Refresh, and record navigation to SQL Worksheet -Fixed problem with auto-sizing grid -Updated auto-connect mechanism -Logon dialog now remembers last logon info on actual boxes, so simple "enter" will connect. -Added ability to view execution plans. Ver. 3.01: -Fixed problem with "watching" package global variables during debugging. -Fixed problem with "watching" normal variables under Probe Ver. 2.1 or below. -On occasions after opening and closing multiple tabs, the keyboard focus would get lost. Ver. 3.02: -Fixed scrollbar painting when resizing sql worksheets. -Fixed problem with "watching" package body private global variables during debugging. Ver. 3.1: -Fixed problem with large anonymous block being executed with parameters -Fixed field lengths in Object Browser for table objects -Added position of caret when error is encountered -Save as was not working occasionally or not suggesting correct name -Line number showing when DDL statement in grid -Fixed problem with scrollbar not occasionally showing in table browser -Fixed problem with "desc" when tables included user defined types -When saving file as, tab caption was not updated -Grid is now properly resized after erroneous sql statement -Added table columns to Source Browser -Added null qualifier to object browser -Added ability to print grid for sql worksheets and table browsers -Added ability to save grid results to csv file -Right click menu on grid for easy access to common functions -Added record viewer for sql worksheet and table browser -Table Browsers are now also saved as part of workspace -Added ability to control the sorting of sub-programs for packages in source browser -New feature to executed only selected portion in SQL Worksheet (Ctrl+F10) Ver. 3.11: -Fixed problem with accessing object columns in an Oracle 7.x server Ver. 3.12: -Fixed problem with debugging 8.0.x databases -Fixed problem with modifying variables values while debugging package bodies Ver. 3.2: -Fixed problem with tool freezing when typing after "double" remarks on large packages -Automatic addition of ' (single quotes) in filters -Fixed problem with parsing object name when script included CREATE or REPLACE clauses -Fixed location of edit window in Execute Dialog -Added some missing keywords to standard list -New feature that allows to compare db object with editor object in case it is modified on the DB -Desc of tables with NCLOB included length, fixed -When reloading object, OraEdit now remembers the last location of the cursor -Fixed tool freezing if execute sql click twice in a row before first execute actually started -When clause on triggers was not being retrieved from database on object editor -Added ability to remove entries from login dialog -Add Source browser to View menu -Fixed problem when re-creating existing object, duplicate entry in source browser -Fixed line numbers when displaying some errors in triggers -When pasting into sql worksheet insert statements are now parsed correctly -Fixed "Fetch truncated" error when opening table browser under certain circumstances -Fixed format problem when prinitng compare results that spanned more than 2 pages -Added column names and types under views in source browser -Fixed problem with code list not dissapearing when typing -Function prototype now displays properly within package body for newly created functions in package header -Added * marker to "dirty" tabs for easier reference -New feature to see view data in browser grid -Fixed tool freezing when double-clicking on a table after multiple tabs had been opened and closed -Added strong encryption to database passwords in registry -When clause was not displayed for triggers -Columns are now displayed in code list for SYS and SYSTEM public views on selects using aliases -Problem when searching database after it had been disconnected for a second time, crash fixed -Added prototype tips for oracle standard functions Ver. 3.21: -Fixed some Oracle 7.x issues with dbms_output Ver. 3.22: -Fixed AND/OR location in Filter page when adding multiple conditions -Minor memory leak fixed -Fixed increment problem when selecting sequence's nextval in SQL Worksheet Ver. 3.23: -Fixed core dump when visiting Export utility if logged on to user without any objects -Fixed variable parsing issue for function cursors -Register dialog includes license number for ease of use -Hitting enter on Keyword settings add keyword if available - ease of use -Fixed limit in length of usable database alias -Search results screen now automatically shrinks to fit results Ver. 3.3: -Added full support for Oracle 9i data types -XP Style menus for ease of use -Change Error reporting in PL/SQL windows to allow copy/paste -New Favorites Menu to quickly access most used objects -Fixed problem when running script which included running files if comments were present -Comment selection was "over" commenting an extra line if whole lines were selected -Grid auto-format filter made smarter regarding functions, keyboards and strings -Added "Set Define Off" feature to SQL Worksheet to prevent parameter pop-up screen (in right-click menu only) -Changed execute error reporting style in Edit window to dialog to allow copy & paste of errors -Fixed problem with "Send to SQL" with misplaced & and missing &'s for parameters -When opening Find in DB it now auto-displays selected text Ver. 4.0: -Added option to connect as SYSDBA and SYSOPER -Expanded SQL Library capacity -Added PlimWare licensing options -Fixed problem with Oracle 10 and tables using keywords as column names in Table Browser -Added option to generate DDL and DML scripts from tables/records -Fixed issue with running multiple single line statements like truncate terminated with a new line and / character -Added support for objects with mixed-case naming and/or names with special characters or keywords -View Record now works without having to select a record when a single row is returned -Filter page doesn't add ' (single quotes) for functions or keywords upon AND and OR -Fixed crashes due to lines over 4,000 chars -Added option to drop a table column directly from the Source Browser -Fixed compare bug for package bodies -Resolved memory leak in Export