|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
December 25th, 2006, 02:41 AM
|
|||
|
|||
|
Break the execution of a loop
Hello All
I'm using Firebird 1.5 and I want to terminate the execution of a "for select " loop inside a Stored Procedure and continue with the rest lines of code. Is there a command like "exit" or "break" to do this? Moreover, I would like to ask if there is something that I have to do in the databases builded with the version 1.5 before use opening them with new version of firebird 2.0. regards
|
|
#2
December 26th, 2006, 05:18 AM
|
|||
|
|||
|
Hi,
You can use BREAK or LEAVE to exit a loop. EXIT will "exit" the entire procedure. If you want to migrate from Fb 1.5 to 2.0, check the 2.0 Release Notes. Best thing you can do is create a backup and restore it on 2.0, so you're using the new On Disk Structure (ODS) of Fb 2.0 which includes index enhancements, for example. Martijn Tonies Database Workbench - development tool for Firebird and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com
__________________
Martijn Tonies Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle Upscene Productions http://www.upscene.com
|
|
#3
December 26th, 2006, 05:30 AM
|
||||
|
||||
|
Check Firebird's online PSQL manual at Janus Software
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Break the execution of a loop |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
