|
|
Choosing A Webhost: |
Select statement only possible using double quotes?: msg#00023db.squirrel-sql.users
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. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: Select statement only possible using double quotes?, Bjoern Sundin |
|---|---|
| Next by Date: | Strange conversions when doing calculations with Oracle, CptBlaubaer |
| Previous by Thread: | Anything to do about timed-out sessions with oracle?, Karr, David |
| Next by Thread: | Re: Select statement only possible using double quotes?, Bjoern Sundin |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |