RazorSQL Updates / Change Log

Query Results: Added preference for specifying which character set to use when displaying query results
Connection Wizard: Added support for Frontbase database passwords

Bug Fixes

SQL Explain Plan: MS SQL Server explain plan throwing error when using default connection settings (server side cursors)
Edit Table Tool: Replace all not replacing values
Connection Wizard: Browse button for Firebird databases sometimes showing save dialog instead of open dialog
SQL Editor: Redo keyboard shortcut not working
Create Table Tool: Numeric value columns not enabling the scale field
Create Table Tool: Postgresql char column not defaulting a size value
Database Navigator: Postgresql showing char columns as bpchar
Drop Index Tool: SQL Server 2000 syntax incorrect

4.2.8

Enhancements

Export Tool: Added ability to wrap exported values in double-quotes if there are delimiters found in the value.
Import Tool: Added option to handle values containing delimiters that are wrapped in double quotes
Auto Lookup: Added option for setting auto lookup timeout
SQL Editor: Added option for specifying whether to turn font anti-aliasing on or off

Changes

Database Navigator: SQL Server Owners / Schemas query changed for better performance.
SQL Editor: Added ability to cancel executing tasks one by one instead of all at once
SQL Editor: Auto reconnect changed so that auto reconnect is only attempted one time per query
Keep Alive: Added a 10 second timeout to keep alive calls

Bug Fixes

Edit Table Tool: On Windows, down and up arrow were moving two cells instead of one
SQL Editor: SQL Server - poor performance when executing queries after a query that returns a large result set
SQL Editor: Fixed occasional performance problems when closing large query results tabs
SQL Editor: Comma in order by doing an auto table lookup instead of an auto column lookup
SQL Editor: Auto table lookup not firing after from in a delete statement
SQL Editor: Linux: Slow keyboard response on using JRE 1.6.x
JDBC Bridge: Cannot handle queries with + in them

4.2.7

Enhancements

General: By default, if a connection is dropped, RazorSQL will automatically try to re-establish the connection.
Preferences: Added option to keep alive preferences for automatically reconnecting dropped connections.
Command Line: Added import command as a command line option
Editor: Added regular expression find and replace
Auto Table Lookup: Now recognizes join clauses and will do auto table lookup on comma space in a select from clause
Auto Table Lookup: By default, auto table lookup no longer prepends schema or database for tables in current schema or current database
Auto Table Lookup: Added preference for whether or not to show schemas and databases in auto table lookup results
Auto Table Lookup: Added preference for whether or not to prepend current schema or database for tables in current schema or database.
Auto Column Lookup: Column names now displayed after "and" or "or" text.
Export Tool: By default, non insert statement exports convert nulls to blank. Can be overriden by deselecting the convert nulls . . .box
Column Lookup, Describe, and View Table Contents: Now will automatically execute without a prompt for an object name if there is selected text in the editor that matches the selected object in the current dropdown options for the tools
Column Lookup: Now remembers last schema and does a better job of remembering last table
Table Lookup: Now remembers tables, views, and system tables selection, and does a better job of remembering last schema and catalog
Table Lookup: Adde an option for whether or not to prepend schemas or databases
General: Add an "Open Copy" option to the right-click menu of the Tab
General: Add a "Make Backup" option to the right-click menu of the Tab

Changes

Check for warn if modified on focus instead of just when switching tabs
Space character now select lookup dialogs value in addition to the ENTER key
Should only be able to have one lookup dialog open at a time
System Database Navigator: Fetch size settings from the preferences are now used when retrieving database objects using the System navigator
Auto lookup and lookup dialogs no longer modal and now can be moved
Delete and Backspace characters now close lookup dialogs in addition to ESCAPE
Windows: Only one instance of RazorSQL can be opened at a time

Bug Fixes

File -> Tools and File -> Conversions not working
Commit and Match Tag share the same default keyboard shortcut
If using SPACE as an option for a keyboard shortcut inserting an extra space when typing the shortcut
Execute Procedure Tool: Parameters not being retrieved correctly for schemas or databases with spaces in the name

4.2.6

Bug Fixes

SQLite: Large queries hanging in certain circumstances

4.2.5

Enhancements

SQL Editor: Added Search Bookmarks option, including Add Bookmark, Remove All Bookmarks, Next Bookmark and Previous Bookmark for quickly jumping to different sections of a file.
SQL Editor: Added Edit - Code - Line Comment for quickly commenting a line or group of lines
SQL Editor: Added Edit - Code - Range Comment for quickly commenting a line or group of lines
SQL Editor: Added Edit - Text - Tabs to Spaces
SQL Editor: Added Edit - Text - Spaces to Tabs
SQL Editor: Auto indent now supports spaces and tabs
SQL Editor: Enhanced Match tag and Match bracket tools
Navigator Filter Tool: Enhanced navigator filter tool giving options to filter on all database objects, such as tables, views, procedures, etc. using syntax such as contains, not contains, in, not in, equals, and not equals
Export Tool: Insert statement option now enabled when a query is a select * from a table.
Java Tools: Enhanced compiler and set classpath tools
SQL Server: Enhanced connection process to smart detect common errors
MySQL: Enhanced connection process to detect incompatabilities between MySQL and the driver used.

Changes

Application name property now set to RazorSQL when connecting for Sybase and SQL Server
Added default keyboard shortcut of Command / Control M for match tag
RazorSQL now wraps database objects that include periods in their names
Sybase and SQL Anywhere - Create table tool now explicitly inserts the NULL keyword for columns specified as nullable

Bug Fixes

Null not showing as a keyword for Transact-SQL
Oracle Show Info on Functions and Procedures in System Navigator returning info on all functions and procedures
SQL Server - Database Navigator not always working when the user does not have a current schema, such as for active directory single sign-on

4.2.4

Bug Fixes

Export Tool: Single table export tool throwing error. Caused in 4.2.3 release.
SQL Editor: null not appearing as a keyword for Transact SQL.

4.2.3

Enhancements

