Export Tool: Added an option to not halt on errors when exporting multiple tables

Added UCanAccess JDBC driver support

Allow user to change the location of the built in database

Command Line Interface all to pass all information to connect to the database
on the command line
Example:
java -Xms64M -Xmx1200M -jar razorsql.jar -export "jdbc:mysql://192.168.1.11:3307/sample?noDatetimeStringSync=true|com.mysql.jdbc.Driver|/Users/user/Library/RazorSQL/mysql/mysql-connector-java-5.0.8-bin.jar|testuser|testpass" "select * from department" csv "/Users/user/Desktop/export.txt" NO NO NO "DEFAULT" "DEFAULT"

Upgraded internal database from HSQLDB 1.8 to HSQLDB 2.3

Database conversion: When converting from a database with default upper case
to a database with default lower case or vice versa, no longer wrap generated
column names in quotes if they are not in the default case

PostgreSQL function names not displaying in the database browser
for certain PostgreSQL databases

DynamoDB: Errors occur if attributes are not present near the beginning
of the table, but do have values later in the table

Query scheduler does not work with Salesforce

Generate SQL from query results with table name with
a space not generating correct SQL

Mac 64-bit version - Certain keyboard shortcuts using Shift such as next character, previous character,
next line, previous line, next paragraph, and previous paragraph are executing twice for each
keyboard event instead of once

Command Line Tool: Added an option to specify an import file start row on the import command

Command Line Tool: Added a fetch size override parameter to the export command

Added a schema selection dropdown to the main toolbar for H2 database connections

Updated included PostgreSQL JDBC driver to the latest version

For SQL Server and Sybase, multiple result sets can now be automatically displayed
without using the "Fetch All Rows" execution option if the first result set returned
contains fewer than the "fetch size" number of rows

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

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

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

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

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

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.

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

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

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