RE: [Squirrel-sql-users] Empty lines stop script execution

[Colin B. <Col...@as...>]

> -----Original Message-----
> From: Federico Tello Gentile [mailto:fed...@gm...]
> Sent: Friday, September 17, 2004 10:11 PM
> To: squ...@li...
> Subject: [Squirrel-sql-users] Empty lines stop script execution

> If I load a script and run it from the SQL view the execution stops
> when it finds an empty line.
> 
> Example:
> 
> select * from table1;
> select * from table2;
> 
> select * from table3;
> 
> 
> Only 2 statements would be executed. This makes sense with lots of
> inserts or updates or DDL statements, but it works with any SQL
> statement.
> I have ! setted as statement separator, but happens with ; as well.
> 
> Any idea why this happens ond if it can be avoided?


From the Help file

<quote>
When the SQL tab is selected pressing <ctrl><enter>, taking the Execute SQL
option from the Session menu or pressing the Execute SQL button in the
session window tool bar will execute the entered SQL.

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>.
</quote>