|
From: Colin B. <Col...@as...> - 2004-09-19 22:08:08
|
> -----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> |
