Subject Re: [firebird-support] EXIT in the inner loop
Author Martijn Tonies
> In the following procedure, the EXIT in the inner cursor is terminating
> the entire
> process. What I want is to loop thru sale table and when some condition is
> met get out
> of the inner loop and continue with the next account_id of the outer loop.

use BREAK.

> Is it possible ?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!