Firebird Documentation IndexFirebird 3.0.2 Release NotesProcedural SQL (PSQL) → CONTINUE in Looping Logic
Firebird Home Firebird Home Prev: Exceptions with parametersFirebird Documentation IndexUp: Procedural SQL (PSQL)Next: PSQL Cursor Stabilization

CONTINUE in Looping Logic

Adriano dos Santos Fernandes

CONTINUE is a complementary command to BREAK/LEAVE, allowing flow of control to break (leave) and start of the next iteration of a FOR/WHILE loop.

Syntax

  CONTINUE [<label>];
      

Example

FOR SELECT A, D FROM ATABLE INTO :achar, :ddate
  DO BEGIN
    IF (ddate < current_data - 30) THEN
      CONTINUE;
    ELSE
      /* do stuff */
    ...
  END
      
Prev: Exceptions with parametersFirebird Documentation IndexUp: Procedural SQL (PSQL)Next: PSQL Cursor Stabilization
Firebird Documentation IndexFirebird 3.0.2 Release NotesProcedural SQL (PSQL) → CONTINUE in Looping Logic