SQL Power Software Forum

In the query window if I have multiple queries, say something simple like:

SELECT * FROM Movie ;

SELECT Title, Year, Genre FROM Movie ;

SELECT DISTINCT First_Name, Last_Name FROM Actor;

The behviour I see is that the last query is run, even if I highlight one of the earlier ones. The behaviour I would expect and like to see is:

- If I do not highlight a specific query it runs all of the queries with a way to switch back and forth between results

- If I highlight a query(ies) it runs only that query(ies) and dislplays them

This is a fairly typicaly behaviour in my experience with query tools.

Jason

Hi JBrown,

- If I do not highlight a specific query it runs all of the queries with a way to switch back and forth between results

This seems to be a problem with the HSQLDB driver. More specifically it seems that the HSQLDB driver only returns the result set from the last statement in the list of statements. When I use PostgreSQL I get multiple result sets returned and each one appears in a tab at the bottom of the screen. Steve reported bug 2253 earlier which is a similar problem with an Oracle driver. The difference with Oracle is when a statement is executed with an Oracle driver a semi-colon at the end of the statement causes it to fail. The solution to this bug would be to pre-parse the query and break it into individual statements. Then we could send each statement by itself to get the correct number of result sets. I've added the problem with HSQLDB to this bug.

- If I highlight a query(ies) it runs only that query(ies) and dislplays them

I've added this suggestion as bug 2259 in the bug database.

Thanks for your feedback,

Thomas