• RazorSQL can now read configuration files such as connection profiles from a central location on launch
• Added a preference for whether to highlight SQL statements on execute
• Added a preference for whether to warn when update / delete statements with no where clause are executed
• SQL Editor: If only one statement is present, do not highlight the statement on execute

• Added an SSH tunnel option to the add connection profile process.
• Added the ability to specify a file that includes a query to execute for the command line export tool
• Added support for Sybase functions for the Sybase database browser
• Added an option to specify a custom delimiter in the command line export tool
• Added an option to specify characters at the end of each row for the delimited file option of the export tool
• Enhanced the linux launch script
• SimpleDB Export Tool: when generating insert statements or XML files, if an attribute does not exist for a given item, do not list the attribute in the column list and do not include null for the value in the value list of the insert statement
• SimpleDB Export Tool: If the domain has attributes that are not attached to one of the first 100 items, but are attached to a later item, those attributes are not getting included in the export. Changed this behavior for the insert, xml, and Excel export options
• SimpleDB: If no proxy information is entered, RazorSQL will now use the system proxy information by default when connecting to SimpleDB
• SimpleDB: When loading query results, dynamically update the results to include any attributes that were not tied to items in the first 100 rows
• Auto Complete: If there is nothing to complete, bring up a table list
• Added keywords to the SQL syntax highlighting file
• The binary data editor is no longer enabled on join queries. It is only supported on queries against single tables
• The view as image option is now available for join query results on certain databases
• Informix auto complete is not trimming table names

• Command Line Export with insert statement option - escape quotes now defaults to on
• SQL Server export query results with unfetched rows sometimes inserting N at the end of data
• Load time decrease due to class loading error between version 5.5.5 and 5.6.0

• Added support for MongoDB
• Add the ability to connect via proxy servers for Amazon SimpleDB connections
• HSQLDB: added support for switching schemas to the toolbar
• Derby: added support for switching schemas to the toolbar
• Add option to display the query text before results for Execute SQL - output to text options
• Added a preference for setting the decimal separator on query results
• Autocomplete / auto lookup - column names now wrapped in quotes when necessary
• Increase default max row count for SimpleDB to 5000
• Export to Excel, set the cell type and format based on the type of the column
• Import from Excel, if the cell value is a date, format it as a JDBC date
• Executing statements with statement delimiters in comments throwing an error due to parser not factoring in comments
• Command line generator: wrap locations that have spaces in quotes
• Alter table in MySQL with a connection without a database selected, throwing no database selected error

• Added Apache Derby 10.8 driver download option
• Added HSQLDB 2.2 driver download option
• For MS Access queries starting with line comments (--), RazorSQL now strips the line comments before executing the query
• SimpleDB import from file of SQL statements is throwing an error
• Slashes in column name needs quoted
• Only first 4000 chars are being displayed from SQL Azure procedures
• Execute All statements option not working correctly

• Compare Tool: Added option to write compare results to file
• Command Line Interface: Added option for comparing the results of two queries
• Added support for DB2 VSE
• Compare Tool: maximum compare lines is now configurable via the preferences
• Command Line Interface: For SQL Server and Sybase connection profiles that do not have a database set, the command line tool now executes a use command based on the database specified as a command line option
• Informix select into temp table queries throwing errors
• SimpleDB command line - create domain statement throwing error
• Import from Excel - fill with empty data checkbox not displaying
• Procedure Editor compile error window - if error message is too long, text gets cut off
• Query Results - when user resizes columns, column width getting reset after scrolling

• SQL Editor: Parameterized query input window now gives option to save the parameter value for the session
• Added a Clear Saved Query Parameters option to the SQL menu
• SimpleDB Database Navigator: The view contents option for domains with dots or dashes fails
• SimpleDB: insert syntax for inserting into domains with dots or dashes not accepting tick marks around domain
• SimpleDB: database navigator only showing up to 100 domains
• SimpleDB: generate select statement option is including itemName() in the select when it should not be

• Import Tool: Added insert or ignore and replace syntax options for statements generated by the import tool for MySQL and SQLite
• Export and Backup Tools: Added insert or ignore and replace syntax options for statements generated by the export and backup table and database tools for MySQL and SQLite
• Export and Backup Tools: Added option to generate multi-value / multi-row insert statement syntax instead of one insert statement for each row being inserted for Derby, DB2, MySQL, PostgreSQL, and SQL Server
• Improvements to load time performance
• Added Window - Focus in database navigator option to the Window menu
• Added Tools - PHP - Execute Program option
• Added Tools - PHP - Check Program Syntax option
• Added Tools - Perl - Check Program Syntax option
• Added Tools - Ruby - Check Program Syntax option
• Added validation to the import and export tool to require a database and / or schema to be entered
• Oracle database navigator loads slowly on some systems
• Control-click does not bring up context menu on Mac for the database browser
• Windows context menu keyboard key does not bring up the context menu
• Comments in front of a query can cause edit table tool to remove the where clause when launching

• Added drag and drop support for dragging items from the database navigator to the SQL editor and query results section
• Added a View as Image option to the right-click menu of the query results cells for cells containing binary data
• Edit Table Tool: Added support for inserting and updating binary data in hex format
• MySQL: binary data editor now also supports longblob, mediumblob, tinyblob, and long varbinary columns
• PostgreSQL - binary data editor now supports the bytea data type
• Added copy column name to editor option on the right-click menu of the query results column heading
• Added a decimal separator preference
• Added comma, tab, and spaced delimited file output options to the query scheduler
• Added a View as Image option on the binary data editor
• Results SQL Generators - added ability to display binary data in hex format in generated SQL
• The backup tool can now store binary data in hex format
• The export tool now stores data in hex format for the SQL Insert export type
• Added an option to import tool for SimpleDB about whether to tie null/empty values to the attribute.
• Added support for the SQLiteJDBC driver
• Added Greenplum to the list of supported connection types
• Added preference so that the SimpleDB multi-value separator can be customized
• Added the ability to escape the SimpleDB multi-value separator to be able to insert text in one value that contains the separator
• Added preference for whether or not to enabled database navigator drag and drop
• Added a preference for whether or not to display binary data in query results
• Added a preference for whether or not to convert binary data to hex in query results
• Added support for sorting Oracle timestamp columns in the query results

