|
 Benthic SoftwareGolden History
|
Home
Golden32 History:
Version 5.7 Build 452 - September 4, 2007
. Fixed: Fixed a problem connecting if your password contained certain characters (like '@'.)
. Fixed: Fixed a bug related to opening an sql file as a workspace.
Version 5.7 Build 450 - July 13, 2007
. Added: Added NOT NULL information to table details in the SQLBuilder. Note: If table
details are slow to display, change the "Column information" option in the
SQLBuilder options page to "Columns only".
. Added: Added new option "Prompt vars match SQLPlus behavior". If this option is
checked then you will be prompted multiple times for matching prompt var
names in a statement.
. Added: Find option to the cell text viewer (Ctrl-F with text viewer showing or
Find on the right click menu.)
. Added: New button for "Run single statement" on toolbar.
. Added: Support for the HIDE keyword on the ACCEPT command.
. Fixed: Fixed a problem with using "/@database as sysdba" in the login window
and also in the CONNECT script command.
. Fixed: Fixed a script parsing bug related to wrapped constant strings.
. Fixed: Fixed a problem describing remote public synonyms.
Version 5.7 Build 449 - March 7, 2007
. Fixed: Fixed a problem with "Large fonts" system setting.
. Fixed: Fixed a problem with bind variables in 'explain plan' statements.
. Fixed: Fixed an issue where deleting records in the grid could complain that
the record had been changed by another user.
Version 5.7 Build 448 - February 15, 2007
. Added: Hovering the mouse over a tab will now show its full filename in a hint.
. Added: Added a start menu link for the HTMLHelp version of the help file if you are using Vista
(which doesn't support the old WinHelp help file version.)
. Improved: Fixed some minor interface issues for Windows Vista. Please report any problems!
. Fixed: Removed recyclebin objects from the SQLBuilder.
. Fixed: Fixed a script parsing bug.
. Fixed: Error using the Tools menu if logged in 'as sysdba' or 'as sysoper'.
Version 5.7 Build 447 - June 7, 2006
. Added: Added new EXPORT script statement option of CSV. Usage is:
SELECT * FROM EMP;
EXPORT CSV "FILENAME";
. Added: Added new option 'Export Nulls to Excel' which will export null strings
as NULL values instead of empty strings. This affects sort order of
the values in Excel as empty strings will come first and nulls will come
last.
. Improved: CSV export workaround for a bug in Excel when importing CSV files where the first two
characters of the file are ID (Excel assumes SYLK format in this case.)
. Fixed: Problem with XMLType fields in select statements.
. Fixed: DBMSOutput window wasn't disabling the output buffer when closed.
. Fixed: Records affected message wasn't being shown for MERGE statements.
. Fixed: Script bind variables of type CLOB weren't being handled properly.
. Fixed: SQLBuilder now properly shows columns for 'V$*' system views.
Version 5.7 Build 445 - November 29, 2005
. Fixed: DBMS_Output text could be truncated on multibyte characterset databases.
Version 5.7 Build 444 - October 6, 2005
. Fixed: Added 'Autosize Titles Only' to saved autosize options.
. Fixed: Script parsing issue with EXEC calls on multiple lines.
. Fixed: Minor performance improvement for querying Oracle 8 servers.
. Fixed: Small memory leak when a SQLBuilder thread finished after a new object
had already been clicked.
Version 5.7 Build 442 - February 28, 2005
. Added: Added support for dbms_output to spool files. Use "set serveroutput on" to turn
this on.
. Fixed: Grid wouldn't scroll left or right when using Shift-left/right to block select.
. Fixed: Fixed a rare problem with the SQLBuilder's column display and multi-byte character sets.
Version 5.7 Build 441 - February 11, 2005
. Fixed: The column information retrieval in the SQLBuilder was querying for key and index
information even if 'Columns Only' was set in the 'Column Information' option.
. Improved: Placed an upper limit on the number of folders allowed in the Favorites menu.
This fixes a rare problem where Golden would freeze on startup if the favorites
menu was too large or had a circular reference (Golden's favorites menu will
follow directory shortcuts which could cause a circular reference.)
Version 5.7 Build 440 - January 25, 2005
. Fixed: Fixed some remaining popup dialogs that would appear offscreen if the main window
was partially or fully offscreen.
. Fixed: Fixed a bug when running explain plan while the grid was in transpose mode.
. Fixed: Fixed a 'could not find oci.dll' problem with the Oracle 10g Instant Client.
. Fixed: Fixed connection diagnostics not showing if no Oracle client was detected.
Version 5.7 Build 438 - December 7, 2004
. Fixed: Fixed a different 'Index out of bounds' error when running some script files.
Version 5.7 Build 437 - December 3, 2004
. Fixed: Fixed an 'Index out of bounds' error when opening some script files that contained
tab characters and multi-line comments.
Version 5.7 Build 436 - November 24, 2004
. Improved: Improved the column editor window of ImpExp.
. Improved: Explain Plan output has been improved with more information in Oracle 9+.
. Improved: Explain Plan columns that have no data are removed from the plan (for example
queries on tables without partitions won't show partition information.)
. Improved: Scaling of numbers in the Explain Plan output have been improved to more closely
match Oracle's dbms_xplan package output.)
. Fixed: Fixed problem of spreadsheet scrolling to selected cell if the Alt key was pressed.
. Fixed: Some minor bug fixes to the editor.
Version 5.7 Build 434 - August 6, 2004
. Added: Added support for new "Easy Connect" naming method of Oracle 10.
i.e.: [//]host[:port][/service_name]
which needs no TNSNames.ora file so it's especially useful with the new "Instant Client"
. Fixed: Editor was discarding trailing spaces on lines in some conditions.
Version 5.7 Build 433 - August 3, 2004
. Fixed: Fixed a parsing bug related to DEFINE statements and -- type comments.
Version 5.7 Build 432 - August 2, 2004
. Added: Support for COLUMN XXX NEW_VAR YYY SQLPlus command to store a column value into a
prompt variable. Note that Golden can also do this using the Define command
mentioned in build 412 below but it is not SQLPlus script compatible.
. Added: Now Database Aliases from TNSNames.Ora will be included in the drop down database
list on the Login window. There are new options to turn this off and not have
the names lowercased on the login options window. You can also edit the list
there (note that this only affects the list, not TNSNames.Ora.)
. Improved: Golden now handles the Print command with a colon before the variable name since
SQLPlus also allows this.
. Fixed: Usernames containing '-' were being forced to be case sensitive. This has been fixed.
. Fixed: Fixed some parsing bugs when trying to edit tables where the SQL has quoted table
names and owners (i.e. SCOTT."Emp")
. Fixed: Fixed a parsing bug when trying to edit a query where a comment appeared with a
'from' keyword inside it before the 'real' 'from'.
. Fixed: Golden was attempting to handle nested comments of /* */ style and SQLPlus doesn't
allow this so we were getting minor parsing differences.
Version 5.7 Build 430 - June 9, 2004
. Fixed: Tab character wasn't being considered a separator when double clicking a word.
Version 5.7 Build 429 - May 26, 2004
. Fixed: Synonyms with DBLinks that point to public synonyms now show detail information in
the SQLBuilder.
Version 5.7 Build 428 - May 21, 2004
. Added: Readonly mode can now be forced by having a file called "readonly.lic" in the same
directory as the Golden32.exe application. This probably only makes sense in situations
where the user can't delete this file (i.e. running from a readonly network directory.)
Note that this is just one of the ways to force Golden into read only mode (please let
us know if you would like the documentation for the various readonly mechanisms.)
As always the best way to enforce rights is using Oracle's own grant/privilege system.
. Added: You can now ignore errors in statements using:
set errors off
or
whenever sqlerror continue
you can turn errors back on using
set errors on
or
whenever sqlerror exit
(note that exit was used for SQLPlus compatibility and Golden won't exit if it
encounters an error, it will just show the error as usual.)
. Added: Ctrl-Clicking items in the SQLBuilder will now always perform a paste.
. Fixed: Synonyms that point to DBLinks now show detail information in the SQLBuilder. Note
that synonyms that have DBLinks that are private to another schema will not show
detail information.
. Fixed: SQLBuilder option "Add table name to column on paste" is now working.
Version 5.7 Build 427 - April 14, 2004
. Fixed: Queries with VArray columns would fail with a typecast error.
Version 5.7 Build 426 - April 9, 2004
. Fixed: Power Users (users with 'Select any table') wouldn't see all of the available
schemas in the SQLBuilder's 'All objects' tab. This now defaults to show all
schemas with accessible objects. If this is slow then you may want to set the
'Userlist Performance' option to 'All Users Fast Query'.
Version 5.7 Build 425 - April 8, 2004
. Fixed: Double-click word selection wasn't honoring word delimiters.
Version 5.7 Build 424 - April 5, 2004
. Improved: Changes to keep from picking up 'stray' tnsnames.ora files.
. Fixed: Selecting range of cells in the spreadsheet using the Shift-Arrow keys now
keeps the current cell in view.
Version 5.7 Build 423 - March 29, 2004
. Fixed: Some operations (i.e. Replace and Paste) weren't scrolling the caret into view.
Version 5.7 Build 422 - March 26, 2004
. Improved: Added more statement descriptions to statusbar and log (i.e. "Commit succeeded")
. Improved: Changed the text and added a lookup button for OCI DLL on the Login Options window.
. Improved: Changed the error message on explain plan failure to include the Oracle error
message and to include a note about putting the cursor inside the statement
to be explained.
. Fixed: A problem with canceling queries not showing the partial results.
. Fixed: A problem with canceling statements that could cause an "Access violation" message.
. Fixed: A problem with REFCURSORS that could show an "Invalid argument" error message.
. Fixed: Choosing some of the right-click menu paste options of the SQLBuilder wouldn't
set the focus at the end of the text when 'move focus on paste' option was checked.
. Fixed: REM was being syntax highlighted even if it wasn't the first word in a line.
Version 5.7 Build 421 - March 11, 2004
. Added: New SET option called RECORDLIMIT. This is a 'script' way to set the number
of records that will be returned at maximum for the current tab. A value
of -1 means unlimited.
i.e. SET RECORDLIMIT 2000 or SET RECORDLIMIT -1
. Fixed: Fixed a parsing issue with 'local' statements followed by line comments.
i.e.: set echo on -- setting echo on!
. Fixed: Fixed a problem with Explain Plan if server was version 9 and client was pre-9.
Version 5.7 Build 420 - March 8, 2004
. Added: New option "Don't backup workspaces" to stop Golden from keeping the three
historical workspace backups *.bk1-*.bk3.
. Fixed: In transposed mode it was possible for columns to be wider than the entire grid
and therefore impossible to resize.
Version 5.7 Build 419 - March 2, 2004
. Added: The ability to ignore columns in the source file when importing data using
ImpExp (Golden's import/export tool.) Here are the instructions from ImpExp's
help document:
This version adds a button with an 'X' on it that adds '-- IGNORE --' to
the column list. You have to click the add button and then drag the IGNORE
item to the correct position in the columns. The column list on the left side
must have the same number of items as columns in the source file so you need
IGNORE items for each column that you want to skip in the source file.
. Improved: The keyword list has been improved with many more keywords. The keyword
list in the options now only holds added keywords. You can also remove
keywords by prefixing them with "-" (i.e. -SELECT)
. Improved: The SQLBuilder now shows package/type methods as well as arguments.
. Fixed: Describing packages with overloaded functions and procedures of the same
name would cause an error message.
. Fixed: Copying a row from the grid while in edit mode would include the ROWID.
Version 5.7 Build 418 - November 17, 2003
. Improved: Improved the explain plan output and error reporting.
Note that if you have 'Show explain plan as text' checked and use Oracle 9.2
it will show the output using the new dbms_xplan package.
. Added: Added a new option called 'Show alternate unsaved indicator'. Checking this
option causes the unsaved tabs to show a small circle on the lower right side
instead of just turning the caption red (which was a problem for colorblind
users.) This options is on the 'Tabs and Windows' page.
. Fixed: Couldn't change the alignment of the last column in the spreadsheet.
Version 5.7 Build 417 - October 3, 2003
. Improved: Improved object detail performance in the SQLBuilder when objects have a
lot of constraints and indexes.
. Improved: More detailed performance information in the connection diagnostics window.
. Added: 'Copy Results' options now include 'Copy Titles Only (tab delimited)' and
'Copy Titles Only (comma delimited.)
. Added: New right click menu when right clicking spreadsheet header columns. Now there
are 'Align Left', 'Align Center' and 'Align Right' options. This cleans up the
old toggle feature and allows us to add new 'column' level features in the
future.
. Added: New right click menu for the upper left spreadsheet cell with Autosize options
(also on the standard spreadsheet right click menu and 'Results' menus.) New
Autosize options for 'data and titles', 'data only' and 'titles only' without
having to go to the options window.
Version 5.7 Build 415 - September 23, 2003
. Improved: More performance information in the connection diagnostics.
. Improved: Now using USER_CONSTRAINTS lookup when possible to help with performance
problems in the ALL_CONSTRAINTS system view. If table object detail
performance is slow and the cause is the constraint lookup contact us for
a fix involving adding a new system data dictionary view. Connection
diagnostics now gives a breakdown of the performance for object details.
. Improved: SQLBuilder object list performance for large schemas. (i.e. pulling
in 10,000 tables is now 2-3 times quicker in most cases.)
. Improved: Improved object detail performance if setting "Column Information"
is set to "Columns Only"
. Improved: Window for prompt and pause messages now remembers its position.
. Improved: Now doing a spreadsheet column autosize before showing the pause or prompt
windows.
. Fixed: NUMBER datatypes with no precision and 0 scale are now correctly shown as
NUMBER(38) instead of just NUMBER in DESC and the SQLBuilder.
. Fixed: NCHAR and NVARCHAR2 types will now show their correct length in DESC and in the
SQLBuilder.
. Fixed: Right clicking pk, fk, and index column headers in the object detail sqlbuilder
window wasn't working if the window was horizontally scrolled.
. Fixed: Error if SQLBuilder keyword list was empty.
Version 5.7 Build 412 - August 15, 2003
. Added: The column detail list of the SQLBuilder will now show foreign key constraints.
. Added: Right clicking a Primary Key, Foreign Key or Index column header in the object
detail list of the SQLBuilder will show the DDL statement for that constraint
or index. (i.e. right click the 'PK', 'FK', 'UX' or 'IX' header text.)
. Added: You can now assign bind variable to prompt variables.
REM Here's a cool example!
REM Declare a bind variable.
var BindSpoolFilename string;
REM Run a pl/sql block that fills the bind variable with a filename including
REM the current date.
begin
select 'c:\spoolfile'||to_char(sysdate,'yyyymmdd')||'.log'
into :BindSpoolFilename
from dual;
end;
/
REM Define a prompt variable and set it to the value of the bind variable.
define SpoolFilename = :BindSpoolFilename;
REM Create a spool file with the computed name.
spool &SpoolFilename;
select * from tabs;
spool off;
. Improved: Showing column details (after clicking a table, view or synonym)
in the SQLBuilder was not being run in a background thread. This has
been fixed and should also be faster than earlier versions.
. Improved: Optimized data dictionary queries used by the SQLBuilder.
. Fixed: Headers and footers now work for printing SQL.
. Fixed: Doing a find & replace of "\n" with "\r\n" (replacing a linefeed with a
linefeed/carriage return pair) would cause a null character to get inserted
in some cases.
. Fixed: Error if var statement was used to redefine a cursor that was currently
displayed in the spreadsheet.
Version 5.7 Build 410 - July 17, 2003
. Fixed: Problems with printing transposed results.
. Fixed: Problem with exporting large result sets to Excel if the user
switched to Excel before the export was complete and changed active
worksheets.
Version 5.7 Build 409 - July 2, 2003
. Added: Cell detail window popup from the scratch results window.
. Fixed: The scratch results window now shows moved columns correctly.
. Fixed: The header font of the scratch window wasn't being set properly.
. Fixed: popup menu on the scratch results window.
. Fixed: Autorun from the favorites menu failures causing tab to lock.
Version 5.7 Build 408 - June 25, 2003
. Fixed a problem with copying data out of the spreadsheet if columns had been moved.
. Now transposed data can be exported to excel and csv files.
Version 5.7 Build 407 - June 17, 2003
. Fixed a problem with the text viewer where it wasn't displaying various line break characters
properly in the Text mode.
Version 5.7 Build 406 - June 16, 2003
. Fixed a problem with handling different character sets in the editor and spreadsheet
font settings.
Version 5.7 Build 405 - June 12, 2003
. Spreadsheet Columns can now be re-ordered by selecting them and then dragging
them to the new position.
. SQLBuilder Changes:
Added option called 'Single click keywords and columns' which is on by
default. Turning this off makes it so that you must double-click
keywords and columns in the SQLBuilder to paste them. This is better
for people who use the keyboard instead of the mouse for the SQLBuilder
and also cuts down on accidental pastes while just trying to scroll the
various lists. This may become the default (double-click to paste) in
the next version. Please let us know if you have strong opinions on this!
Added option called 'Move focus to editor after paste'. This option is off
by default.
Improved keyboard handling for all SQLBuilder controls.
. Added Shift-Arrow selection handling to the scratch window.
. Improved Connection Diagnostics information.
. Fixed situations where popup windows would display off the screen.
. Fixed a problem where the SQLBuilder wouldn't work with default logins.
. Fixed a problem with the spreadsheet scrollbar if 'clear on script run' was on.
. Fixed a parsing bug with queries in edit mode containing ''.
. Fixed a DESC[ribe] bug with spaces before the statement terminator.
Version 5.7 Build 402 - May 7, 2003
. Fixed a problem where changing the font options wouldn't save as defaults.
Version 5.7 Build 401 - May 6, 2003
. Fixed a problem where a parsing error could make a tab stop responding.
. Fixed the SQLBuilder's search function so that searching will 'wrap' when it reaches
the top or bottom.
. Enabled incremental searching on the SQLBuilder trees.
Version 5.7 Build 400 - May 5, 2003
. Added a 'Change Password...' item under the File menu.
. Added support for TIMESTAMP, TIMESTAMP WITH TIMEZONE, INTERVAL YEAR TO MONTH,
and INTERVAL DAY TO SECOND datatypes.
. Greatly improved Golden's ability to run multiple long scripts without
affecting each other.
. Added Enter and Shift-Enter to the SQLBuilder searching keys (along with the
up/down keys and buttons.)
. Reduced the memory used by the option objects.
. Reduced the memory used by datasets (and improved speed)
. Vastly improved SQLBuilder with unlimited objects and much faster handling.
. Changed keyboard control of SQLBuilder slightly. Use shift-arrows to move through
object list without refreshing the column information when desired.
. Fixed a problem where functions outside of packages would be DESCribed as procedures.
. Fixed a problem when copying spreadsheet results when in transpose mode.
. Fixed the problem where second instance would start when loading .sql file from
Windows Explorer.
Version 5.6 Build 387 - October 2, 2002
. Added the script statement "EXPORT EXCEL" which will export the current spreadsheet
results to Excel.
. Fixed a slow logon problem for databases with a large number of users.
Version 5.6 Build 386 - September 18, 2002
. Fixed a problem where Golden wouldn't use the dba_ views for lookups.
. Fixed a bug related to importing data containing multiple field qualifiers in a row.
Version 5.6 Build 385 - September 10, 2002
. Fixed a parsing bug related to trailing '--' type comments on the delimiter line.
. Fixed a problem with statements containing multiple single '&' prompt variables
after a '&&' define of the same variables.
(i.e.: select '&&fish', '&fish', '&fish' from dual;)
Version 5.6 Build 383 - July 23, 2002
. Added handling for changing your password if it has expired (Oracle 8+ feature.)
. ImpExp will not allow importing if the DBA has set the users mode to READONLY.
Version 5.6 Build 382 - July 2, 2002
. Added a 'Read Only' checkbox to the login window. Sessions marked read only
can only run select and exec statements. Note that it is also possible for a
dba or system administrator to force all users or specific users to read only
mode. Please let us know if you would like this information. As always, the
best way to enforce user rights is with Oracle's own grant/rights system.
. Added a new 'Find in results' option to the Results menu. Note that currently the search
goes left to right and top to bottom. More options to come!
. Added support for the commands:
SET FEEDBACK ON/OFF -- Turns off feedback in spool files
SET HEADING ON/OFF -- Turns off column heading info in spool files.
This is useful if you want to make a spool file of dynamically generated SQL statements.
Here is an example:
REM Script to create analyze table statements
set feedback off
set heading off
spool c:\spool.txt;
select 'analyze table ' || table_name || ' estimate statistics;' from tabs;
spool off;
REM And then execute the spool file using:
REM @c:\spool.txt;
. Fixed a problem opening files on machines with the Netware client installed.
. Fixed a problem where select statements that started with an open parenthesis
wouldn't parse correctly.
. Fixed a problem where 'Find again' was disabled.
. Fixed a problem where an open workspace would be mistakenly marked as modified.
. Fixed a problem where it was possible to move 'pane splitters' so that they couldn't
be moved again.
Version 5.6 Build 375 - March 18, 2002
. Fixed a bug related to running statements that didn't return any records after
setting the spreadsheet to transposed mode.
. Added shift-keyboard selection handling back to the spreadsheet (accidently removed
in an earlier update.) Now Shift-PageUp/PageDown/Home/End should work correctly.
. Changed pasting into the spreadsheet during edit mode. When pasting into a single record
the focused cell will not change. Whe pasting into multiple records the current cell
will move to last record pasted but stay at the current column position.
Version 5.6 Build 374 - February 20, 2002
. Fixed a very minor parsing bug.
Version 5.6 Build 373 - February 14, 2002
. Changed the parsing so that it now allows white space or '--' style comments
after the ';' at the end of an SQL statement (on the same line.)
. Put back the hotkey options for Golden, PLEdit and Goldview on the Tools menu.
Version 5.6 Build 372 - February 13, 2002
. Fixed a parsing problem with build 370 related to whitespace at the end of a script.
. Fixed a problem where build 370 wouldn't allow edit mode on a synonym.
Version 5.6 Build 370 - February 11, 2002
. New menu system and toolbars. Favorites menu will now scroll if it doesn't fit onscreen
even for Windows 95.
. Improved the DESC[ribe] command to include describing packages.
. You can now edit queries containing more than one table. Note that you can only
edit the columns from the first table in the FROM list. If the query results contain
more than one column with the same name as a column in the edit table that the first
one in the list will be used for that column.
(Alternate wording: Be aware that if the results contain multiple columns with the
same name that are in the edit table's column list then the first one in the result
set will be used to edit that column in the edit table.)
Columns that can't be edited are shown in red text. The edit table is now shown on
the edit spreadsheet's toolbar.
. Added 'Export to CSV' and 'Export to XML' to the Results menu.
. Added the ability to login as SYSDBA or SYSOPER. To do it just add ' AS SYSDBA' or
' AS SYSOPER' to your login name. The Conn[ect] command also supports this.
. Removed the 'Character Set' setting from the options. You can now set
the character set of the editor and spreadsheet using the font 'script'
settings on the font selection window.
. Added the option 'Ignore this error for rest of script' to the error window.
. Greatly improved the script parsing speed (noticeable on scripts > 5000 statements.
. Added a 'Rename Tab' command to the popup tab menu.
. Fixed a problem where user would be prompted to save workspace even if it didn't
need saving (under certain conditions.)
. Fixed problem with describing objects with dblinks containing '.'.
. Fixed a problem with Tabs as Spaces and block indent.
. Fixed a problem with clipboard operations on the find/replace windows.
. Fixed a problem where spool to file data wasn't aligned properly.
. Fixed a problem where you couldn't use the Page Setup window to change the spreadsheet
print title unless you were viewing the print preview.
Version 5.5 Build 362 Production - July 18, 2001
. Fixed a problem when pasting data into the insert row after already typing in some
data on the row.
. Fixed some problems with the export to Excel feature:
. Text fields are now formatted as 'Text' in Excel instead of 'General' which would
convert text that looks like a number (i.e. '0000' to 0)
. Fields with data over about 800 characters would cause Excel to crash. Fixed by
moving data containing large strings cell by cell which takes longer.
Version 5.5 Build 361 Production - July 3, 2001
. Fixed the popup menu for the dictionary object tree on the SQLBuilder.
Version 5.5 Build 360 Production - June 27, 2001
. Fixed a bug when using the SQLBuilder set for lowercase tablenames.
Version 5.5 Build 359 Production - June 25, 2001
. Fixed some problems with editing tables with non-standard table/field names.
. Fixed some problems with ImpExp related to tables with non-standard table/field names.
. Added some new choices to the SQLBuilder right click menus.
. Golden can now export data directly to Excel! Just use the 'Export current spreadsheet
contents' menu item off the 'Results' menu.
. Fixed a problem with the caret position when scrolling in certain conditions.
. Fixed a problem where having a single or double quote in a comment might be flagged
as an unterminated string.
Version 5.5 Build 356 Production - April 26, 2001
. Now Golden will try to select a word at the current error position (if you have an
error in your SQL statement.)
. Added support for SPOOL and SET ECHO ON/OFF SQLPlus commands.
SPOOL FILENAME
Will copy results and timings to a text file. If the filename contains
spaces enclose it with double quotes (i.e. SPOOL "C:\MY FILES\MY SPOOLFILE.TXT"
SPOOL OFF
Turns off spooling and closes the spool file.
SET ECHO ON/OFF
If ECHO is on then commands are placed in the spool file before the results.
. Removed script error reporting for unsupported SQLPlus commands that can safely be
ignored (i.e. BREAK.) Note that warnings for these commands will appear in the log.
. Fixed a bug where the 'Use favorites directory as default directory' option wasn't working.
. Fixed some parsing bugs with the '@' and 'START' commands. Note that you have
to surround filenames with spaces with double quotes.
i.e. @"C:\BENTHIC SOFTWARE\FISH.SQL" PARAM1 PARAM2
. Allow partial paths in @ or START commands
i.e. @"SQL\FISH.SQL" PARAM1 PARAM2
will use current directory or favorites directory as root depending upon what setting
you have for 'Use favorites directory as default directory' Note that current directory
changes every time you load or save a file.
Version 5.5 Build 352 Production - March 6, 2001
. Fixed a bug where only the last page of a print job would print if you choose to print
a range of pages.
Version 5.5 Build 351 Production - March 1, 2001
. Fixed a problem where running an explain plan would cause an error on the next script run.
. Changed the SQLBuilder so that it can't interfere with queries running in public tabs (and
vice versa.)
. Fixed the table column lookup in the SQLBuilder to include the RULE hint.
Version 5.5 Build 350 Production - February 20, 2001
. Fixed a problem where default column values wouldn't be used for inserts
in editing mode.
. Added 'read after insert/update' to editing mode so that you can instantly
see what the record looks like after it gets posted to the database
(it may have been affected by default values or triggers.) Please let us
know if you find any problems with it! -- support@benthicsoftware.com
. Greatly improved the ability of Golden to cancel running queries!
. Added the ability to handle multiple REFCURSOR bind variables in a statement.
Note that the refcursor displayed by default is the first one in the statement.
. Added a menu called 'Results' which lets you clear the spreadsheet and to
choose any REFCURSOR bind variable to view in the spreadsheet. Note that you
can use the 'Show last query results' menu item to go back to the last query
results after viewing a cursor.
. Added a menu item called 'Connection Diagnostics' to show some information about
the Oracle client and database.
Version 5.5 Build 347 Production - January 24, 2001
. Fixed a bug in Build 346 which removed support for the commands SET ROLE,
SET TRANSACTION, SET CONSTRAINT(S)
. Got rid of the screen flash when creating and switching tabs.
Version 5.5 Build 346 Production - January 18, 2001
New Features:
. Golden will now allow you to edit multi-byte character set databases.
. Completely rewritten printing system.
. Improved print preview to include headers/footers for text and spreadsheet.
. Added new 'Print line number' option for SQL printing.
. Allow printing of page ranges and selected code.
. Cleaned up the DBMS_Output window and added an 'Enabled' switch. Removed the 'Reset'
button (just click 'Enabled' twice.)
. This version adds support for the following SQLPlus commands (with some caveats):
ACCEPT: Currently ignores the 'format' clause and 'datatype' clause.
DISCONNECT: This will return an error if the tab is public.
PAUSE: Note that this command could put up a dialog box from a tab that
you are not currently viewing.
PROMPT: Note that this command could put up a dialog box from a tab that
you are not currently viewing.
SET SCAN OFF/ON: Turns off/on scanning for prompt variables '&, &&' Full
support but this command is list as obsolete in the latest version of
SQLPlus. Replaced by SET DEFINE ON/OFF
SET DEFINE OFF/ON: Same as SET SCAN
. Golden will now handle abbreviated commands for all SQLPlus commands.
. New option to set file extension used for workspace files (on the 'File filters and
extensions' page.) Now all file extensions used by Golden can be customized!
. Can now set the file extensions of files that will appear in the Favorites Menu.
. The favorites menu can include directory shortcuts, so you can put a shortcut
to another directory (say, on the network) in your favorites 'tree' and the files
in the directory that the shortcut points to will be included on your favorites.
Fixes:
. Fixed a problem with SQLBuilder's primary key display.
. Lots of improvements to the way workspaces are handled.
. Fixed a problem where choosing to replace the current sql when using the SQLBuilder
would remove the undo information from the editor.
Version 5.5 Build 342 Production - November 15, 2000
. Added an option to limit the size of BLOB (and LONG RAW) data (default is to not
retrieve any BLOB data.
. Added the ability for ImpExp to handle BLOB (and LONG RAW) data (data is converted
to HEX strings.)
. Fixed a rare problem with number() datatypes giving a 'data was truncated' error.
. Fixed a problem updating rows that contained full precision number values in edit mode.
. Improved and optimized the SQLBuilder's primary key and index information query.
Version 5.5 Build 340 Production - October 27, 2000
. Improved the text explain plan output so that plans will no longer be truncated.
. Added an option called 'Use simple plan output' to show the 'old style' plan. If
you don't have a newer version of the plan_table, you'll have to use the simple
plan.
. Added a new section to the help file that is all about the Explain Plan output!
This section was graciously supplied by Keith Wood.
. Fixed a bug where changes to the page options on the print preview window
would not be used for printing.
. Added an option called 'Remember SQLBuilder Open Status' to the SQLBuilder
options. Checking this will make the SQLBuilder open on startup if it was
open when the program was last closed.
. Fixed a problem when 'explain plan' statements contained prompt variables.
. Removed 'prompt' times (waiting for user input) from the script and statement timings.
Version 5.5 Build 339 Production - October 16, 2000
. Fixed a printing problem where the footer text would be off the bottom of the
page on some inkjet printers.
. Added an option to the Tabs & Windows option page to allow the tabs to be
'stacked' (all the tabs appear on multiple rows instead of one scrolling
row.)
. Changed the 'Columns' list of the SQLBuilder to a listview showing column
index, name, datatype, primary key and index information. Abbreviations
are 'P' for Primary Key, 'U' for unique index and 'I' for nonunique index.
There is a new setting on the SQLBuilder option page to specify what to show.
You can click the column headers to sort (click the same one again to reverse
sort.)
. Added an option to the SQLBuilder option page called 'Only paste when Ctrl
is down' If this is checked, you must hold the Ctrl key down when double-
clicking a table, or single clicking a column to paste the text into the
current SQL Tab.
Version 5.5 Build 337 Production - October 4, 2000
. Now by default Tabs will be created to the right of the currently selected
tab. This can be returned to the old setting (create new tabs at the end
of the tab list) using the setting on the new Tabs and Windows option page.
. Added the ability to reorder and rename tabs. Just right click in the tab
and you will see a list of tabs that can be edited and ordered. You can
drag and drop in the list or select one and click the up/down or edit
buttons.
. Modified the handling of pasted records into the spreadsheet in edit mode:
. Fixed a very slow index column lookup query when starting edit mode.
. Got rid of the 'You need to refresh the query to updated inserted records'
restriction. If you insert a row and see the message 'Could not get
ROWID after insert' please let us know (support@benthicsoftware.com)
. Fixed a problem with pasting in records to the insert line when the SQL
includes the ROWID (complained about data not fitting the # of cols.)
. Removed the restriction on pasting in inserts that aren't complete records.
. Allow you to paste inserts at any column position (used to force the first
column to be selected.)
. Added a new option to the Editor options page. The option 'Allow cursor
past end of line' is checked by default. If you uncheck it, cursor movement
will be more like Microsoft's code editing products.
. Changed the 'Ignore Future Errors' checkbox on the error popup window to
read 'Ignore errors (for this run)' to signify that it is a temporary setting
that will reset at the next script run. Use the 'Ignore Errors' menu item
off the 'Script' menu to turn off error reporting for this tab (stays until you
close the tab or turn the setting off.) Also changed the display of the error
window so that it won't give the continue option if you are just running one
statement in a larger script.
. Explain plan improvements.
. Added an option called 'Show Plan as Text' on the general options page. If
this options is checked then the explain plan shows as plain text. If not
then the plan shows up in the spreadsheet.
. Removed the restriction that the explain plan can only work on a script
that has one statement (the plan will be for the statement at the current
cursor position (similiar to 'Run single statement at cursor'.)
. Updated the plan output using Oracle's example plan output script.
. Modified the color settings on a number of the windows to use the standard
system wide WindowsText color for fonts (it was using black which caused
obvious problems if you used a black window background setting.)
. Add Comment/Uncomment block command to the edit menu. This will add or remove
'--' style comments from each selected line.
Version 5.5 Build 330 Beta - August 28, 2000
. This beta release of Golden fixes a bug in build 329 that caused
single statements to not run (unless they had a rem before them, doh!)
. Added a single statement script to our test script list to catch this in the
future.
Version 5.5 Build 329 Beta - August 25, 2000
. This beta release of Golden is to fix an incompatibility
with Computer Associate's Innoculate Antivirus software.
. Added a 'Use alternate query for user list' option to the
SQLBuilder. Checking this option will use a slower but
more accurate query for the 'All Objects' user list.
. Fixed a parsing bug related to REM inside a statement.
Version 5.5 Build 326 Production - July 27, 2000
. Fixed a problem with the editor's right click menu.
. Improved the script parser's handling of comments.
. Added a way for companies to disable the password saving
feature (send email for details.)
Version 5.5 Build 325 Production - July 18, 2000
. Allow users to change the Open and Save dialog boxes file filter
settings (Open/Save File Filters page in the options.)
page in the options.
. Decreased the amount of memory used by datasets a bit.
. Fixed several minor sql parsing bugs.
. Made the editors select colors match the current user's
control panel color settings.
. Fixed a display problem when a single line in the editor was over
about 5000 characters (shouldn't happen very often!)
. Fixed a problem with the favorites menu if the menu directory
had spaces in it.
. Fixed a problem with filenames with multiple '.' characters.
Version 5.5 Build 324 Production - May 16, 2000
. Fixed a problem with the SQLBuilder where users with 'SELECT ANY
TABLE' system privilege wouldn't see all the other object owners
in the 'All Objects' pane.
Version 5.5 Build 323 Production - May 8, 2000
. Added the ability to limit the number of records returned from
select statements. The setting is on the General page of the
Options window. You can also set the value by clicking on the
middle 'status pane' that shows affected records. The status
pane message will be red and say something like 'Select stopped
after xxx records' if the limit was reached.
. Improved Golden's READ ONLY mode. Run Golden in Read Only mode by
starting it with -ro as a commandline parameter. There is also
a registry key that you can set to force read only mode (email
markford@benthicsoftware.com for details.) Read only mode removes
the data editing feature and stops any sql statement except select
and exec. Note that 'local' commands (like DESC) still run fine.
. The CONNECT command will now default to the current private or
public database (so you can leave off the @ part if you are already
logged in.) Fixed a case where CONNECT wouldn't run unless you were
already logged in.
Version 5.5 Build 320 Production - May 1, 2000
. The undo/redo information was being cleared each time a script
was run. This has been fixed.
Version 5.5 Build 318 Production - April 27, 2000
. Fixed a display problem with the float datatype.
. DBMS_Output window is properly reset when you re-login.
. Added keyboard cell selection in the spreadsheet. (shift+arrows)
. Now whenever a script is parsed Golden will trim any whitespace
characters from the end of all lines. This should solve the
'invalid character' error when statements have spaces and such
after the ';' character.
. Fixed a problem where the footer text would be cut off on printouts
to printers with wide non-printable margins.
Version 5.5 Build 316 Production - April 13, 2000
. Fixed not being able to update records (in edit mode) when field names
were longer than 26 characters.
. Fixed an error message when setting the spreadsheet to transpose mode
before running a query.
. Fixed a number of problems with the login window's quick list popup
menu actions.
. Fixed the hotkey display on the popup menu for 'Close Tab'
. Fixed accessing the file menu from a running tab.
Version 5.5 Build 315 Production - April 6, 2000
. Fixed a problem where user would see a pl/sql error reported
when running some types of queries (inline views.)
. Fixed printing problems if you made paper size changes right
before printing.
Version 5.5 Build 314 Production - April 6, 2000
. Fixed a bug when compiling triggers. Golden would try to bind
the :new/:old words.
. Added Printer Settings button to the page settings window
so that you can change the paper size and orientation.
. Fixed a bug when describing partitioned tables.
Version 5.5 Build 311 Production - April 3, 2000
. Mostly small bug fixes and changes from RC1.
Version 5.5 Build 310 Release Candidate 1 - March 27, 2000
Lots of changes!
Important notices:
. Note that your font settings for SQL text and spreadsheet text
will return to defaults when using this version. You will have
to reset them in the options window. True type fonts
print best!
. We are now using a third party grid component instead of our
homegrown one. The new grid is very powerful and will give
us the ability for new features down the road. One big difference
is that you must start with the mouse cursor at the left side of a
cell in order to click and drag a multi-cell selection. The cursor
will change slightly to indicate that you are in multi-cell
selection mode.
Printing:
. Hugely improved page setup window.
. Custom headers and footer on printouts.
. Much improved printing with previews of both SQL and spreadsheet.
. Ability to print spreadsheet without going through the preview screen.
. Ability to print SQL with syntax highlighting or as plain text.
Spreadsheet:
. Selection changes:
. You must click on the left part of a cell to start a multi-cell
drag selection.
. You may select multiple rows or columns. Use Ctrl-Click to select
discontinuous columns or rows.
. Edit mode changes:
. Paste multiple records when editing (both update and insert)
. Delete multiple records when editing.
. Full editing of CLOB and LONG values (used to have a problem once
longs got too big.
. Proportional scrollbars.
. View text viewer by double-clicking a cell (changed from Ctrl-Click)
. Right click column header to change alignment.
. Right click top-left spreadsheet cell (on header line) to autosize
visible rows. Shift-Right click it to autosize all rows.
SQL Editing:
. SQL Error position now shown for Net8.0.x clients!
. New bracket find and selection commands (Ctrl-B)
. Search and replace enhancements.
Interface:
. Program Options menu item moved to Tools menu (like Microsoft's apps.)
. Most recent files moves to bottom of file menu.
. New print buttons on the toolbar.
Connections:
. Disconnect menu item (under login) to disconnect from all databases
(allows leaving Golden running while database is restarted.)
. Better error handling when session is killed or disconnected.
Autoreconnect will be attempted (you will be notified since data
may have been rolled back.)
General:
. Slightly less memory intensive.
. Removed 'Update only changed fields' setting. It makes much more sense
to only update changed fields (as all other tools do.)
. Ignore Net8 option removed (not needed anymore!)
Version 5.5 Build 302 BETA - January 6, 2000
Fixed a bug where Golden would incorrectly detect bind variables inside
string literals.
Version 5.5 Build 301 BETA - January 4, 2000
Added 'How to' sections to the online help for:
'How to use prompt variables' and 'How to use bind variables'.
Added more support for Bind variables. They work very much
like the SQLPlus Bind variables. Please see the online
help section 'How to use Bind variables.' to learn more.
The Exec command now properly runs on a background thread.
Some minor Editor speed improvements.
When editing records with long floating point
decimal places Golden would complain that another user
had changed the record and disallow the edit. Fixed.
Added Ctrl-[ and Ctrl-] hotkeys which find the next matching
bracket character. Sort of like a single character
find feature, but for brackets it will find the matching
one.
Version 5.4 Build 299 - December 6, 1999
Fixed the Copy commands for the spreadsheet when it is set
for transposed mode (right click spreadsheet for this
option)
Fixed the Scratch Spreadsheet window to work correctly when
the source spreadsheet is transposed.
Version 5.4 Build 298 - November 29, 1999
Fixed a parsing error with REM and EXEC statements.
DESC now shows REF CURSOR types correctly.
Added the ability for the exec command to process functions that
return a ref cursor type variable. The function must be run
with a bind variable called :cursor. For example:
exec :cursor := MyCursorFunct('Fish');
or
exec MyCursorProc('Fish', :cursor );
-- Second argument must be an in/out ref cursor type.
Version 5.4 Build 295 - October 27, 1999
Fixed a bug displaying the 'All Objects' tab of SQLBuilder.
Added an error message to ImpExp for when the destination table
doesn't exist.
Version 5.4 Build 294 - October 12, 1999
Fixed a bug displaying negative numbers when the datatype
was number(1).
Version 5.4 Build 293 - October 11, 1999
Changed the default setting for 'AutoRun' in the Favorites
menu to False which seems to be the more popular setting.
Fixed a problem with restoring the main window position if it
was maximized when closed.
Fixed a problem with the 'Export current query' command.
Changed the All Objects window of SQLBuilder to make it much
faster. Fixed a right clicking problem in SQLBuilder.
Reduced the number of system resources Golden uses per 'tab'.
Added a 'transpose columns/records' choice to the spreadsheet's
right click menu.
Added a 'select other users' choice to the SQLBuilder's User tab's
right click menu. This may be useful in some situation where a user
has access to many different schema's objects.
Some changes to the login window to remove duplicate quicklogin
entries.
Added options to uppercase/lowercase the SQLBuilders keywords and
object pastes separately.
Added an edit menu choice to toggle the case of selected text.
Version 5.4 Build 284 - August 2, 1999
Fixed a bug where focus would shift to another program when
closing the find or replace windows.
Fixed a bug where the text selection would be lost when
right clicking the editor.
Version 5.4 Build 283 - July 20, 1999
Fixed a syntax highlighting bug.
Version 5.4 Build 282 - July 19, 1999
Fixes a problem when using the Tools menu to go to other app
when a hardcoded oci.dll is used.
Golden now remembers the last directory used (if not set
to use the favorites menu as the default directory.)
The Tools menu will now work when the applications are in
different directories. Note that the individual apps have
to be run once 'solo' so that their locations can be entered
into the registry.
Version 5.4 Build 281 - July 15, 1999
Fixed editing of tables with dblinks.
Fixed a problem with desc and synonyms.
Fixed problems where dbms_output and cell detail windows
would be stuck on top of other windows while some
operations were running (exec.)
Mousewheel now scrolls faster.
New help file.
Version 5.4 beta Build 280 - July 7, 1999
Fixed the login options window when using 'large fonts'.
Put the Ignore Net8 option on the Login Options window.
This is mainly used to fix the problem where
Net8.0-Net8.0.4 won't report sql error positions.
Version 5.4 beta Build 279 - July 6, 1999
Fixed a bug where dates could be truncated on display if the
length of the date string was increased after the first query.
Improved the Net8 detection code for those system that have an
OCI.DLL file that doesn't work. Also added a way to pick
the correct oraxxx.dll for systems with a 'messed up' registry.
Version 5.4 beta Build 278 - July 1, 1999
Fixed a potentially dangerous bug where a query
using prompt variables would run even if the cancel button
on the script variable window was pressed.
Changed the version to 5.4 to make it obvious which version
contains the above fix.
Version 5.3 beta Build 276 - June 30, 1999
Improved Login window with new Options window.
Added Ctrl-Right click to run a single statement at the click position.
Added Mousewheel support.
Put back 'Running SQL' lightning bolt icon on tab's statusbar.
Note that you cannot click it to stop the run, use the stop button.
Version 5.3 beta Build 274 - June 22, 1999
Better code for linking to SQLNet/Net8.
Automatic support for multi-homed systems.
Better error messages on link failure.
Improved Cell details window.
Fixed drag and drop of Workspace files on Golden.
Added Workspace files to Most Recent Files list.
- More to come! -
Version 5.3 beta Build 270 - June 1, 1999
Added a HEX viewer to the cell details window.
Changed an internal bind buffer that was causing problems.
Fixed a problem with ImpExp32 related to default font size and
screen dimensions.
Version 5.3 beta Build 266 - April 14, 1999
Changes for Net8 8.1.x.
Version 5.3 beta Build 265 - March 30, 1999
Fixed a problem with creating new tabs after closing all under some
conditions.
Version 5.3 beta Build 263 - March 26, 1999
Fixed some major problems with find and replace.
Find and replace now are modeless and work on whatever tab is active.
You can change tabs, type, etc. without closing the find/replace windows.
Version 5.3 beta Build 261 - March 19, 1999
Made some slight parsing improvements.
Changed the icon for ImpExp.
Version 5.3 beta Build 259 - March 18, 1999
Fixed a problem with the SQLBuilder (nasty freeze up on large schemas.)
Version 5.3 beta Build 257 - March 16, 1999
Enhanced the results printing to print the entire spreadsheet using
multiple side-by-side pages if necessary (Finally!)
Added a new option 'Workspace saves mark tabs as saved" that
when checked will consider tabs saved to a workspace to be
fully saved.
Enhanced the DESC[RIBE] command to fully match SQLPlus. It
can now describe remote objects (via db_links.)
Fixed the undefine command (wasn't working!)
Fixed a problem with blank prompt variables.
Added a prompt variable cache so that if prompted for a variable
name that isn't defined but has been used before, the default value
will be the cached value.
Added -a commandline switch to autorun a script on startup.
i.e. c:\benthic\golden32.exe "-aC:\BENTHIC\MYSCRIPT.SQL"
Example with autologon:
c:\benthic\golden32.exe -uscott@mars -ptiger "-aC:\BENTHIC\MYSCRIPT.SQL"
Added -x commandline switch to exit Golden automatically (used with -a)
i.e. c:\benthic\golden32.exe "-aC:\BENTHIC\MYSCRIPT.SQL" -x
(will run myscript and then exit.)
Version 5.3 beta Build 252 - March 4, 1999
Fixed the 'startup tabs' setting.
Changed the way that the SQLBuilder loads its data. (possible bug fix.)
Changed the way that scripts run in the background. This change can
make a slight visual problem with toolbar buttons that don't redraw
their frame. I will work to solve this visual problem.
Version 5.3 beta Build 251 - March 1, 1999
Fixed a script parsing bug when statements begin with a comment.
Version 5.3 beta Build 250 - February 24, 1999
Fixes / Improvements:
Fixed some editing bugs that could cause 'strange' characters to appear.
Fixed performance problems with running large scripts.
Editor should be faster and use less memory.
Interface changes:
Added line numbers to editor (off by default.)
Added new Character Set setting in Options.
Each tab has its own status bar.
Cancel button is now on the tab status bar and only visible when running.
Added undo / redo buttons to the toolbar.
Added a 'quick search' field to the SQLBuilder.
Added some 'right click' options to the scratch window.
Shortcut changes:
Ctrl-J: Login (also Ctrl-L)
Shift-Ctrl-#: Sets a bookmark within a script.
Ctrl-#: Goes to a bookmark.
Alt-#: Switch to tab # (used to be Ctrl-#)
Ctrl-PageDown: Next Tab
Ctrl-PageUp: Previous Tab
SQLBuilder QuickSearch:
DownArrow, Enter: Search down.
UpArrow, Shift-Enter: Search Up.
Version 5.2 Build 243 - January 15, 1999
Added 'Unregister program' to the help menu. This is for consultants
who register their copy at a site and want to unregister the program
when they leave (much appreciated by the way!)
Added a password prompt if a connect statement doesn't include a password.
Changed double clicking so it will not select quote characters.
Added options to the Options|Spreadsheet page to clear the spreadsheet
before running scripts and statements.
Removed the extra crlf from single cell spreadsheet copy.
Fixed a cut/paste bug.
Version 5.2 Build 242 - December 10, 1998
Improved the login window with the ability to save passwords. Just
check 'Save Password' to have the password be saved (encrypted.)
Double-clicking a line in the quick login list that contains a
password will jump you right in. The setting of 'Save Password' is
associated with each line in the quicklist. You should only have to
change it when you are logging in for the first time on that account
or if you want to change it after the first time. Note that the
quicklist is now global across all of Benthic's tools (with the next
releases.)
Golden will now skip 'prompt' and 'accept' statements in the script.
New 'Scan for Vars' option that will allow making the default to not scan
for '&' variables.
Fixed a problem where a tab caption would not be refreshed after a save.
Version 5.2 Build 241 - December 7, 1998
Improved the login window to include a 'Quick Loginlist' of previous
logins. I would like feedback on whether passwords should also
(optionally) be saved (encrypted.) Send your vote to
markford@benthicsoftware.com (Thanks!)
Added a new 'Ignore Net8' checkbox to the login window so that you
can choose to use the Oracle7 libraries even if Net8 is installed.
This can be useful to avoid the Net8 bug that doesn't report error
positions.
Changed the way that the dbms_output window works. Now opening the
window while on a private tab will open a new dbms_output window
using that private session.
Fixed a parsing problem with multiple internal comments containing a
statement delimiter.
Fixed problem with displaying '&' in the spreadsheet.
Fixed a problem where the vertical scrollbar would go away when text
was clipped at the top.
Version 5.2 Build 240 - November 24, 1998
Fixed SET ROLE command.
Version 5.2 Build 239 - November 18, 1998
Fixed a problem with updating and deleting records containing long fields.
Version 5.2 Build 238 - November 18, 1998
Added '...' when text is clipped in the spreadsheet.
Fixed problem with long columns being autosized so big that they couldn't
easily be shown alongside other columns.
Fixed a problem with Shift-Ctrl-Tab.
Fixed a problem with parsing filenames for the @ function.
Note that filenames with spaces must be surrounded by quotes:
@"c:\program files\runme.sql"
Version 5.2 Beta Build 237 - November 10, 1998
Fixed a problem with initialization of the keyword lists.
Fixed some missing help links.
Version 5.2 Build 236 - November 9, 1998
Added new Keywords page to the options for editing the keyword list.
Added new SQLBuilder Wordlist page to the options for editing the
SQLBuilder's word list.
Added menu choice to check for a new version on the web and download it.
Version 5.2 Build 234 - October 20, 1998
Added new save and load workspace commands. Right click the active tab to
rename it.
Some interface changes. Tabs can be at the top or bottom (Options)
Added menu choice to check for new versions on the web.
Added menu option to start ImpExp with the current select statement.
Added code to strip out trailing line whitespace before parsing scripts.
Added stored procedures to the DESCRIBE (DESC) command.
Explain plan output now goes to a text screen.
Use F12 to toggle spread, text, and log displays.
Added the EXECUTE (EXEC) command. Bind variables are automatically scanned
and displayed.
Note that this doesn't support tables or refcursors yet.
Note that exec'ed commands aren't currently being run in the background.
(You can only run one at a time.)
ImpExp Version 2.1 Build 104 - October 20, 1998
Fixed bug where cancel wasn't active during exports.
Added some new options for the export header line.
Made all checkboxes and radiobuttons in the program save their values when
'Save Defaults' is pushed.
Version 5.1 Build 228 - Aug 12, 1998
Added code to load files opened from explorer into first instance.
Changed version to reflect the public release of builds 225-228.
Version 5.0 Build 227 - Aug 5, 1998
Fixed the commented out commandline file loading code.
Version 5.0 Build 226 - Aug 3, 1998
New multi-level undo and redo.
Editor scroll bars now work like a 'standard' windows edit control (scroll
bars hide if not needed.)
Fixed some small editor bugs.
Version 5.0 Build 225 - July 30, 1998
Fixed a bug in the parser related to tables and fields with 'REM' in them.
Added DESC command (=DESCRIBE)
Added right click menu to the object trees in the SQLBuilder (currently used
for pasting 'select * from table')
Changed data editing so that you can edit tables without keys if you include
the rowid as the first field in the select: eg: select rowid, bonus.* from
bonus (where bonus has no PK or unique indexes.)
Changed the way that the Favorites menu is displayed. This fixes a problem
where the icons would disappear.
Unfortunately this doesn't allow the 'opened folder' icon as you move over
them (I really liked that!)
Added a new option to the Menus Option page to set the default directory
to be the favorites directory.
Version 5.0 Build 224 - July 20, 1998
Changed updates to only update columns that were changed. There is an
option to use the old behavior.
Fixed autocommit.
Fixed problem with comments inside strings.
Fixed infinite loop when running a non-select from the favorites menu and
option to disallow was on.
Added new describe command (only for tables and views and local synonyms)
ImpExp Version 2.0 Build 102 - July 9, 1998
Fixed problem with trailing nulls when not use a field qualifier.
Version 5.0 Build 220 - June 26, 1998 Production
New threading model that makes the interface more responsive.
Fixed some problems with the most recently used file list.
New improved @script running including step capability.
Ctrl-Enter now does STEP (can be turned off in the Edit Options)
During step cursor no longer has to be at the beginning of a statement.
Fixed icon not showing in NT Tasklist.
New version of ImpExp32 with help included.
Version 5.0 Build 216 - June 8, 1998 Production
Fixed problem with single quotes when deleting records.
Version 5.0 Build 215 - June 2, 1998 Production
Cleaned up File New/Open menus.
Allow dragging of files from explorer.
Added 'Visit Benthic Web Site' to Help menu
New help system.
Changed filename back to Golden32.exe
Version 5.0 Build 210 - April 13, 1998 Beta 1.5
Many small fixes. Now allows changing tabs while editing.
New Import Export program. The new ascii mode is much faster than the
old one.
Version 5.0 Build 209 - March 25, 1998 Beta 1.5
Added full autosize to Explain Plan display
Added double quote processing for script filenames containing spaces.
(eg. @"c:\program files\my script" Arg1 "Arg2 with spaces" Arg3
Added a display refresh when closing all tabs to show the tab in question.
Fixed a bug where explain plan wouldn't go away.
Added the following:
Right click the upper left gray cell of the spreadsheet does an autosize
(displayed rows only)
Shift-Right click it to get a full spreadsheet autosize.
Version 5.0 Build 208 - March 24, 1998 Beta 1.5
Fixed the 'Affected Records' display.
Added a 'Hide before/after sql text' to the Options.
Added a hotkey 'F8' to switch between editor and results (same as Ctrl-R)
Added '.sql' to @files if the text has no extension.
Version 5.0 Build 207 - March 23, 1998 Beta 1.5
Full Oracle8 relational support.
Editor improvements and syntax highlighting speed increases.
New sqlbuilder with better handling of case sensitive Oracle items.
(cool 'qucksearch' by typing in the tree.)
Better script parsing.
New 'script stepping' feature (Run one statement at current cursor position.)
New hotkeys for menu commands.
New support for the '@' script running feature.
New 'Private tab' ability. This allows a tab to have a private connection
to the database. Please see the new help.txt file for details.
Support for the SQLPLus CONNECT command.
Version 5.0 Build 204 - February 25, 1998 Beta 1.5
Fixed problem with threading on Oracle 7.3.3.
Version 5.0 Build 203 - February 17, 1998 Beta 1.5
Fixed Parsing problem with create or replace statements.
Fixed problem with nested comments and parsing.
Fixed problem with define statement 'hiding' the next sql statement in
the script.
Version 5.0 Build 201 - February 16, 1998 Beta 1.5
Fixed problem with dbms_output window crashes.
Added back hotkeys Ctrl 1-0 for tabs.
Added back noprompting option.
Optimized script parsing.
Fixed cancel button on prompting window. It now really cancels.
Version 5.0 Build 200 - February 8, 1998 Beta 1
Many large and small changes. Here are some highlights:
New user interface using dynamically created tabs.
Significantly better threaded queries.
Docked sqlbuilder window.
Syntax highlighting.
Unlimited size scripts and copy/paste
Support for sqlplus style variable prompting.
Language formated copy/paste (to copy sql to other programming
environments)
Editor supports deleting records.
New Log window shows every command run and errors.
New scratch results window for comparing data between tabs.
New copy results to another tab (shift click the tab you want to copy
result to.)
New script parsing to match sqlplus parsing.
SQL statements end with semicolon-return, plsql ends with return-'/'-return.
Ability to turn off variable scanning and substitution.
Ability to turn off errors before or during running script.
Ability to run a script from the current cursor position.
Version 4.6 Build 164 - December 1, 1997 Production release.
Fixed exception while closing after not logging in.
Version 4.6 Build 163 - November 17, 1997 Production release.
Fixed a problem with the default date format.
Version 4.6 Build 162 - November 14, 1997 Production release.
Fixed a bug where explain plan wouldn't refresh.
Version 4.6 Build 161 - November 11, 1997 Production release.
Fixed an error while running an anonymous plsql block without a trailing
'/' char.
Version 4.6 Build 160 - November 5, 1997 Production release.
Fixed a bug in the scripting engine that complained about trailing semicolons.
PLSQL compile error indicated.
Fixed bugs related to using the clipboard while editing.
Can now abort editing a record cleanly.
Version 4.6 Build 156 - October 20, 1997 Beta 2
Fixed a registration code bug!
Version 4.6 Build 155 - September 29, 1997 Beta 2
You can now cancel a query by pressing while it is running.
Note that to cancel a query during the parse phase, you must have version
2.3 of sqlnet. Please report any problems!
Version 4.6 Build 140 - September 10, 1997 Beta 1
Now each sql window shows its own results.
Import/Export has been moved to a separate app that can be minimized while
running.
Right clicking a column header toggles between left, middle, and right
alignment.
Right clicking a cell shows the text in a modeless dialog that can wrap or
show ascii codes.
New most recent files on the file menu.
Version 4.5 Build 124 - July 23, 1997
Added new statusbar pane to show what command was last executed and
how many records it affected.
Version 4.5 Build 123 - July 17, 1997
Greatly improved script parsing to allow comments.
Cosmetic changes to error messages.
Version 4.5 Build 118 - July 11, 1997
Editor improvements
Home key toggles between beginning of line and first non-whitespace char.
Tab and shift-tab indents/unindents selected blocks.
Fixed problem with Tools Menu ignoring user options.
Add version info and build number to about box.
Started History file!
Oracle, SQLPlus and SQL*Net are registered trademarks of Oracle Corporation.