Re: [Squirrel-sql-users] Object tree displays OK, but SQL commands won't exececute

[Colin B. <col...@te...>]

Hi Denis,

Forget my comment below, this is an issue _only_ with the current CVS
code. In 1.1 having the cursor on the next line will still execute the
code. However having a blank line between the SQL statement and the
caret will cause this problem.

E.G.

select * from table

|

will not work.

--
Colin Bell
http://squirrel-sql.sf.net

----- Original Message -----
From: Colin Bell <col...@bi...>
Date: Monday, April 14, 2003 1:43 pm
Subject: Re: [Squirrel-sql-users] Object tree displays OK, but SQL
commands won't exececute

> Hi Denis,
> 
> I've tested SQuirreL with slightly older versions of PostgreSQL 
> and it
> has worked fine.
> 
> The SQL entry area allows you to execute multiple SQL statements 
> as well
> as single ones so the actual text selected in the entry area means
> something. The Help file that comes with SQuirreL explains it:
> 
> "If a single statement is entered then pressing <ctrl><enter> will
> execute just that statement.
> If you only want to execute part of the SQL entered then highlight the
> SQL that you want to execute and press <ctrl><enter>.
> To only execute a single statement amongst several statements 
> (separatedfrom the other statements by at least one blank line) 
> within the SQL
> entry area then click on the line containing the statement that 
> you want
> to execute and press <ctrl><enter>."
> 
> What it _doesn't_ explain (because I've only just realized it 
> myself) is
> that if you put the cursor on the line after the SQL and then press
> <CTRL><ENTER> it _doesn't_ execute. E.G. (if | represents the cursor)
> 
> select * from table|
> 
> will work but
> 
> select * from table
> |
> 
> won't work.
> 
> Let me know whether this is your problem. I intend to fix this in the
> next release.
> 
> --
> Colin Bell
> http://squirrel-sql.sf.net
> 
> 
> -----Original Message-----
> From: Denis Grannell [mailto:dgr...@we...]
> Sent: Monday, 14 April 2003 2:29
> To: squ...@li...
> Subject: [Squirrel-sql-users] Object tree displays OK, but SQL 
> commandswon't exececute
> 
> 
> Hi folks,
> 
> I hope someone may be able to throw some light on the 
> following odd behaviour. I have a postgres 7.3.2 
> installation on Solaris9 that I want to access from 
> Windows PCs using the squirrel 1.1-final client.
> The windows version is Windows2000 Professional/SP3.
> The java version on the PCs is:
> "Java(TM) 2 Runtime Environment, Standard Edition 
> (build 1.3.0-C)"
> I am using a jdbc driver called 'pg73jdbc2ee.jar.zip'
> that I got from the Postgresql java website.
> The driver loads up OK and appears in the client as 
> active. I can connect to the database without any
> problems.
> In the client GUI I can view everything under the
> 'Objects' tab such as table content, table columns, 
> primary keys, views, etc. If I click on 'Content' for 
> any given table I get an instant list of all the rows.
> However the SQL tab is not working. I can type in
> any simple select statement (select * from <tablename>;)
> for the same table for which I just viewed the content 
> and nothing happens at all. 
> No list, no new tab, nothing. I'm not a java expert, so 
> I would appreciate any help on how to try and 
> troubleshoot this.
> 
> thanks
> 
> Denis
> _________________________________________________________
> | Denis Grannell, Kapuzinerstr. 45, 80469 Munich, Germany |
> | Tel: +49 89 2013672                 Fax: +49 89 2022875 |
> |_________________________________________________________|
> 
> 
>