• Added support for SQL Azure
• Added support for showing rows as they become available with the Execute SQL Fetch All Rows option
• Added the following HTML wizard tools: button, check box, file select, form, image, link, ordered list, radio button, select box, table, text area, text input, unordered list
• Added page down button to query results toolbar
• Added support for writing unicode characters in the export to excel option
• Added options to only generate DDL to the backup database/schema, backup table, and command line backup and backup table tools
• Added character encoding dropdown box for MySQL JDBC
• Automatically include set identity insert on and off calls for MS SQL Server for tables in the backup and export tools that are exported / backed up and identity columns are included
• Added Execute Editor Contents as One Statement option to the SQL menu
• Added a fully qualify object name option to the Generate DDL tool
• Added support for displaying output for postgresql vaccuum command when used with the verbose option
• Added text to html converter
• Added open and sidekick tabs to the file system browser
• Added javascript templates
• Added php templates
• Added javascript inserts
• Added the following options to the context menu of the editor tabs: close all except current, rename, move, copy file path, size, get info, and sort tabs
• Added ability to change the results header column font
• Added support for not including PostgreSQL serial columns in edit table tool generated inserts
• Added auto completion for alter, drop, and truncate table commands
• Added Window menu option for moving focus to query results
• Added Window menu option for moving focus to the editor
• Added a sort columns button to the describe tool
• Added preference for whether to show query results rows as they become available
• Added Support for HyperSQL / HSQLDB 2.1
• Support page on RazorSQL performance tuning

• Added support for Amazon SimpleDB
• Added SimpleDB domain data editor
• Added SimpleDB Add, Edit, and Delete Attributes tools
• Added SimpleDB Backup database and domain tools
• Added SimpleDB Import Tool
• Added SimpleDB Export Tool
• Added SimpleDB Create and Delete Domain Tools
• Added support for writing SQL select, insert, update, and delete statements against SimpleDB
• Added an SQL parser tool that will parse an SQL statement and display syntax errors
• Added Apache Derby 10.7 driver to the auto download process
• SQL Editor: Added a word wrap option via the preferences
• SQL Editor: Added a word wrap guide option via the preferences
• FTP / SFTP: Added a create new site button to the save to ftp menu options
• Compare Tool: Added the ability to compare ordered or unordered data when comparing tables
• Compare Tool: Added row counts for each compared object in addition to differences
• Help: Added database specific help links to the help menu
• SQL Anywhere and Sybase IQ procedure editor - changed to retrieve procedure text from the source column instead of definition column if available
• SQL Anywhere and Sybase IQ alter view - changed to retrieve view text from the source column instead of the definition column if available
• SQL Anywhere and Sybase IQ - changed procedure editor to use alter sytnax instead of drop / create
• JDBC escape processing is now defaulted to false on all connections
• Added JDBC escape processing preference
• HSQLDB / HyperSQL: If no user is entered, SA is defaulted
• SQLite: Check for existence of SQLite database file before connection when user specifies connect to existing database
• SQLite: Default database creation to the user's home directory if not path is provided in the create database option
• SQLite: Added a check to see if SQLite database is writable by RazorSQL
• When GO or something similar is used as the statement delimiter, put a space before the GO when generating SQL statements via the query results or when saving edits from query results
• Oracle Database Browser: Added a hint to the query to get schemas
• Remember the location of the "Executing . . ." box that displays when a query is running
• Derby: When adding a Derby connection profile, require user to select which Derby version they want to use
• Added failover query if no MySQL procedure or function results are returned
• Added query to get MySQL parameter columns from information schema for MySQL 5.5 or greater
• Unable to connect to Derby 10.7
• MySQL procedure and function columns not displaying in the database navigator when browsing databases other than the one specified in the initial connection
• MySQL procedure and function columns not displaying in procedure editor and view content tool when using the MySQL PHP bridge
• Derby - for certain versions, generate ddl generating invalid DDL for identity columns
• DDL Generator: When a table has multiple primary keys with spaces / special chars in the column names, the primary key clause is not getting generated correctly.
• Alter Table Tool: When altering a table and adding multiple columns with spaces / special chars as a primary key, the primary key clause is not getting generated correctly
• Not defaulting current schema in HSQLDB / HyperSQL 2.0 and newer
• First site created is not displaying in save/open to ftp dropdown

• Added SFTP / FTP client available in the tools menu
• Added Open from SFTP / FTP option available in the File menu
• Added Save to SFTP / FTP option available in the File menu
• Added Bookmark found lines option to Find / Replace tool
• Added row count option to right-click menu of database navigator
• Added an option to trim leading / trailing spaces to export tool and command line export
• Added date and timestamp formatting options to the Export tool
• Added Generate SQL Inserts option to command line export tool
• Added date and timestamp formatting options to command line export tool

