Re: ECPG error: break statement not within loop or switch - Mailing list pgsql-interfaces

Hans-Jürgen Schönig wrote:

> I have written a small application but I can't compile the code because
> of an error I have never seen before:

[...]

> retrieve.pgc: In function `main':
> retrieve.pgc:57: break statement not within loop or switch
> make: *** [x] Fehler 1
>
>         EXEC SQL WHENEVER NOT FOUND DO BREAK;

this statement inserts a 'if (sqlca.sqlcode==100) break;' after each SQL
statement following

>                 EXEC SQL INSERT INTO os (id, name) VALUES (':intext',
> ':inos');         // THE ERROR OCCURS HERE

and here it harms (of course)

you should insert   EXEC SQL WHENEVER NOT FOUND CONTINUE;
after the while loop.

Yours  Christof