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

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

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 (separated
from 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 commands
won'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 |
|_________________________________________________________|