• Added Execute SQL - Output to File options for one statement and execute all statement options
• Added reconnect option to reconnect to the disconnected connection for a tab
• SQL Editor: Added Column Selection Mode option (Edit - Column Selection Mode)
• Added connect, disconnect, and reconnect options to tabbed pane context menu
• Added XMLHttpRequest object to JavaScript code builder
• Upgraded PostgreSQL JDBC driver
• Execute Script tool no longer requires statement separators to be contained in the script.
• Hitting shift end with selected text now keeps text selection accordingly
• Hitting shift home with selected text now keeps text selection accordingly
• Error thrown when trying to connect via the RazorSQL JDBC bridge using versions 5.2.3 and 5.2.4
• When there are multiple result sets for one query, copying the results to clipboard / editor does not work on the extra result sets
• Copy Table tool not executing SQL correctly if statement separator is not default
• JavaScript code builder not showing methods for DOM objects
• JavaScript auto method lookup does not work if equals assignment does not have spaces
• If javascript var does not start with "var", auto lookup doesn't work

• Added Table Relationships tool
• Performance improvements for exporting tables and backing up databases and tables
• Performance improvements when using the Execute - Fetch All Rows option
• Added JavaScript compressor
• Added JavaScript validator
• Added standard C library function lookup to Objective-C
• Added standard c library autocompletion to Objective-C
• Added auto signature display on ( for Objective-C for standard c libraries
• Added C-style bracket event closures to Objective-C
• Show in Browser option now prompts for which browser to launch such as Firefox, Safari, Opera, Chrome, and Internet Explorer
• The Show in Browser option for HTML files now only creates temp files if the currently active tab has not been saved to the file system and is not modified
• MS SQL Server export of a query executed with fetch all option errors when using ODBC driver
• SQL Anywhere database browser showing duplicate owners in some instances
• XML Validator does not show line number of error when validating against a file on the file system

• Increased performance when viewing contents on SQLite tables
• Increased performance when SQLite queries produce a large number of results
• Added a CLOB data editor for Oracle
• Added DB2 explain plan support for DB2 on z/os
• When using the execute all option for SQL Server and Sybase, the View Print Output option displays output from all of the statements executed, not just the last statement
• Added .htaccess / Basic Authentication support for the MySQL PHP Bridge, the PostgreSQL PHP Bridge, the MS SQL Server PHP Bridge, and the MS SQL Server ASP Bridge
• Added option for whether to include MS SQL Server identity columns in generated SQL insert statements for the Export, Backup Table, and Backup Schema tools
• Included sqlite program for 64-bit linux
• Changes in DDL Generator tool for MS Access using third-party drivers to clean up errors in generated DDL caused by driver problems
• SQL History not being saved in more recent versions
• Cancelling a statement via certain ODBC drivers sometimes crashes RazorSQL
• Execute All not parsing statements correctly when there is a single quote inside of a single line comment in query text
• Generate DDL - primary key column with spaces not being wrapped in quotes
• Running delimiter statement on SQLite connection causes executing query window to display and not go away

• Added support for Sybase IQ
• Added support for the DELIMITER command for changing SQL statement delimiters
• Add close all except current option to right-click menu of query results
• Display current sql statement delimiter on editor status panel
• Added Edit -> Text -> Insert International Chars option
• Added Edit -> Text -> Remove White Space option
• Added Edit -> Text -> Remove Lines Containing option
• Added Edit -> Text -> Remove Lines Starting With option
• Single and double quote keys not working on certain international keyboard layouts
• HTML Entities tool not working
• Auto column lookup not determining table correctly for certain join situations

• Added a connect at startup option for connection profiles to automatically connect when RazorSQL launches
• Added -profile command line option to automatically connect RazorSQL to a profile on startup
• Window sizing adjustments
• Preferences window not displaying on certain Mac versions
• Drop multiple tables option showing empty initial dialog for databases that don't support catalogs or schemas

• Added DB Tools - Execute SQL Script option
• Added smart commit mode. Executes commits after statements until a non-select statement is executed
• Added preference for specifying query results date format
• Added preference for specifying query results timestamp format
• Added Tools - Execute Ant Build for integration with Ant
• Add backup option to the command line tool for backing up databases / schemas from the command line
• Add execute option to the command line tool for executing files of SQL statements from the command line
• Added backup table option to the command line tool for backuping up tables from the command line
• Add unicode support for SQLite on Windows
• Added Command Line Call Generator tool for generating RazorSQL command line options
• Added preference for whether or not to sort table columns in database browser
• Added context menu item for sorting and unsorting table columns in database browser
• Added jump to compiler error line number option on Java compiler
• Added jump to compiler error ling number option on Mac Objective-C compiler
• Added table columns option to database object search tool for most databases
• View menu items can now be configured as custom keyboard shortcuts
• SQL Server import tool - added option for turning IDENTITY_INSERT to ON before doing the import
• Added option to Oracle thin driver for adding multiple hosts / ports for RAC connections
• Allow use of "max" keyword for column lengths when creating tables
• Made HTML link help system more responsive to mouse clicks
• Selecting into temp table throws error for SQL Server
• Selecting into variable my throw error in MySQL
• Generate DDL Tool: SQL Server 2005 and 2008 varbinary, varchar, and nvarchar columns with a column length of max displaying -1 for the column size
• Database Object Search: Search right-click menu option in the search results window not working
• Schemas not displaying for some SQL Anwyhere versions

• Added a binary data / BLOB editor
• Query Results: Column names sometimes displayed in header even if column aliases were used.
• Updated auto download to grab latest JTOpen driver
• Oracle blobs now show as (BLOB) in query results
• RazorSQL now launches in 64-bit mode by default on 64-bit Macs
• Interbase tables have trailing spaces in auto table lookup
• Interbase queries using aliases now show aliases in the column header
• Selects using table aliases not handled correctly in edit table tool and cell editor
• SQL Server: varbinary(max) columns get generated as varbinary(-1) in DDL tools

• Added a create table option to the import tool
• Added a delete all rows option to the generate SQL menu
• Added ability to sort multiple columns to the sort query results tool
• Added a charset selection dropdown to the MySQL create table tool
• Updated HSQLDB JDBC drivers
• Updated Derby JDBC drivers
• Added auto-install JDBC driver option for HSQLDB 2.0 JDBC drivers
• Added auto-install JDBC driver option for Derby 10.1, 10.2, 10.3, 10.4, and 10.6 JDBC drivers
• Added connection type options for JDBC type 4 and type 2 for DB2 on z/OS to the connection wizard process
• Added an AJAX example template
• Added AJAX inserts to the HTML inserts tool
• Updated Windows JRE
• Updated Linux JRE
• Changed Interbase database browser to use system queries to get tables, views and system tables
• Generate SQL delete option does not end statements with statement separators

• SQLite performance improvements
• Performance improvements for the Execute SQL - All Statements option
• Added support for easier setup for HSQLDB and Apache Derby database connections for drivers not included with RazorSQL

• SQL Editor: Auto completion enhancements
• Oracle Database Browser: Added right-click menu option for viewing table and column comments
• Import Tool: Save last start and width values for a specific table for fixed width file imports
• Added low screen resolution support for database browser menus
• Added additional pl/sql file extension recognition
• Launching improvements
• Added himem files for launching RazorSQL with increased memory settings
• Blurry icon problem on Windows 7
• Generate DDL tool not generating enum values for MySQL
• Generate DDL tool not generating MySQL auto increment

• Added auto detection for UTF 8 and UTF 16 files
• Added progress bar and ability to cancel Find in Files and Find / Replace in Files tools
• Added methods and anonymous functions to the JavaScript function / method navigator
• Clicking on a line number highlights the entire line
• Added ability to change the editor caret color
• Enabled support of $ and ^ regular expression symbols for the Find and Find / Replace tools
• Python syntax highlighting errors with certain text
• When syntax highlighting is off, keywords are always showing as black, even when custom colors are set

• Added option to choose file encoding to the Export Tool
• Added option to choose file encoding to the Backup Tools
• Added option to choose file encoding to the Import Tool
• Added charSet configuration property for PostgreSQL JDBC driver
• Added charset configuration property for SQL Server jtds driver
• Added named pipe configuration property for SQL Server jtds driver
• Upgraded Oracle JDBC drivers to 10.2.0.4
• Upgraded jTDS JDBC drivers to 1.2.5
• Added backup options to editor right-click DB Tools menu
• Add exec as an SQL keyword
• Right-click on a line number in the editor now adds or removes a bookmark
• Added smart comment (control or comment /)
• Add Undo Chunk to right-click menu on editor
• Add bookmarks menu to the right-click menu on editor
• Print using browser enhancements for better translation of font size, bolds, and italics
• Added Run on Local Web Server options to the PHP, Perl, Python, and Ruby tools menus
• Added Java util for wrap selection in If
• Added Java util for wrap selection in Else
• File, Edit, and Inserts menu now have better support for lower resolutions
• View Open Editors option now makes sure it is visible on screen if resolutions were changed
• Validate the execute program processes to make sure the program actually exists
• Change scroll buffer value so that auto window scrolling does not start until cursor is closer to end of the window
• Uncomment option now takes into account all selected lines when uncommenting line comments
• All Text menu tools now perform their functions on selected text only if there is text selected
• Better handling of line break conversions when transferring files from Mac to Windows and vice-versa
• Better adherence to default operating system line break formatting rules
• Made the CSS and HTML validator results windows resizable
• Certain Results menu options getting disabled on certain types of queries when they should not be
• Sybase Database Browser not showing tables, views, or system tables when using certain roles
• Right-click on File System Browser text field not showing popup menu on Mac
• Shift down not highlighting line when the line is the last line in the editor
• Word Count character count option not factoring in multi-character line breaks for windows
• Editor status bar selected text length not factoring in multi-character line breaks for windows

• Added Backup Database / Schema option (DB Tools -> Backup Schema or Database)
• Added Backup Table (DB Tools -> Backup Table)
• Table Editor: Added better support for editing text with tabs and line breaks
• Table Editor: Added a right-click menu to the data cells
• Query Results Editor: Added support for editing text with tabs and line breaks
• Export Tool: Allow user to specify SQL statement separator for the generated SQL
• Export Tool: Multiple Tables Option now has checkboxes for selecting / deselecting tables, views, and system tables
• Export Tool: The SQL export option how has a Generate DDL option for generating Create and Alter table statements for the exported tables
• Export Tool: The XML export option now has an option to escape XML special characters
• Import Tool: Import from SQL file now allows user to select the SQL statement separator
• SQLite Database Browser: Increased performance for table column information display
• SQL Editor: PostgreSQL stored function editor now uses the create or replace syntax
• SQL Editor: Firebird procedure editor now uses the create or alter syntax
• Generate DDL Tool: Added the option to select the SQL statement separator in the generated DDL
• Generate DDL Tool: Added a fully qualify object names option
• Generate DDL Tool: MySQL engine information is now generated for Create Table statements
• Generate DDL Tool: MySQL char set information is now generated for Create Table statements
• SQL Editor: Added Undo Chunk option
• SQL Editor: Added more options to editor right-click menu
• SQL Editor: Added error codes to error messages when the codes are available
• View Procedure / Function / Trigger contents window is now resizable and remembers size and location
• Describe Tool: Enhanced the foreign key tab
• SQL Editor: Find / Replace window now remembers last location
• Help: Added support articles and common support questions to the Help menu

• SQL Editor: For Mac, added more emacs key bindings (control k, control d, and control y)
• SQL Editor: Added Code - Utils - HTML Entity Selector option
• Auto Column Lookup: Column names sometimes duplicated
• SQLite Database Browser: Not all column names showing for tables in certain situations

• Edit Table Tool: Added wrap lines button for the Edit in New Window option
• Edit Table Tool: Resizing "Edit in New Window" window resizes the edit area
• Query Results: View row in column mode was parsing HTML text
• Create Index Tool throwing an error about not being able to get column names
• Informix Alter Table - incorrect syntax on add constraint clause

• Query Builder: Added search table option for building database search queries
• Query Builder: Automatically formats values entered when in or not in is used
• Query Results: Clicking on a row number in the query results now selects the entire row
• Query Results: Added Select Column option to right-click menu of query results column heading
• Query Results: Added Edit Cells to Results menu
• Query Results: Added Re-execute query item to the Results menu
• Query Results: Added Save / View Cell Edits to Results Menu
• SQL Favorites: Added mnemonics to SQL favorites menu
• Export: Added options for generate fully qualified table name to export data, export schema, etc. tools
• Editor: Added Search API reference option for PHP, Perl, and Python
• Editor: Added API reference links for CSS, HTML, Java, Objective-C, PHP, Perl, Python, Ruby
• Editor: Find in Files allows finding of text with line breaks
• Editor: Replace in Files allows replacing of text with line breaks
• Editor: Find / Replace in Open Editors now allows find / replacing text with line breaks
• Editor: Added an Objective-C compile option for Mac
• Editor: Added an Objective-C execute program option for Mac
• Editor: Added Objective-C syntax highlighting support
• Editor: Added an Objective-C Function / Method navigator
• Editor: Added an Objective-C Sidekick
• Editor: Added Objective-C code inserts
• Editor: Added Objective-C templates
• Editor: Added C and C++ code inserts
• Editor: Added Scala syntax highlighting support
• Editor: Added a Scala Function / Method navigator
• Editor: Added a Scala Sidekick
• Editor: Added Scala code inserts
• Editor: Added Scala templates
• Editor: Added COBOL code inserts and hello world template
• Editor: Added code inserts for Ada, ASP, Batch, and Groovy
• Editor: Added a compress files option to the file system browser for compressing files and directories in zip format
• Editor: Added Emacs keyboard shortcuts on the Mac for down, up, right, left, end of line and beginning of line
• Editor: Added a split file tool to the File System Browser and File - Tools menu to for splitting files into smaller files
• Editor: Escape key can now be pressed to close most windows opened by RazorSQL
• Editor: .plist files are now recognized as xml types
• Editor: Execute Program enhancements
• Set default button on filter query results
• Allow function keys to be used in keyboard shortcuts
• Added notes to Sort and Filter tools that only retrieved / displayed results are filtered or sorted
• Query Builder: If no operator is selected, default is set to AND
• Execute SQL: Parsing Change: if text starts with a function or procedure creation call, and there are multiple semi-colons, execute SQL will not parse editor by semi-colons when deciding what statement to execute, will send the entire contents of the editor
• Linux Launch Script: if can't launch with internal JRE, search the system for one
• Query Builder and Data Search Tool - Relaxed requirements on forcing table reference selections when adding tables
• Hitting the delete key on the file system browser now deletes the file
• If selected text has line breaks, when bring up either find in editors or find / replace, pre-select the tabs / line breaks button
• Re-organize the search menu so all of the Find / Replace options are together
• Add mnemoics for Start Recording and Stop Recording in the macro menu
• Put the insert selector items in alphabetical order
• Add Custom to the insert file type selector for the insert select tool
• Editor: If word wrap is on, copying text to a text file does not get wrapped, only when typing it
• Editor: If word wrap is on, opening a new text file does not wrap the text
• File System Browser: can now copy a file to the same directory as long as a different name is provided
• Editor: Double-click on a word in PHP file now also selects the dollar sign
• Editor: Double-click on a word in a Perl file now also selects the dollar sign, at sign, or mod sign
• Editor: Double-click on a word in a Ruby file now also selects the dollar sign and at sign
• Editor: Edit - Delete - Delete Line now deletes line plus ending line break
• Editor: Edit - Select - Select Line now selects line plus ending line break
• Editor: Triple click now select line plus ending line break
• SQL Server - tinyint field in generated DDL in Copy table tool and generate ddl tool should not display a size
• SQLite: Doing a join on two tables with same column names returning column values from first table only
• SQL Server Generate / View DDL - Identity option not being shown in the DDL
• MS Access - in generated SQL updates, selects, and deletes, datetime columns should be wrapped in # sign instead of single quotes
• Getting result set is closed error when exporing MS Access query results
• Import connection profiles, if no profiles exist on the machine, throws an error
• Query results tab name not handling beginning comments in queries when determining table name to display
• Oracle - if the beginning of the select statement is a comment, RazorSQL is not stripping the ending semi-colon.
• If no rows or columns selected in query results, edit table tool will not launch
• Query Check Permissions functionality not factoring in commented lines
• Editor: HTML validator returning one too many for warning count
• Editor: Text - Insert text at column - error for please enter a column greater than zero when entering 1 as the column number
• Editor: Copy Lines Containing window displays Cut in the text instead of Copy
• Editor: Make sure control / command click deselects an already selected item on the file system browser
• Editor: Home and End keys not working correctly on Mac
• Editor: Copying from windows formatted file on a Mac system causing double-spaced lines

• Create Table Tool, on first screen, added Initial Columns (optional) option
• Better support for machines with locked down user directories
• SQL Editor: PL/SQL - better recognition of code blocks
• SQL Editor: When the syntax highlighting type is SQL, not always executing Oracle blocks correctly
• SQL Editor: Oracle - If / is on a line by itself and nothing is highlighted, execute until the /
• Oracle compile not showing errors if procedure name has quotes around it
• If the reserved word from is used as a column name, it is not getting wrapped in quotes in the create table tool, alter table tool change column type, or query builder
• Multiple scroll bars displaying on the rename table and add sequence trigger options of the alter table tool
• Execute all not parsing queries correctly when a semi-colon is inside of a string
• Query parsing problems when the statement delimiter is semi-colon and semi-colon is quoted
• Query results not displaying correctly if results are in HTML format
• View row in column mode width should resize automatically based on column size

• SQL Editor: .plist files now recognized as an XML type
• Double-clicking query results cells now prompts for whether to launch edit table tool or edit cells locally on first double-click
• Auto table lookup values are now cached
• Left-click followed by a right-click in the query results on Macs is no longer handled as a double-click
• When editing query cells, if no rows are updated by the edit, a message is shown to the user
• Auto table and auto column lookup now check if there was any typing done since the lookup was initiated. If there was, the displayed values list is filtered baesd on the typed values
• Query results toolbar on Windows XP and earlier - buttons getting cut off.
• Fixed load errors on machines with unwritable user home directories
• Clicking cancel when launching the edit table tool not keeping the edit table window from displaying
• Info.plist change on Mac to prevent warning about CFBundleTypeRole entry in the console
• Generate SQL from query results tools not escaping apostrophes in generated SQL
• Slow help menu display performance on OS X 10.6 Snow Leopard

• Added column mode for query results for viewing results row data vertically
• Added Select Row option to right-click menu of query results cells
• Use the sorted query results when launching the edit table tool from query results
• Use the filtered query results when launching the edit table tool from query results
• Added preference for whether or not to sort auto column lookup values
• Added the ability to rename the query tab
• If there is an order by on the query, keep the order when launching the edit table tool
• Switching tabs causing query results edit mode on/off box to expand
• Edit Table Tool - When hitting save and the table doesn't have any keys should prompt the user to select keys
• OTHER option in database Add Connection wizard not working
• Edit Table tool and Export tools not always getting correct table name from query for queries with certain formattings

• Added Database Object Search tool in Search -> Database Object Search menu option
• Database Search Tool: Users can now add multiple tables and additional criteria to the search tool
• Added ability to directly edit query results for qualifying queries (select * from a single table variants)
• Added Oracle PL/SQL Auto completion for built-in packages and procedures
• Added Transact-SQL auto completion for system procedures
• Added SQL Generation options via the Results Menu for generating SQL select, update, insert and delete statements for the selected query results
• Added Import and Export connection profiles option
• Added a Copy Table tool via the DB Tools -> Copy / Backup menu option
• Added Code menu with programming tools for various programming languages such as SQL, PL/SQL, Transact-SQL, Java, XML, PHP, HTML, JavaScript and many more. Options include coding sidekicks, code builders, code inserts, etc.
• Added uncomment option to Code menu
• Added soft tab (emulate with spaces) option in the editor preferences
• Escape button can now be used to close almost all windows / dialogs opened by RazorSQL
• Export Tool: Now automatically sets file name and extension based on export type and export table
• Added How to Guides in the help menu
• Generate DDL Tool: Added procedures, functions, triggers, packages, and package bodies
• Alter Table Tool: Added change column data type / size for most databases
• Create Table Tool: Added enhancements for ease of use
• Database Browser: Added View Contents (Limit Results) 100, 1000, and 10000 for MySQL, PostgreSQL, Oracle, DB2, Derby, SQL Server, and Sybase
• Database Browser: Added a Get Info option for the MySQL users section
• Query Results: Added Copy As Date option to right-click option of query results for Oracle
• Query Results: For Oracle, added support for many NLS_DATE_FORMAT options, and better default display
• Query Results: Enhancements to Oracle timestamp formatting - support for default timestamp formatting conversion
• Added Oracle date and timestamp formatting preferences
• Informix: Added support for displaying Set, MultiSet, and List data types
• Stored Procedure Editor: Editing stored procedures / functions now brings up a new tab specific to procedure editing
• Stored Procedure Editor for SQL Server stored procedures and functions now generates alter statements instead of drop and create statements
• Upgraded HSQLDB drivers to 1.8.10
• SQL Editor: When the statement delimiter is semi-colon, semi-colons can now be entered inside strings
• H2 ease of use enhancements to the add connection profile tool
• Added auto-download option for the H2 database in the add connection profile tool
• Ease of use enhancements to the add connection profile wizard
• Add Connection Profile: Can now connect to MS SQL Server instances by either appending \instance_name onto either the host or the database name
• Added a preference for specifying whether to continue execute statements when an error occurs using the Execute All option
• Export Data Tool: Enhanced default selections based on the export type
• Export Data Tool: Added extra screen to the process for better readability
• Export Data Tool: Added a re-execute query before exporting option when exporting query results
• Added SQL Execute All Statements enhancements
• Added recordable macros available in the Tools menu
• Added various HTML programming tools such as HTML color chooser, HTML validator, HTML tidy tool, and HTML entities selector
• Added CSS style builder, tag navigator, and validator
• Added Perl programming language tools
• Added PHP programming language tools
• Added Python programming language tools
• Added Ruby programming language tools
• Added XML tools such as an XML validator and XML tree view option
• HSQLDB: Can now use other drivers other than the default HSQLDB driver included with RazorSQL
• Apache Derby: Can now use other drivers other than the default Derby driver included with RazorSQL

• MySQL views not showing in database navigator.

• Updated DB2 driver
• Updated PostgreSQL driver
• Removed obsolete drivers for certain databases
• Allow changing menu display preferences in Info.plist
• Fixed problems with Java update 4 causing various display issues with menus

• Added Triggers to the list of objects that RazorSQL will show compilation errors for in Oracle
• Added copy, cut, and delete all bookmark lines option
• If the max rows preference is set, close any statement and result set when the max rows preference is retrieved.
• If using the fetch all results option, close the statement and result set after execution
• Check for maxed out result sets and close accordingly
• Oracle Compile Errors not always displaying when creating / altering Oracle procedures, functions, packages, or package bodies

• Added SQL Favorites tools and a Favorites Selector to the SQL menu
• View SQL History and View Query Log now open a new tab with a shared connection to the currently active connection tab
• Added a View Contents (Fetch All Rows) option to database navigator for tables and views
• Allow direct access to Access 2007 .accdb files via the ODBC direct method
• DB2 - Append For Read Only onto applicable select queries to reduce locking
• Error message windows are now non-modal
• Escape key now closes error message windows
• Edit tool for procedures, functions, and triggers now inserts semi-colons after drop and create statements
• Changes to application launcher such as allowing multiple versions of RazorSQL

• Added InterSystems Cache database support
• Added FileMaker support
• Added characterEncoding and useUnicode properties to MySQL connection properties screen
• Added SQLite 3.6.15 precompiled binary to Linux distribution
• Updated built-in Apache Derby JDBC drivers to version 10.5
• Removed Mckoi and PointBase from the main database connection list
• Oracle Trigger contents not always able to be retrieved
• SQLite: not displaying tables that have numeric / decimal columns with scale values correctly
• SQLite: occasional communication errors between RazorSQL and SQLite

• Added View - View Open Editors component
• Added View as HTML in Browser option to the Edit - Text menu
• Right-click Copy not working correctly in query results
• Format of query results copying not always correct

• Bookmarks positions are now saved by default on exit
• Added Search -> Bookmark Selector tool
• Alter View - no semi-colon after drop view and create view
• SQLite Alter View - only showing last line of view in alter statement
• Sybase alter view not working correctly with Sybase JConnect JDBC driver
• Sybase generate DDL on views not working with Sybase JConnect JDBC driver
• Oracle alter view not working correctly
• Oracle generate DDL on views not working
• File System Browser: Delete option not working on Windows
• Text menu in editor popup menu does not have any values
• Firebird and Interbase Alter Table Tool - drop column generates incorrect syntax.
• Query scheduler only remembers first line of a query

• DB2 Database Browser enhancements
• Enhanced support for DB2 on iSeries, AS400, System I
• Added a preference for Maximum rows to retrieve for a query
• Added one click connection option to database browser
• Font anti-aliasing now defaulted to on in SQL editor for all systems
• Oracle auto completion / auto column lookup - values not being returned for lower case table names
• Export Query Results - Export as Insert Statement option not activated for certain select * query formats
• Edit Table Button - Not always being activated when it should be for certain formatted queries
• Export Tool not always wrapping text values with single quotes when it should be for export as SQL insert statements option

• Sped up load time
• Enhanced Oracle OCI support
• Allow Oracle Connect As option for all Oracle JDBC connections, not just built-in connections
• Query scheduler - remembers last information entered
• Auto populate Oracle OCI driver location if OCI client library is found
• Updated keep alive queries for several databases
• Attempt to reconnect dead connections needs to explicity call close on the original connection
• Put a limit on the number of times reconnecting dead connections
• Removed JDBC driver already loaded warning message
• Query Scheduler - missing line break after first line in output
• Copy results and columns to clipboard fetches more rows when the entire query results have not been retrieved

• Add ability to change the SQL statement delimiter / termination character via the preferences window
• SQL Server - not all schemas are being shown in the navigator with certain configurations
• On save confirmation window, if close window by not using cancel button when prompted to save changes, treats it as a No response
• Import Tool - When entering specific import file column values that are not all inclusive, if the table column count is greater than the delmited file column count, values not getting picked up correctly.
• Oracle Generate DDL - generating a 0 size for a number field in some cases

• SQL Editor - Added Auto Completion (Tools - Auto Complete menu option, Auto Complete toolbar button, and keyboard shortcut) for autocompletion of tables and columns
• Query Results - Added Search - Find in Query Results to Search Menu and added a corresponding button to the query results toolbar for doing advanced query result searches
• Connection Manager - Included JTOpen DB2 driver for AS/400 and iSeries JDBC connections
• Added SQLite create database tools
• Enhanced PostgreSQL create user tool to include valid until, createdb, createuser, group, and encrypt password options
• Added copy query to clipboard option on the query result set tab menu
• Added replace editor contents with query to the query result set tab menu
• Added ability to filter MS SQL Server and Sybase Schemas / Owners to the Database Navigator
• Added a confirmation dialog when closing RazorSQL and an associated preference to turn this on / off
• DB2 Database Browser - All tablespaces are returned in browser regardless of schema / owner
• Windows: Upgraded JRE to 1.6.0_13
• Ability to override RazorSQL home directory by setting the razorsql.home System property
• Change File - Make Backup to File - Backup Editor File to avoid confusion
• Changed search menu text to prevent confusion between query result search and editor search
• MS SQL Server View definitions over 4000 chars getting truncated in the Alter View and Generate DDL tools
• Function List tool does not display PHP functions located inside of a class
• Match word in the Find / Replace tool does not apply the whole word criteria when there is only one word in the text
• Select Previous word on Mac has incorrect keyboard shortcut

• Edit Table Tool: Edit Cell in New Window button not always applying changes to the screen.
• Edit Table Tool: Edits in New Window checkbox value not always being remembered correctly

• Added Netezza to the list of supported databases
• Added .war and .ear files to the list of files supported by the Zip utility
• Added Edit - Text - Insert Text at Column option
• Find / Replace in Files tool - results can now be copied to the text editor
• Upgraded built in Derby driver to 10.4.2
• Next word and Previous word options now skip white space
• Derby embedded connections sometimes fail when Derby is not the first database connected to after launching RazorSQL
• Java method lookup - performing slowly for certain classpath configurations

Database Browser performance enhancments.
Import tool enhancements.
Bug fixes.

• Edit Table Tool: Added a copy row option
• Edit Table Tool: Added auto-scroll functionality when editing a cell from the query results
• Edit Table Tool: Added the ability to move left and right from cell to cell with the arrow keys
• Export Tool: Added functionality to export tool CSV option to ensure proper wrapping and escaping of double-quotes for the following situations Line Breaks in data, quotes in data, data begins or ends with spaces
• DB2 Database Browser: Added Buffer Pools
• DB2 Database Browser: Added Tablespaces
• Oracle Database Browser: Performance enhancements
• Added QuickBooks QODBC support
• SQL Editor: Added ability to change editor background and default text colors
• SQL Editor: Added Edit - Cut Lines Containing option
• SQL Editor: Added Edit - Copy Lines Containing option
• SQL Editor: Added Search - Replace Until option
• SQL Editor: Added Search - Replace After option
• SQL Editor: Added ASP syntax highlighting support
• SQL Editor: Added ASP function browser
• SQL Editor: Added home and end keys to the edit menu and allow keyboard shortcut customization for them
• File System Browser: Added ability to change background and default text colors
• SQL Formatter: Added SQL Formatter keywords to text files in the data directory. Users can modify these files to change the behavior of the formatter
• Query Builder: Added select all columns button to insert option of query builder

• Tools: Added Tools - Generate DDL option for generating DDL for tables, views, and indexes contained in schemas or databases.
• Import Tool: Added ability to create an output file of the generated SQL insert statements
• Import Tool: Added ability to import from a file of SQL statements
• Import Tool: Execute as batch now takes a parameter for the number of statements to make per batch network call
• Import Tool: Added progress bar that displays percent complete while importing
• Import Tool: Added option for saving to file only
• Import Tool: New method for handling delimited files with line breaks or delimiters in between delimiters.
• Import Tool: Added halt on error option.
• Describe Tool: Added DDL tab for displayed table DDL
• Database Browser: Added Generate SQL menu for generating select, select *, insert, update, and delete statements for the selected table or view.
• Database Browser: Added Search menu option for searching tables.
• Database Browser: Added Generate DDL option for generating DDL for tables, views, and indexes.
• Database Browser: H2: Added indexes and sequences to the database browser.
• Database Browser: Teradata: Added indexes and triggers to the database browser.
• Database Browser: Pervasive: Added triggers to the database browser.
• Database Browser: InterBase: Added indexes and sequences to the database browser.
• Database Browser: InterBase: Added triggers, functions, and users to the database browser.
• Database Browser: Sybase: Enhanced query for getting procedures.
• Database Browser: Added show infor queries for Teradata, InterBase, and H2.
• Export Tool: Improved memory usage when exporting multiple tables to a single file
• Export Tool: Command line export - added convert nulls to blanks option
• Export Tool: Added progress bar and exported row status.
• SQL Editor: Added database selection drop down for Teradata
• SQL Editor: Added schema selection dropdown for DB2
• SQL Editor: Added schema selection drop down for Oracle
• SQL Editor: Added combine files tool.
• SQL Editor: Syntax highlighting enhancements.
• H2: Add ability to create indexes and sequences
• H2: Add ability to alter view
• H2: Add ability to drop indexes and sequences
• Teradata: Added create index tool and drop index tool
• Teradata: Added create, edit, and drop tools for procedures and triggers
• Pervasive: Dropdowns for selecting a database are now pre-populated with the current database.
• Pervasive: Added ability to edit procedures and view procedure contents.
• Pervasive: Added ability to edit triggers and view trigger contents.
• InterBase: Added ability to create indexes and sequences.
• InterBase: Added ability to alter views.
• InterBase: Added ability to drop indexes and sequences.
• InterBase: Added ability to create procedures and triggers.
• InterBase: Added ability to drop procedures and triggers.
• InterBase: Added ability to edit procedures and triggers.
• File System Browser: Added performance and other enhancements.
• Edit Table Tool: Added copy to editor button for generated SQL.
• Edit Table Tool: Generated SQL now has syntax highlighting.
• Create Table Tool: Common data types are now pre-selected for column data types.
• Plugin API: Added new methods to the Plugin API.
• Added support for the Oracle XMLType data type.
• Connection Wizard: Added additonal help documentation links to the connection wizard.

• MySQL, MS SQL Server, and Sybase - Auto correction of connection errors when connecting locally
• Double clicking of query results column sorts column results in ascending order. Double clicking again sorts in descending order
• Edit Table Tool - When max row count is reached for edit table tool, unable to edit rows inserted after the max count
• PostgreSQL - double clicking or menu based launch of edit table tool not working for query results
• Sort Ascending menu option on query results column brings up sort dialog instead of simply sorting the results

Bug fixes.

• 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
• 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

• 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

• 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.

Bug fix for Export Tool.

• 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

• 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
• 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

Enhancements and Bug fixes.

• 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

• 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
• 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
• 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

• 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
• 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
• 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