[Squirrel-sql-users] Select statement only possible using double quotes?

[Bjoern S. <bi...@fr...>]

When executing SQL statements in Squirrel 2.4 I get an error if the user,
table and/or field isn't surrounded by double quotes.

Example (lsa is a table):

SELECT "lsa"."name" FROM "lsa" --> works 

SELECT lsa.name FROM lsa --> returns following error: Error:
java.sql.SQLException: Schema 'lsa' does not exist, SQL State: 42Y07, Error
Code: 30000

also SELECT * FROM lsa returns this error

I'm using Java 1.6 with the Derby database embedded driver.

In the tutorials and help no double quotes are used and I find it very
inconvenient to have to add quotes to the autocompleted names composing a
query.

Is there any setting that I can use or any other solution to handle this?

Thanks in advance!
Bjoern

-- 
View this message in context: http://www.nabble.com/Select-statement-only-possible-using-double-quotes--tf3013596.html#a8368875
Sent from the squirrel-sql-users mailing list archive at Nabble.com.