Query Results: Query results tab now attempts to show the first database object in the query as the title of the tab
Query Results: Tooltip on the query results tab is set to the query
Query Results and Edit Table Tool: By default, the background color of the result rows now alternate colors
Query Results: By default, null values cells in the query results show as a different color
Query Results: Added preference for whether or not to show database object name as tab title
Query Results and Edit Table Tool: Added preference for whether or not to alternate background color on results rows
Query Results: Added preference for whether to show null cells as a different color
SQL Editor: Added preference for close result sets on execute to help eliminate any table locking, especially for DB2.
SQL Editor: DB2 - SQL state error code descriptions are now included in error messages
SQL Editor: Execute SQL (One Statement) now checks any highlighted text and makes a determination if there are multiple normal queries (select, insert, update, delete) contained in the text. If there are, all queries are executed.
SQL Editor: Added preference for the Execute SQL (One Statement) multi-query parsing
SQL Editor: By default, semi-colons are stripped off of queries wnen using Execute SQL (One Statement) for databases that do not support ending semi-colons. (DB2, Derby, Ingres, Oracle (for select,insert,update, and delete only), and Sybase
SQL Editor: Added a preference for whether or not to strip semi-colons for applicable databases (DB2, Derby, Ingres, Oracle, Sybase)
SQL Editor: Search - Replace All speed enhancements
Edit Table Tool: Down and Up arrow keys now move up and down rows instead of to the beginning and ending of row text
SQL Editor: Added menu option for Execute (All Statements Close Current Tabs) to close existing query results tabs and then add the new tabs for the executed query results
Database Navigator, Describe Tool: Enhanced column information now available for SQLite views

Changes

Database Navigator, Edit Table Tool: SQLite views are now editable.
Query Results: Queries with no results no longer have their query results tab replaced when the next query is run
SQL Editor: Removed query length check
SQL Editor: Removed preference for Run Each Query in a New Tab, since setting the statement / query count to 1 accomplishes the same thing.

Bugs

Explain Plan Tool: Not working correctly for DB2
Edit Table Tool: SQLite - If table already has a rowid column, do not display another rowid column

4.2.2

Enhancements

Connection Wizard: Added Microsoft SQL Server ASP bridge
Connection Wizard: Added Microsoft SQL Server PHP bridge
Connection Wizard: Added PostgreSQL PHP Bridge
Tools: Added copy to editor button to query builder, create tools, alter tools, drop tools, and import tool
Query Results: Added save query button to query results toolbar
Query Results: Added save query option to query results popup menu
Preferences: Added a preference for whether or not to auto-parse editor contents for queries by searching for the closest semi-colon after the cursor when executing queries

Changes

Tools: For SQL Server, Sybase, and SQL Anywhere, tools that generate SQL now check the value of the QUOTED_IDENTIFIER session setting to determine whether to generate SQL with qoutes or brackets when necessary
Editor: Tabs now scroll instead of stacking
Editor: Added semi-colon auto-parsing for determining the query to execute for PL/SQL, Transaction SQL, and SQL PL syntax highlighting types
Preferences: Added a Default option to the file encoding preference menu to make it easier to tell RazorSQL to use the default operating system file encoding
Database Navigator: Can now handle navigation for DBASE
General: Implemented a custom scale for painting icons to prevent black icon backgrounds when using RazorSQL with Parallels

Bug Fixes

MySQL PHP Bridge: use database command ignored when trying to switch databases
MySQL PHP Bridge: errors on multi-line selects
FrontBase: displaying nulls as 0 for numeric columns
Editor: OS X Leopard: Sometimes error thrown when adding or removing tabs
Customize toolbar: Not letting default icons be removed
Alter Table Tool: Table list for MySQL showing all tables when no database is selected
Print Output: SQL Server / Sybase - Not all print output being captured for statements with multiple result sets
SQL Formatter: Not factoring in underscores when upper casing or inserting line breaks for keywords
SQL Server ODBC Driver throwing multiple open result set errors

4.2.1

Enhancements

Actions: View Print / DBMS Output Window automatically refreshes
General: Added option to customize exactly which icons appear on the toolbar
General: Added preference for whether or not to show hidden files in File System Browser
General: Added preference for whether or not to save caret position when exiting

Bug Fixes

Windows: Buttons on query results pane not always clickable after focus is set in the SQL editor
Windows: Editor line numbers not always painting properly
General: Focus is not always in the editor on launch of RazorSQL
View Print Output: Only returning 25 messages
Connection Wizard: Oracle connect as property not getting saved after the initial connection
Function List Tool: PHP - global if / else statements are being listed as functions
Status Component: sometimes showing invalid length for Windows files that end in a blank line

4.2.0

Enhancements

Tools: Added a Create Database tool for MySQL, PostgreSQL, MS SQL Server and Sybase
Tools: Added a Drop Database tool for MySQL, PostgreSQL, MS SQL Server, and Sybase
Tools: Added a Create User tool for MySQL and PostgreSQL
Tools: Added a Drop User tool for MySQL and PostgreSQL
Actions: Added View Print Output for MS SQL Server and Sybase for viewing output of PRINT statements in executed statements.
Actions: Added View DBMS Output for Oracle for viewing DBMS output in executed statements
SQL Editor: Added parameter processing to queries, i.e. select * from employee where id = &id -- launches an input dialog for the user to specify the value for &id
SQL Editor: Enhanced auto column lookup
Programming Editor: Added File -> Open With Encoding option to specify a file encoding for reading and opening a file
Programming Editor: Added File -> Reload With Encoding option for reloading a file with an encoding chosen by the user
Programming Editor: Added File -> Save with Encoding option for saving a file with an encoding chosen by the user
Programming Editor: Added preference for the default file encoding for opening and saving files to allow users to specify a file encoding other than the default file encoding used by the operating system
Programming Editor: Added the current file's file encoding to the editor status panel
Programming Editor: Increased maximum size of a file that RazorSQL can open with default memory settings to approximately 75 MB
Programming Editor: Find/Replace - Show Found Lines option now has clickable links to take the user directly to the found line
Programming Editor: Replace All now shows the number of replaced items
Programming Editor: CSS Tag List tool now sorts the CSS tags
Programming Editor: PHP, JavaScript, HTML, BAT, Perl, Ruby, Python, and Shell Script Function List tool now sorts the functions and displays the function names first
Database Navigator: Added a rename option to the Database Navigator as a shortcut to rename tables via the Alter Table tool
Database Navigator: Added a rename option to the Database Navigator as a shortcut to rename columns via the Alter Table tool
Database Navigator: Added users to MySQL, PostgreSQL, and Sybase system database navigator
Database Navigator: Added roles to PostgreSQL and Sybase system database navigator
Connection Wizard: Added transaction isolation level as a selectable option to the connection profile screen. Selectable values are Default, Read Uncommitted, Read Committed, Repeatable Read, and Serializable
SQL Formatter: Added enhancements for formatting quoted and commented text
Windows: Updated included JRE to 1.6.0_04
Windows Installer: Now adds RazorSQL to Open With right-click menu
Windows Installer: Now adds RazorSQL to right-click menu for .sql files

Changes

Programming Editor: Find / Replace in Files dialog no longer modal
Programming Editor: Java Function List - method name is now first with public, etc. after the method name for better readability
Programming Editor: Tag List - added more information about tags

Bug Fixes

Auto Column Lookup: Not working for tables with spaces in the name and in certain situations when tables have special characters in the name
Export Tool: Throwing a Result Set is closed error in certain situations when exporting query results, especially when using the fetch all results option
SQL Formatter: Not factoring in quoted text when inserting line breaks
Tools: Not working for tables with large column counts, such as 500 plus columns - (Query Builder, Navigator Filter, Edit Table Tool, Create Table Tool, Create Proceure Tool, Alter Table Tool, Import Tool)
Find / Replace in Files, Find in Open Editors: If more than 512 results found, an error was thrown
Tag List, Function List, Query List: If more than 512 results found, an error was thrown
Programming Editor: Saving a new file does not honor the line separator preference if the file does not yet exist and the line separator preference is not the default for the operating system

4.1.7

Enhancements

Command Line Interface: Added the ability to export data by interacting with RazorSQL via the command line
SQL Editor: Find / Replace in Files - Found or replaced lines now have clickable icons to take the user to the line in the file that was found or replaced
SQL Editor: Find in Open Editors - Found or replaced lines now have clickable icons to take the user to the line in the file that was found or replaced
Database Navigator: Added Show Info for Sybase views to show Sybase view definitions
SQL Editor: Added File -> Show in Web Browser option
General: OS X - added Open Files server to the Finder for RazorSQL
General: OS X - added RazorSQL to the Finder open with menu

Changes

General: Moved Ascii Table option under Tools menu
General: Changed default keyboard shortcuts for Previous Tab and Next Tab due to conflicts with special characters keyboard mapping

Bug Fixes

SQL Editor: Typed special characters such as those on non US keyboard layouts not being recognized by SQL Editor
SQL Editor: Oracle - Compile errors not being shown for procedures/packages when a procedure is built using a fully qualified schema.procedure name
SQL Editor: Match Tag option - If there are nested child tags of the same name as the parent tag, the Match Tag tool is not factoring them in when determining where the end tag is
Database Navigator: Alter View option not returning view definition for Sybase
Database Navigator: Informix - Procedure, Function, and Trigger contents not being returned for certain configurations
Query Results: Executing an exec command that returns results does not enable the buttons on the query results toolbar

4.1.6

Enhancements

Preferences: Added customizable keyboard shortcuts to the Preferencees window for each command available in RazorSQL
Programming Editor: Added Edit -> Next Paragraph option
Programming Editor: Added Edit -> Previous Paragraph option
Programming Editor: Added Edit -> Select -> Select Next Paragraph option
Programming Editor: Added Edit -> Select -> Select Previous Paragraph option
Programming Editor: Added Edit -> Select None (Escape) option for cancelling selected text
Programming Editor: Added Edit -> Command / Control T option for bringing up the Font window
Programming Editor: Reload File option now remembers cursor position
Query Results: Added Show Cell Text in New Window icon and menu option
Query Results: Added Copy Cell Text to Editor icon and menu option

Changes

Programming Editor: OS X - Changed Select Next Word default keyboard shortcut to Shift - Option - Right
Programming Editor: OS X - Changed Select Previous Word default keyboard shortcut to Shift - Option - Left
Programming Editor: OS X - Changed Select to End of Line default keyboard shortcut to Shift Command Right
Programming Editor: OS X - Changed Select to Beginning of Line default keyboard shortcut to Shift Command Left
Programming Editor: OS X - Changed Select to Beginning of Document default keyboard shortcut to Shift Command Up
Programming Editor: OS X - Changed Select to End of Document default keyboard shortcut to Shift Command Down
Programming Editor: Added target version of 1.6 to target dropdown for Tools -> Java -> Compile
General: Moved Toolbars menu under the View menu

Bug Fixes

MySQL PHP Bridge and JDBC Bridge: In RazorSQL versions 4.1.4 and 4.1.5, date columns are throwing a not supported exception on select
Keep Alive: Keep Alive query not getting set correctly for some databases
Programming Editor: Next Tab keyboard shortcut not working on OS X

4.1.5

Enhancements

Edit Table Tool - Improved table cell editing - cells are now editable without clicking
Connection Wizard - Updated auto-download MySQL driver to 5.0.8
File Tools / File System Browser - Added regular expression file search tool.
General - Tools selected via the tools menu now check for selected tables/views in the database navigator in addition to selected text in the SQL Editor to populate the selected table/view in the tool dropdown
General - Added View Memory Usage item to the Help menu
File System Browser - Added ability to change font
SQL Editor - Added Increase Editor Font item to the View menu
SQL Editor - Added Decrease Editor Font item to the View menu
SQL Editor - Added View -> Display Line Numbers option
SQL Editor - Added View -> Display Editor Status option
Programming Editor - Added File -> Conversions menu for converting to Windows, OS X / Unix, and Mac Classic line breaks
Programming Editor - Added syntax highlighting and function lookup support for COBOL.

Changes

Edit Table Tool - Automatically handle and display the SQLite implicit rowid column
Edit Table Tool - Display an error message if a user tries to edit an SQLite view since views in SQLite are read-only
Create Table Tool - SQLite - removed support for AUTOINCREMENT
Programming Editor - now auto-detects the line separator of an opened file and formats accordingly (Windows = \r\n, Unix / OS X = \n, and Mac Classic = \r)

Bug Fixes

Import Tool - Bug introduced in version 4.1.4 with Delmited file validator
SQL Editor - MySQL - Do not show a selected database in the database drop down on the toolbar if not database has been specified on connect
SQL Editor - If a new database is created or dropped, the change is not reflected in the database dropdown on the toolbar
Create Table Tool - MySQL - AUTO_INCREMENT syntax incorrect
General - SQLite - Not handling null values correctly. Displaying them as <NULL>.
General - Find / Replace and Find / Replace in Files tools - First time launch not populating with selected text if there is text selected in the editor
Programming Editor - .h files now default to C syntax highlighting

4.1.4

Enhancements

Import Tool - Added capability to import data from fixed width files
SQL Editor - Added database dropdown for SQL Server, Sybase, and MySQL to allow users to switch databases by selecting a value from the dropdown
SQL Editor - Added Tools -> Query List option for displaying clickable list of SQL queries contained in the editor
SQL Editor - Added Tools -> Function List option for displaying clickable list of functions / methods contained in the editor depending on the programming language selection of the editor
SQL Editor - Added Tools -> Tag List option for displaying clickable list of tags (such as XML or HTML) contained in the editor
File System Browser / File -> Tools - Added head option for displaying the beginning of files
File System Browser / File -> Tools - Added tail option for displaying the end of files
File System Browser / File -> Tools - Added get section option for displaying sections of files
File System Browser / File -> Tools - Added copy option for copying files and directories
Editor - Added File -> Tools menu containing Size, Get Info, Move, Rename, Delete, Head, Tail, and Get Section options

Changes

Oracle - Edit Table Tool - Now displays dates in Oracle to_date format as opposed to Oracle's internal to_char representation
Oracle - Export Tools - Now converts date columns to Oracle to_date format for the "Export as Insert Statements" option
Oracle - Edit Table Tool - Now displays timestamps in Oracle to_timestamp format as opposed to Oracle's internal to_char representation
Oracle - Export Tools - Now converts timestamp columns to Oracle to_timestamp format for the "Export as Insert Statements" option
Editor - .pm and .pl.in extensions now automatically recognized as perl files

Bug Fixes

Edit Table Tool - when entering single quotes in date or time columns such as for Oracle to_date or to_char syntax, they were being escaped if the escape single quotes option was enabled
OpenBase - Edit Table Tool - _row_id column not being displayed
OpenBase - Import Tool - _row_id column not being displayed
Editor - Files with a .js extension not automatically being recognized as JavaScript files

4.1.3

Enhancements

Alter Table Tool: Added rename table for HSQLDB, MySQL, Oracle, PostgreSQL, SQLite, SQL Server, Sybase, SQL Anywhere
Alter Table Tool: Added rename column for HSQLDB, Firebird, MySQL, OpenBase, Oracle, PostgreSQL, SQL Server, Sybase, and SQL Anywhere
Alter Table Tool: Added drop primary key option for DB2, MySQL, Oracle, PostgreSQL, SQL Server, and SQL Anywhere
Alter Table Tool: Added drop foreign key option for DB2, MySQL, Oracle, PostgreSQL, and SQL Server
Alter Table Tool: Added add sequence trigger option for Oracle - generates a before insert trigger to handle auto-incrementing
Database Navigator: Added Truncate option to the database navigator for tables for Informix, MySQL, Oracle, PostgreSQL, SQL Anywhere, Sybase, and SQL Server
Database Navigator: Added option to truncate multiple tables to database navigator for Informix, MySQL, Oracle, PostgreSQL, SQL Anywhere, Sybase, and SQL Server
Database Navigator: Added option to drop multiple tables to database navigator
Import Tool: Added Import from Excel spreadsheet option
Import Tool: Performance improvements for generating inserts from imported file
Import Tool: Added do not show column names in generated inserts option
Connection Wizard: Added support for Interbase database
Connection Wizard: Added support for Solid database
Connection Wizard: Added support for the H2 database
Connection Wizard: Added support for SQL Server instances using the default jTDS driver via the host field by separating the host or ip and the instance with a \
Connection Wizard: Added configurable ssl and sslfactory options to built-in PostgreSQL driver
Connection Wizard: Added configurable autoReconnect, useCompression, and noDatetimeStringSync options to the built-in MySQL option
Connection Wizard: Added configurable bindAddress, instance, and ssl options to the built-in jTDS driver for SQL Server
Connection Wizard: Added configurable jdbc url properties for SQL Server, PostgreSQL, and MySQL built-in options
Connection Wizard: Oracle - Added connect as SYSDBA and SYSOPER option
General: Added Next Tab (Alt-N) and Previous Tab (Alt-P) to the window menu
General: Added Close All Except Current Window option to the Window and File menus
General: Added Close All Query Results Except Current option to the Window menu
File System Browser: Added ability to move files and directories
File System Browser: OS X: Delete files now moves files to trash
File System Browser: OS X: Non-empty directories can now be deleted (moved to trash)

Changes

Connection Wizard: Switched default to JConnect from jTDS for Sysbase JDBC driver
Connection Wizard: Auto-correct driver location on the profiles if RazorSQL is moved
Connection Wizard: HSQLDB and Derby Embedded driver now allows users to select a directory instead of a file for existing databases
Launcher: Do a check for gcj GNU java since it is not supported
General: Upgraded to latest version of JGoodies look and feel libraries for Windows and Linux
General: SQL Restrictions: Restrictions now applied at time of execution instead of preventing certain tools from being active
General: Default query timeout changed to 5 minutes
General: Default connect timeout changed to 2 minutes

Bug Fixes

Sybase: Data types not populating with auto-commit off for jTDS driver
Sybase: nvarchar and nchar not getting wrapped in Edit Table Tool for jTDS driver
Edit Table from Query Results: Queries with no where clause but order by clause throwing error when trying to edit
Edit Table Tool: For tables with no primary keys, clicking on the SQL tab without selecting keys throws error messages
General: If trying to open a file that is already open that has been modified, incorrect file may get reloaded
Drop Table, Drop View: Generate SQL option on the drop table and drop view option from the database navigator not changing table when the table changes in the dropdown

4.1.2

Enhancements

Query Results Tab: Added Copy Results to Clipboard option
Query Results Toolbar: Added select all and copy selected icons
Query Results Table: Added select all option to context menu
Export Tool: Allow to export multiple tables as SQL insert statements
Compare Files: Now auto-populates with the last two opened files
Database Navigator: SQLite, Derby Embedded, and HSQLDB Embedded - Added option to create new database
SQLite: OS X - Added ability to attach databases
Edit Table Tool: Table now expands as window expands
Added release unused memory option to the help menu

Changes

Query Builder: Default operator for select now set to =
Filter Navigator: Added option to remember filtered objects per connection profile
Edit Table Tool: Minimum size of edits in new window window now bigger
Database Navigator: Sybase databases are now sorted

Bug Fixes

Edit Table Tool: MySQL tables with unique keys throwing validation error when launching the edit table tool
Edit Table Tool: If editing query results, and table name was not queried using the database recommended case, potential problems determining keys can occur
Query Builder: * is getting wrapped in quotes
Table Lookup: Tables with spaces not always getting displayed correctly
File Tree Navigator - Windows - On re-opening, size is very small
Auto column lookup - Lookup not working for all join types
Database Navigator: Sybase, when auto-commit is off, tables, views, system tables, procedures, and primary keys not displaying correctly
SQLite: Cannnot connect to an empty database file
SQLite: Connecting to a database file that does not exist does not create the database file
SQLite: Not always handling tables with spaces correctly
SQLite: Not handling columns that have spaces correctly

4.1.1

Changes

Edit Table Tool: Throw a warning message if the user exits the edit table tool without committing changes
Edit Table Tool: Change the commit/execute icon from a blue checkmark to a save icon
Create Table Tool: Convert column and table names to database vendors default case if not wrapped in delimiters by user
Alter Table Tool: convert column name in Add column option to database vendors default case if not wrapped in delimiters by user
Database Navigator: Changed text for Schema to Owner for Sybase, SQL Anywhere, and SQL Server pre 2005
Connection Wizard: Profiles are now listed in alphabetical order
Connection Wizard: For Oracle, service name and sid are now consolidated into one option with a radio button for the Thin Driver selected
General Tools: Added a preference for whether or not to wrap database objects when generating SQL from the tools. For example, CREATE TABLE "TABLE_NAME" or CREATE TABLE TABLE_NAME, etc.

Bug Fixes

General Tools: Database objects with hyphens not being represented correctly in queries
General Tools: For databases that have strict case sensitivity, database objects that are explicitly created using a non-default case are not being wrapped correctly for the database navigator, create, alter, and drop tools, query builder, export tool and import tool
Database Navigator: Firebird - Not getting columns correctly for mixed and lower case tables
Query Builder: SQL Anywhere: Unable to get columns when launched from the tools menu

4.1.0

Enhancements

General: Added built-in navigator and connection support for Sybase SQL Anywhere
General: Added built-in navigator and connection support for Firebird
General: Added built-in navigator and connection support for Informix
General: Added built-in navigator and connection support for FrontBase
General: Added built-in navigator and connection support for OpenBase
General: Added built-in navigator support for Ingres
General: Added support for allowing spaces in databases, schemas, tables, columns, etc. for databases that support this type of naming
General: Added support for querying, modifying, etc. objects that have spaces in the name
Edit Table Tool: Enhanced look and feel, added toolbar, and increased editable space
Edit Table Tool: Added search functionality
Edit Table Tool: Added button to allow cell editing in new window
Edit Table Tool: Added replace and replace all functionality
SQL Editor: Make it so double-clicking a table cell brings up edit tool with the correct cell in editable mode
SQL Editor: Add edit menu item to query table context menu
SQL Editor: Add edit menu item to query results cell context menu
SQL Editor: Added toolbar to query results section with sort, filter, search, edit, re-execute, export, compare, view query options
SQL Editor: Added Row Count value to the status bar for queries executed with the "Fetch All Rows" action
SQL Editor: Enhance auto column lookup for pre from clause aliases for multi-table joins
Create Table Tool: Added engine type option (InnoDB, MyISAM) for MySQL
Create Table Tool: Added enumeration option for MySQL
Create Table Tool: Added ability to add Check constraints
Create Table Tool: Added identity / auto-increment for the major databases that support it.
Create Table Tool: Added default value
Create Table Tool: Added ability to add scale to decimal values
Create View Tool: Added schema dropdown to the create view tool
Alter Table Tool: Added scale and Not Null options to the Add Column section
Alter Table Tool: Added ability to add check constraints
Alter Table Tool: Added ability to select multiple columns for adding foreign keys
Alter Table Tool: Added ability to drop columns
Alter Table Tool: Added ability to drop constraints
Alter View: Added Alter View Tool
Added Query Scheduler tool to schedule queries for various intervals and number of executions and write the output to a file
Added Create Trigger Tool*
Added Edit Trigger Tool*
Added Drop Trigger Tool*
Added Drop View Tool*
Added Drop Table Tool
Added Drop Index Tool*
Added Create Index Tool*
Added Create Sequence Tool*
Added Drop Sequence Tool*
Added Drop Procedure, Function, Package, and Package Body Tool*
Informix: Added support for viewing, creating, and editing procedures, functions, and triggers
Ingres: Added support for creating, editing, and dropping procedures
SQL Anywhere: Added support for creating, editing, and dropping triggers and procedures
Firebird: Added support for creating, editing, and dropping triggers and procedures
Derby: Added support for creating and dropping triggers
Connection Wizard: Auto JDBC URL configuration added for Firebird, FrontBase, Ingres, Daffodil DB, Mckoi, MimerSQL, Pointbase, Teradata, and Informix
Connection Wizard: Added create=true onto derby and daffodil connection urls
Connection Wizard: Added Embedded option for Daffodil DB / One$DB
Connection Wizard: MySQL: Automatically add the ?noDatetimeStringSync=true for MySQL Connector/J 3.1.7 or later.
Connection Wizard: Added download button for JDBC drivers for Ingres, MimerSQL, Pervasive, and Teradata.
Tools: More databases now prepopulate the current database and/or schema on dropdowns
Database Navigator: Added additional Create, Alter, and Drop options
Database Navigator: MySQL - Added View DDL option for tables and views
Database Navigator: SQLite - Added View DDL option for tables, views, indexes, and triggers
Database Navigator: Oracle - Added View DDL option for tables, views, indexes, constraints, sequences, materialized views, procedures, function, packages, package bodies, and triggers
Database Navigator: OpenBase - Added triggers and users
Database Navigator: FrontBase - Added functions
Database Navigator: HSQLDB - Added indexes for table and users
Database Navigator: Ingres - Added indexes and sequences
Database Navigator: SQL Anywhere - Added indexes and triggers
Database Navigator: Firebird: Added functions, triggers, indexes, sequences, and users
Database Navigator: Derby - Added indexes and triggers
Database Navigator: Informix - Added functions, triggers, indexes, and users
Database Navigator: Enhanced Database Navigator filter for databases with built in support
SQL Explain Plan: Added support for SQLite
Query Builder: auto-wraps columns with single quotes, etc. that need wrapping
Query Builder: Supports multiple tables in select and auto-generates join clauses

Changes

Edit Table Tool: If the keys are found, don't prompt the user for them, just go straight to the edit table page.
General: FrontBase - remove databases dropdown from tool and navigator
Execute Procedure Tool: Added support for Ingres NCHAR and NVARCHAR
Export Tool - Deselect export column names by default, pre-select delimited file with comma preselected
Export Tool - Changes in handling on null/empty values If a date, time, or timestamp column is empty, represent as null. If a non-character column is empty, represent as null If a character column is empty, check whether it is null or empty string in the table. Represent accordingly.
Import Tool - Changes in handling of null/empty values. If a date, time, or timestamp column is empty, represent as null. If a non-character column is empty, represent as null. If a character column is empty, represent as '' (empty string) If a character column is the null string, represent as null
Edit Table Tool - Changes in handling of null/empty values If a date, time, or timestamp column is empty, represent as null. If a non-character column is empty, represent as null. If a character column is empty, check whether it is null or empty string in the table. Represent accordingly

Bug Fixes

General: Several bug fixes regarding Informix functionality in the Database Navigator, SQL Editor, and general tools.
General: Table lists not populating correctly for SQL Anywhere
Connection Wizard: Firebird jaybird files no longer required to be in the system java extensions folder
Connection Wizard: When the driver has already been loaded, the error message is flickering and then not displaying again
Connection Wizard: Derby Network Server - built-in driver derbyclient.jar file had incorrect name.
Edit Procedure Tool: SQL Server Edit procedures and functions. Not generating Alter statement correctly if first line is a comment or nonstandard create procedure or function statement used.
SQL Editor: If the focus is in the sql editor, and a query is executed, should keep the focus in the sql editor
Database Navigator: MySQL Show Info on indexes throws query error
Database Navigator: Not all context menu options avaiable for System Tables
Preferences: Auto column and Auto Table lookup prefs. Need to turn both off to prevent each type of lookup
Help: SQL Server Authentication file not showing up
Setting connect timeout to 0 in the preferences does not disable the connect timeout
RazorSQL JDBC Bridge, describe table not always showing column information.
Query Builder Tool: Not showing system tables in the tables dropdown for certain databases
Edit Table Tool: When deleting rows after a newly inserted row, data is not showing correctly
Edit Table Tool: Date, Time, and Timestamp columns not wrapped in single quotes for Oracle, Firebird, PostrgreSQL and potentially other databases
Edit Table Tool: Money column not wrapped in single quotes for PostgreSQL
Edit Table Tool: Derby - not representing date, time, and timestamp columns correctly
Tools: System tables not always showing in dropdowns
RazorSQL SQLite Driver - Updated Rows always is showing -1
Derby - Auto table lookup, tables are showing up twice
Auto Table Lookup - FrontBase - Table names are not always sorted
Create Package and Create Package Body Tools: Schema value ignored
Columns with sizes greater than Integer.MAX_VALUE not displaying properly on the database navigator
RazorSQL JDBC Bridge - Get procedure columns not implemented correctly
Alter Table Tool - Syntax for Informix not correct
Query Builder - Update builder not always generating all columns in where clause

4.0.2

Enhancements

General: Added built-in Derby support and bundled with Derby drivers
General: Added ability to open a new session and share a current connection via File -> New Session (Share Connection) and Actions -> New Session (Share Connection)
General: Added ability to open a file and have the new session created share a current connection via File -> Open (Share Connection)
General: Added a View -> Show Editor Only option to only show the sql / programming editor
General: Added a View -> Show Default View option
General: Added a toolbar and more tools to editor popup text windows
General: Allow multiple instances of the tools windows to be opened at the same time
SQL Editor: Added SQL Formatter
SQL Editor: Added more functions and procedures to the auto function lookup for Transact SQL
SQL Editor: Enhanced auto table lookup tool
SQL Editor: Added order by and group by support to the auto column lookup tool
SQL Editor: Enhanced auto column lookup tool for where and set keywords
SQL Editor: Fetch All now fetches and displays all result sets if multiple result sets are returned by a query
SQL Editor: Add more Oracle sys procedures/packages and built-in functions to syntax highlighting and function lookup
SQL Editor: Add more SQL Server sys procedures and built-in functions to syntax highlighting and function lookup
SQL Editor: Add more Sybase sys procedures and built-in functions to syntax highlighting and function lookup
SQL Editor: Add MySQL built-in functions to syntax highlighting and function lookup
SQL Editor: Add PostgreSQL built-in functions to syntax highlighting and function lookup
SQL Editor: When cancelling a query, show any warnings from the statement
SQL Editor: Added ability to cancel all user initiated operations and most system initiated operations
Database Navigator: Added Indexes and Sequences to the HSQLDB system database navigator
Database Navigator: Added JDBC URL format for mckoi database
Database Navigator: Added an export tables (for schemas / databases) option
Export Tool: Added system tables to the export tool tables dropdown
Table Lookup Tool: Added system tables for databases that specify system tables
Connection Wizard: Added Pervasive to the database type list
Connection Wizard: Added support for HSQLDB Embedded connections
Connection Wizard: Added support for Derby Embedded connections
Help: Improved and reformatted help documentation
Edit Table Tool: Remember selections for edit in new window option

Changes

SQL Editor: Change default SQL History retain number to 20,000 lines
SQL Editor: Exeute all option stops executing after a query error occurs
SQL Editor: Changed default auto lookup delay to 500 milliseconds
Database Navigator: Oracle system navigator - changed to list all schemas that contain objects, not just tables, views, synonyms, or sequences

Bug Fixes

Import Tool: Import tool throwing parsing error when the import file had just delimiters and no values between them
General: Connecting to built-in database does not put the cursor in the SQL editor
General: Closing a tab was not always closing all resources on a connection before closing the connection
SQL Editor: Fetch all not fetching all rows
SQL Editor: If going from PL/SQL, TSQL, or SQL PL syntax type from on session to a different PL/SQL, TSQL, or SQL PL sytnax type, the syntax highlighting was reverting back to default SQL Type
SQL Editor: Can not search for spaces in Find or Find in Files tools
SQL Editor: Cut and paste key bindings missing from popup editor windows
SQL Editor: Re-execute query ignoring whether the query was executed with the fetch all options
SQL Editor: Search -> Replace All - match word option not always matching whole word
SQL Editor: Search -> Replace All - not working correctly for multiple char string when the char occurrence occurs back to back
SQL Editor: When specifying a fetch size in the preferences, for drivers that do not support specifying the fetch size, errors were being thrown
Edit Table Tool: Not always determining correctly that a column should be wrapped in single quotes
DatabaseNavigator: Driver Option: BASE TABLE type not being displayed in the navigator for Frontbase
DatabaseNavigator: SQL Server show info option for procedures throwing a query error
DatabaseNavigator: When using Sybase JConnet 6.0 driver, column names not showing the navigator
Procedure Tools: Menu item erroneously enabled for unsupported db's if connected to another db with procedure tool support

4.0.1

Enhancements

General: Added built-in SQLite support
Export Tool: Added ability to export all tables in a schema/database
Export Tool: Added dropdown for delimiter to support tabs and spaces
Export Tool: Added support for line breaks for delimited files with the Combine All Data option
Auto Table Lookup: Added schema/database support
Edit Table Tool: Added ability to edit text in a separate window
Edit Table Tool: Display enhancements
Edit Table Tool: Support for line breaks
Edit Table Tool: Remember size and location of window
Import Tool: Add dropdown for delimiter to allow tabs and spaces for delimiters
Import Tool: More descriptive error messages for parsing problems
Import Tool: Added support for line breaks with the Parse Entire Contents of File option
Connection Wizard: Added Teradata to list of database types
File System Browser: Added a Get Info button for files and directories

Changes

MySQL PHP Bridge: Removed unnecessary calls to mysql_free_result
MySQL PHP Bridge: Throw a warning if the most recent version of the bridge is not being used
Java Required Launching: Created different shell scripts for os x and unix/linux.
Import Tool: Automatically have escape single quotes checked.
Export Tool: Changed the formatting of the export as text option if there are line breaks
Database Navigator: PostgreSQL - no longer use the database name as the first qualifier in the query since it is not supported by all PostgreSQL versions
Edit / Create Procedure Tool: Added line breaks at the end of text
File System Browser: Size display no longer modal and allows copying of values
General: PostgreSQL - If auto-commit is set to off and an error occurs, rollback to the previous savepoint to prevent transaction errors
General: Memory check is no longer done when opening a zip file
General: Change checkboxes to radio buttons on Sort Query Results
MySQL Auto Install: Changed United Kingdom mirror location
Describe Table: Removed columns auto-increment, readable, and writable due to inability to accurately determine values
Connection Wizard: Removed SAP DB from the database list
Connection Wizard: Removed JDataStore from the database list

Bug Fixes

MySQL PHP Bridge: Line breaks in data not handled correctly
Edit Table Tool: Line breaks were not supported
Edit Procedure/Function Tool: SQL Server - Procedure contents getting cut off after 4000 chars on SQL Server 2000 and 8000 chars on SQL Server 2005.
Connection Wizard: When creating a profile as type OTHER, new profiles unable to be added
Help: Added missing MySQL PHP Bridge help files
Import Tool: When deselecting a column, the wrap quotes box was getting deselected also
Import Tool: When changing the delimited file via the browse button, the start and end row were not getting updated
File System Browser: When deleting multiple files, the browser is not refreshing propertly
Create Table Tool: If the first column is a CHAR, not populating the length
Editor: Appending extra line break when opening files
Java Required Launching: razorsql.sh shell script did not run on unix/linux because of OS X specific commands

4.0.0

Enhancements

Tools: Added RazorSQL MySQL PHP Bridge for connecting to MySQL databases via a web server running PHP
Tools: Added RazorSQL JDBC Bridge for connecting to databases via a J2EE application server
Tools: Added view stored procedure/function tool
Tools: Added edit stored procedure/function tool
Tools: Added create stored procedure/function tool
Tools: Added create view tool
Tools: Added database/catalog and schema dropdown to all applicable tools
Edit Table Tool: Allow where clause is query to get data to edit
Create and Alter Table Tool: Disabled length field on create table tool and alter table tool for columns that do not allow lengths to be specified
Connection Wizard: Show file DSN ODBC datasources in the ODBC dropdown.
Connection Wizard: Allow users to use file DSN's to connect via ODBC
Connection Wizard: Added separate option for Oracle 9i OCI driver
Connection Wizard: Added * to text on add connection profile indicating which drivers are shipped with RazorSQL
Execute Procedure Tool: Add OracleTypes.CURSOR to list of types for Oracle
Execute Procedure Tool: Added Execute function option
Execute Procedure Tool: Auto populate functions, procedures, and column info
Execute Procedure Tool: Output of procedures is now formatted
Execute Procedure Tool: Enhanced tool for SQL Server and Sybase
Database Navigator: Enhanced system queries across all built-in db types (DB2, MySQL, Oracle, PostgreSQL, SQL Server, and Sybase)
Database Navigator: View contents for procedures, functions, packages, etc. now displayed in an editor window instead of the query results window
Database Navigator: Addded column information for functions for PostgreSQL system navigator
Database Navigator: Added column information for procedures and functions for MySQL system navigator
Database Navigator: Added triggers to Sybase system navigator
Database Navigator: Added users to Sybase system navigator
Database Navigator: Added indexes for tables to Sybase system navigator
Database Navigator: Added constraints for tables to Sybase system navigator
Database Navigator: Added system stored procedures to SQL Server system navigator
Database Navigator: Added indexes and sequences to DB2 system navigator
Database Navigator: Added constraints to DB2 system navigator
Database Navigator: Added ability to view function content to DB2 system navigator
Database Navigator: Added triggers for table to DB2 system navigator
Database Navigator: Enhanced the display of columns for functions and procedures
Database Navigator: Always show current schema in database navigator even if there are no objects yet created in the schema
Database Navigator: Performance enhancements for getting table columns
General: Improved performance of describe call
General: Added auto table lookup option
General: Added disconnect all option
General: Added the ability to set a connection timeout
General: Added the ability to set a query timeout
Templates: Added a PHP template for connection to MySQL
Editor: Added the ability to execute any type of statement with Execute All instead of just batch statements
Editor: Added option to select fixed width fonts or all fonts when seleting fonts
Editor: Added SQL functions to the PL/SQL and SQL PL auto function lookup results
Editor: Tie default syntax highlighting to database type: Oracle = PL/SQL, DB2 = SQL PL, Sybase and SQL Server = TSQL, all others SQL by default
Editor: Added colored line number to help indicate what line the cursor is on
Editor: Enhanced the line numbers so that font changes more appropriately with font changes in the editor
Editor: Show compile errors for Oracle when creating procedures, packages, or functions
Popup Editor: Added cut, copy, paste, and select all to right-click menu

Changes

Database Navigator: Only reload navigator on DDL statements if the navigator is present
Database Navigator: Removed toolbar.
Database Navigator: DB2 versions 8 or newer now default to use system queries instead of driver calls
Database Navigator: Driver Option: No longer look for keys for views
General: ODBC connection type uses system queries if supported
General: Adjust height if a standard height is found
General: If changing the font for the editor, the fixed width font option is selected by default
General: If types are used in a tool, and there are multiple types for the same data type, the biggest type found is used
General: Query log button now gives option to show log of current connection or all SQL history
General: Always enable connect to built-in db. If already connected, have a new connection tab created
General: Always enable connect option. If already connected, have a new tab created
General: Added a view license agreement option as part of the MySQL auto-install process
General: Implemented work-around for limitation of some drivers with regards to determining database major version
General: Changed the call to get the current user in SQL Server 2005 as it differs from the SQL Server 2000 call
General: If performing an action with a tool that was opened in a connection tab that is not currently the active tab, automatically switch to the appropriate connection tab
General: Made drop-down boxes editable where appropriate
General: Invalid character error on Oracle - include a warning message if the query ends in a semi-colon and does not appear to be a PL/SQL block
Query Results: Results are sized based on visible rows plus the fetch size up to a limit
Editor: When determining column count, tab stops are now factored in instead of assuming tab length is a constant (applies to variable width fonts only)
Editor: If there is not enough memory to open a file, the error is now always displayed
Timer: Uses more accurate method to get time
Describe: Describe call when there is an empty results window no longer closes the empty window
Execute Procedure Tool: DATE is now allowed in MM/DD/YYYY format
Execute Procedure Tool: the CHARACTER data type is now supported for DB2
Execute Procedure Tool: Made output text area bigger
Execute Procedure Tool: Included the schema and catalog when calling the procedure, function, or package
Execute Procedure Tool: Column types are validated to determine whether RazorSQL supports them prior to having the use enter the input data
Connection Wizard: Changed Oracle OCI driver to Oracle 10g OCI driver and added Oracle 9i OCI driver option
Templates: Changed data type in PostgreSQL function template example from numeric to integer
Driver: Upgraded built-in DB2 driver to DB2 Universal Driver 3.1
Driver: Upgraded built-in PostgreSQL driver to 8.2.-504
Driver: Upgraded built-in Oracle driver to 10.2.0.3
Filter Query Results: Removed restriction that equal or not equal comparisons had to be numeric
Filter Query Results: Increased width of filter query results window
Sort Query Results: How the sort is done is now based on the data type of the column
Connection Wizard: Auto-detect Sybase JConnect driver if newer version is found
Connection Wizard: Once connect is clicked, disable the button until the connection process is complete
Connection Wizard: Changed check boxes to radio buttons where appropriate
Connection Wizard: If no profiles are setup, prompt user to select a db type before displaying the wizard
Tools: Only pre-populate the last table name in dropdowns if the table exists in the dropdown or if the dropdown does not contain data
Create Table Tool: Have the execute SQL button take the SQL that is actually in the text area instead of regenerating it
Query Log: Log gets cleared when reconnecting on a closed connection using the same tab

Bug Fixes

SQL Editor: Fixed problem with the exec command not returning results when it should have
Connection Wizard: System DSN ODBC data sources were not always shown in the ODBC dropdown
Combo Boxes - (Mac Only): Hitting enter on certain combo-boxes caused a "Please select table name error"
General: Dual Screens - Popups were not appearing in the correct location
General: When using JRE 1.5 or later, machines with resolutions less than 1024/768 were starting with an initial width that was very small
General: If all tabs were closed, connecting was not creating a new window
General: Selecting a file from favorites was not adding the file to the recent files list
Search - Replace Range: Columns may not have been determined correctly if tabs were present
Database Navigator: Multiple connections on the same tab caused navigator menu items to not be enabled correctly and caused incorrect system queries to be run
Registration Window: Verify code message text was not displayed properly
Editor: When saving a file with an extension that is not a recognized syntax type, the syntax highlighting was changing back to SQL. Now it stays at what it was on before the file save
Create Table Tool: The Unique constraint was not being handled properly for all databases
General - Disconnect All was only enabled on tabs that were connected

3.8.0

Enhancements / Changes:

Connection Wizard: Added option to restrict type of statements executed on the connection (Read Only, Read / Write, Read / Write / Delete, No Restrictions)
Connection Wizard: Added ability to save the connection profile even if the connection fails
Connection Wizard: Last connection profile is remembered on exit
Database Navigator: MySQL versions prior to version 5 now show primary and foreign keys
Database Navigator: Default to use Driver calls when connection type is ODBC
Database Navigator: Format for display of system table columns for SQL Server improved
Database Navigator: Displays more data for SQL Server 2005
Database Navigator: Enhanced information available for non current databases/schemas for SQL Server
Database Navigator: Oracle: If no objects are in the user's current schema, show the schema in the navigator anyway.
Database Navigator: PostgreSQL RazorSQL specific queries - only show the current database
Print: Query Results - Enhanced query result printing.
Print: Editor Contents - Enhanced editor contents printing.
SQL: Added Explain Plan for DB2, HSQLDB, MySQL, Oracle, PostgreSQL, SQL Server, and Sybase
Tools: Added Tools -> Table Lookup
Tools: Table dropdowns for all applicable tools are prepopulated with tables and/or views for the current database/schema
Tools: Remember last table acted upon for all tools with table/view dropdowns
Tools: Added Tools -> Execute shell/batch script tool
Tools: Added Tools -> Execute OS Command
Tools: Export - Added ability to export to .xls (Microsoft Excel format)
Tools: Export - When exporting as HTML and no extension is provided, a .html extension is added to the file
Tools: Export - When exporting as XML and no extension is provided, a .xml extension is added to the file
Tools: Export - Added option to include column names in exported data
Tools: Export - Added option to export as text.
Actions: Added Disconnect All Option
Actions: Added View SQL History options. Stores the last 2500 lines of SQL. Can be configured in the preferences
Actions: View Meta Data - Added current catalog/database and current schema values
Editor: The connection name and file name are now shown in the tab
Editor: Auto column lookup - Enhanced auto column lookup when aliases are used before the alias is defined
Editor: Auto column lookup - Now supports aliasing for delete statements
Editor: The statement executing window displays a timer that shows the number of seconds executing
Editor: Added Sticky Copy - Cmd/Ctrl - Shift - C
Editor: Added Sticky Cut - Cmd/Ctrl - Shift - X
Editor: Added Sticky Paste - Cmd/Ctrl - Shift - V
Editor: Added File -> Open URL option
Editor: Increased Undo/Redo limit to 1000
Editor: Added preference for showing/hiding line numbers
Editor: Added font tab to the preferences menu
Editor: Remembers the cursor position of closed files when they are reopened on startup
Editor: If File System Browser is visible, in the right-click menu on the tab is the Set as File System Browser path option. Sets the path of the File System Browser to the path of the current file
Editor: Added Edit -> Date/Time option
Editor: Added Edit -> Ascii Table option
Editor: Show current caret position and total length on the status bar
Editor: Column number starts at 1 instead of 0
Editor: Replace Range - changed so that if the line length is less than the to column, still adds replace text
File System Browser: Selects the actual file, not just the parent directory when a file is specified
File System Browser: Removed row of buttons from the toolbar
Query Results: Name no longer pops up when clicking column. Instead added Copy to Clipboard option in right-click menu
Query Results: Enhanced column resizing so that scrolling to visible colums with larger widths adjusts the column widths
Query Results: Sort - After sort, ResultSet is frozen
Query Results: Filter - After filter, ResultSet is frozen
Status Pane: Added text All Rows Retrieved if there are no more rows available for a result set
Status Pane: Removed unnecessary colon from beginning of query text display
Status Pane: Made popup windows resizable
Windows Vista Updates - Made changes to prevent authorization popups
Look and Feel: When opening a new connection profile, the sizes and dimensions from the last window are used
Look and Feel: Changed word wrap style to not wrap in the middle of words for the message display
Look and Feel: Query results row padding changed from 10 to 1
Look and Feel: Added separators to Text menu
Look and Feel: Split General preferences tab into SQL and Editor
Look and Feel: Default Fonts. Appropriate default fixed and display fonts are used depending on the operating system
Look and Feel: Changed query results table background to white on Windows
Look and Feel: Made a max column width of 80 chars for messages in message pop-up
Look and Feel: Put a max size on the Query Builder and Connection Wizard for JRE version 1.5 and later systems
Look and Feel: Made default color for quotes darker
Look and Feel: Changed Query Builder to a dialog instead of separate window
Windows: Updated Java Runtime Environment to 1.6.0

Bug Fixes

Launcher: RazorSQL does not launch when there was a sub-directory in the Java extensions directory.
Tools: Zip Utility - When opening a zip file, the file stream was not getting closed when another zip file was subsequently opened.
Tools: Describe - Keys tab - multiple key columns were not separted by spaces.
Tools: Describe - Checks if table exists before doing a describe
Tools: Export - should check if the table exists before prompting for the type of file to be created
Tools: When executing generated statements, a semi-colon was getting added at the end. Caused SQL errors in certain databases
Tools: Column Name Lookup - If no column names found, the dialog would not close
Tools: Query Builder - If table did not exist, the dialog would not close
Tools: Edit Table - Column numbers not displayed correctly once the number of columns reaches 100.
Query Results: More rows were attempted to be fetched even after there are no more rows in the ResultSet or the ResultSet was closed
Query Results: Potential for infinite loop after filtering query results
Query Results: If only one result after filter, the result may not have been displayed
Database Navigator: View Content button was not getting disabled on disconnect
Database Navigator: SQL Server - not all nodes were sorted
Database Navigator: Unable to use RazorSQL custom database queries via ODBC driver
Database Navigator: User custom queries: schema query was not working correctly for some databases that don't allow access of the same ResultSet index more than once
Database Navigator: Unable to use RazorSQL custom database queries for Microsoft JDBC drivers
Database Navigator: Schemas were not always sorted using JDBC navigator option.
Editor: Auto column lookup - Window was sometimes showing up at the end of the line's text instead of after the (.)
Editor: Query Parser - When only one semi-colon was in the editor, the query parser was not correctly identifying the query to run.
Editor: Auto column lookup - Not always working for update statements
Editor: Horizontal scroll bar was not working correctly in certain situations
Editor: Select Next Line - behavior was not always correct
Editor: Select Previous Line - behavior was not always correct
Editor: Auto class lookup was not working for JSP pages
Editor: Replace All - Wrap search was ignored
Editor: Replace All - May not replace all occurrences in certain situations
Editor: Replace All - Selected lines option only replaced one line
Editor: Replace Range - tab length was not being factored in
Editor: If closing a file and warn if modified preference is set, a prompt was showing asking to reload the file
Editor: Status Panel, initial values were incorrect
Editor: Unable to reload a read-only file
Editor: If all query tabs are closed, unable to execute a select_exec query
Editor: select_exec call not opening up a new query tab
Connection Wizard: When switching connection types in the add profile tab, the values were getting cleared. Only values not applicable are now cleared.
Connection Wizard: If user id is supplied and password is not, pass null for the password value
File System Browser: When selecting multiple files and hitting delete, the incorrect files were sometimes getting deleted
File System Browser: When opening a file via the file system browser, the file was not getting added to the recent file list
File System Browser: Up one level should go to the previous directory even if a file is selected
Look and Feel: When displaying the connection wizard and query builder, the height of the window was not at tall as the previous displayed height, and may shrink for each time displayed.
Look and Feel: HTML Link cursor did not show up on the connection profiles panel when hovering over clickable labels
Look and Feel: Tools - Meta Data - schema term and schema length backgrounds did not match the rest of the backgrounds
Look and Feel: Connection Wizard - sizing issues
Look and Feel: Query Builder - sizing issues
Look and Feel: Editor - The tab title was not displaying properly on connect or disconnect when the connection profile name was very long
Look and Feel: Message boxes not displaying properly for some graphics cards
Look and Feel: Multiple dialogs no longer can be opened for the same action
Look and Feel: There were two scrollbards on the connection profiles pane
Look and Feel: Windows Authentication field had incorrect font in add profile tool.
Look and Feel: File Compare tool had two scrollbars.
Look and Feel: Added wait cursor to the describe dialog popup

3.7.0

Enhancements:

Connection Wizard: Added auto-install option for MySQL that automatically downloads and installs the MySQL Connector/J driver.
Connection Wizard: Upgraded the HSQLDB driver to version 1.8.0.7.
Built-in Database: Upgraded to HSQLDB version 1.8.0.7.
Query Results: Added the ability to sort query results.
Query Results: Added the ability to filter query results.
Database Navigator: Enhanced custom RazorSQL system queries for Oracle, PostgreSQL, MySQL, SQL Server, and DB2.
Database Navigator: By default use custom system queries for Oracle.
Database Navigator: By default use custom system queries for PostgreSQL.
Database Navigator: By default use custom system queries for SQL Server.
Database Navigator: By default use custom system queries for MySQL.
Database Navigator: Configurator: Updated to reflect new changes for custom system queries.
Database Navigator: Changed column format displayed when populating from driver calls.
Database Navigator: Changed column format displayed when populating from RazorSQL custom system queries.
Database Navigator: Primary key columns now displayed in bold and in blue.
Database Navigator: Foreign key columns now displayed in bold and in purple.
Import Tool: Added option to escape single quotes.
Export Tool: Added option to escape single quotes.
Templates: Sample Database: Rearranged the query order and cleaned up the queries.
Templates: Sample Database: Fixed the problems with null values that cause problems on Sybase.
Templates: Sample Database: Fixed the capitalization problems
SQL Editor: If the database driver does not accept the describe command, invoke the RazorSQL Describe tool.
SQL Editor: If not in SQL mode, do not try to separate queries by looking at semi-colons.
Editor: Syntax Highlighting: Allow users to use custom font weights and colors for Syntax Highlighting located in the Preferences -> Syntax Highlighting -> Customize tab.
Editor: Added Wrap at Column Number feature located in Edit -> Text.
Editor: Added Unwrap Text feature located in Edit -> Text.
Editor: Improved the Format to Fit Screen option
Editor: Added option to convert text to Windows line break format.
Editor: Added Search -> Replace Range functionality
Editor: Added Edit -> Text -> Append Text to Lines tool
Editor: Added Edit -> Text -> Prepend Text to Lines tool
Edit Table Wizard: Removed limitation on max number of rows to be returned to edit.
Status Panel: Clicking in the Status Panel brings up a window with the status text.
Query Log: Query Log windows updates in real time if it is visible.
File System Browser: Now starts at the user.home location if no location is saved.
File System Browser: Added Show Parent Directories and Hide Parent Directories to the right-click menu
File System Browser: Remembers the last location on startup.
File System Browser: Added Favorites, Recent Files, and Recent Directories to right-click menu.
Favorites: Allow navigating through sub-directories from the Favorites menu.
Look and Feel: Improvements to make sure proper maximum screen size is used to calculate the initial window size.
Look and Feel: Added View menu that allows users to show/hide the Database Navigator, Programming Editor, File System Browser, Query Results, and Status Panel.
Look and Feel: Remember the size of the Database Navigator Panel.
Look and Feel: Remember the size of the Programming Editor Panel.
Look and Feel: Remember the size of the Query Results Panel.
Look and Feel: Remember the size of the Status Panel.
Look and Feel: Remember the size of the File System Browser.
Look and Feel: Added Toolbars menu that adds or removes groups of icons from the Toolbar.
Look and Feel: Removed non-essential icons from the Toolbar by default.
Look and Feel: Remember both size and location of the main window.
Look and Feel: Remember both size and location of the Query Builder.
Look and Feel: Remember both size and location of the Connection Wizard.
Look and Feel: Removed the scroll bar from the Status Panel.
Look and Feel: Added SQL menu with SQL commands.
Look and Feel: Added additonal common commands to the File menu.
Look and Feel: Moved the Templates menu under the File menu.
Look and Feel: Moved the Format to Fit Screen option under Edit -> Text
Look and Feel: Registration screen now comes up after app launches.
Look and Feel: Added view license agreement button to registration screen.
Look and Feel: Progress window is now a non-modal dialog.
Look and Feel: Made all dialog windows resizable.
Look and Feel: Limited the sizes of drop down boxes on certain windows.
Help: Check for updates now launches a web browser instead of performaing a call behind the scenes.
Help: Added view license agreement button to the Help menu.
Help: Updated Tips of the Day.

Bug Fixes:

Favorites: View does not handle directories correctly when adding current directory to favorites.
File System Browser: Refresh on File System Browser should refresh the parent directory if a file is selected
File System Browser: Open of a JAR/ZIP file now launches the Zip Utility.
File System Browser: Scrolls to visible when expanding.
Database Navigator: For custom Oracle browsing, changed top level name from Catalogs to Schemas.
Query Log: Fixed scrolling problem in Query Log window.
SQL Editor: Fixed problem with stripping semi-colons from highlighted queries.
Alter Table Wizard: When error occurred, cursor remained the system wait cursor.
Connection Wizard: Progress manager not centered on window when attempting connection.
Connection Wizard: When editing the driver location on the profiles screen, the location change does not get saved.
Keep Alive: When a connection is dropped, the titles were not getting changed.
Database Navigator: System wait cursor remains after selecting View Content for JRE version 1.4 using Driver option.
Zip Utility: On Windows, the file name includes the full path and the path field is empty.

3.6.0

Enhancements:

Export Wizard: Added option to export as SQL insert statements
Export Wizard: Allow to export in any delimited format.
Import Wizard: Allow to import in any delimited format.
Import Wizard: Pre-population of "Wrap in Single Quotes" values based on data type and driver calls
Connection Wizard: (Windows Only) Added Windows Single Sign-On support for SQL Server.
Connection Wizard: Added Windows Authentication support for SQL Server.
Connection Wizard: Added built-in charset support for Oracle.
Connection Wizard: Upgraded Oracle drivers to 10g version 10.2.0.2.
Connection Wizard: Upgraded DB2 Universal drivers to version 2.10.
Connection Wizard: Allow selection of multiple files for selecting driver locations.
Connection Wizard: Profile Tab: Allow to manually edit driver location.
Edit Table Wizard: Allow generated SQL to be changed before executing.
Edit Table Wizard: Add option for escaping single quotes.
Edit Table Wizard: Added option to execute generated statements one statement at a time or in batch mode.
SQL Editor: Added semi-colon based parsing to determine which statements/queries to execute if no statements/queries are highlighted and there are more than one statement/query in the SQL editor.
SQL Editor: Changed maximum displayable columns to 10,000
SQL Editor: Auto-Column Lookup now runs in a separate thread.
SQL Editor: Auto-Column Lookup - added preference to either get the column names from a SELECT * query, or to get the column names from a driver call.
SQL Editor: Auto-Column Lookup values are cached by default, but reloaded if certain types of SQL statements are executed.
SQL Editor: Added preference for whether or not to cache Auto-Column Lookup values.
Programming Editor: Added a Zip Utility to view or extract single files or all files in archives in Zip or Jar format.
Keep Alive: If there is an error with the Keep Alive call and RazorSQL determines the connection is no longer present, an error message is shown and the disconnect is handled.
Keep Alive: Added preference to call disconnect if there is a communication error with Keep Alive.
Keep Alive: Added 1 minute option to Keep Alive.
Call Procedure Tool: Added CLOB support for Oracle.
Database Navigator: If the Database Navigator is reloaded, portions of the navigator that were expanded stay expanded.
Database Navigator: When creating, altering, or dropping objects, the Database Navigator automatically refreshes with the changes made.
Database Navigator: Added preference to choose whether to refresh the Database Navigator on create, alter, or drop.
Database Navigator: Copy on the column string only copies the column name, not the information between < and > brackets
Database Navigator: Added query to view stored procedure content for DB2 database specific navigator option.
Help Menu: Added View Log File option to the help menu.
Help: Added additional help documentation
Look and Feel: On startup, the main RazorSQL window defaults to the size of the main window the last time RazorSQL was shut down.
Look and Feel: Added preference to show only non-essential icons on the toolbar.
Look and Feel: Added a scrollable error message window for displaying error messages when the error messages are too large to fit in a non-scrollable window.
Look And Feel: General cosmetic and usability changes such as sizing and font adjustments, cursor icon settings, setting of default buttons, etc.

Bug Fixes:

Database Navigator: Fixed bug with export when selecting export from the Database Navigator right-click menu.
Database Navigator: Fixed inaccuracies with the column sizes displayed for numeric and date fields.
File Dialog: If the File Dialog prompts for whether or not to replace the file, do not prompt again.
Auto-Column Lookup: Fixed problem with Auto-Column Lookup not finding column names when parsing statements in mixed-case or upper-case.
Describe Tool: Fixed inaccuracies with the column sizes displayed for numeric and date fields.
Look and Feel: Fixed window sizing and window location problems when RazorSQL is not located in the upper-left corner.
Create Table Wizard: Fixed screen flicker problem that occurred when creating a table with enough columns to force the generated SQL area off of the viewable screen.

3.5.0

Enhancements:

Connection Wizard: Upgraded included PostgreSQL JDBC driver
Query Builder: Added group by support
Query Builder: Minimize Query Builder window on execution of query
File System Browser: Added single directory View
File System Browser: Added create folder functionality
File System Browser: Added editable path text field
Favorites: Added support for adding directories to favorites
Add Connection Profile: Added Apache Derby to the list of databases
Add Connection Profile: (Windows Only): Added dropdown of ODBC datasources defined on the machine for ODBC connections
Add Connection Profile: Added JDBC URL format and JDBC Driver class names for databases with no built-in drivers
Programming Editor: Added the following language support: Batch, C, CSS, C++, C#, JavaScript, JSP, HTML, PHP, Perl, Python, Ruby, Shell Script
Programming Editor: Added match tag tool
Programming Editor: Added close all option
Programming Editor: Added save all option
Programming Editor: Added templates for all languages
Programming Editor: Added default key ahead text for all languages
Programming Editor: Added more icons to the toolbar
Import Wizard: Added one at a time insert mode
Find / Replace: Added selected lines option
Find / Replace: Added count all option
Find / Replace: Added show found lines option
Find / Replace: Added whole word option
Find / Replace: Added wrap search option
General: Added help documentation
General: Windows Installer Version: upgraded included JRE to version 1.5.0_08

Bug Fixes

Database Navigator: Fixed error when launching tools from the navigator using the SQL Server ODBC driver
Programming Editor: Fixed how RazorSQL handles the exec command so that results can be returned and displayed
Call Procedure Tool: Added display of output when a procedure returns data other than the output params

RazorSQL

Query, Edit, Browse, and Manage Databases

RazorSQL Updates / Change Log

Enhancements

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Bug Fixes

Enhancements

Changes

Bug Fixes

Bug Fixes

Enhancements

Changes

Bugs

Enhancements

Changes

Bug Fixes

Enhancements

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements / Changes:

Bug Fixes

Enhancements:

Bug Fixes:

Enhancements:

Bug Fixes:

Enhancements:

Bug Fixes