Message-ID: <3B4571B2.8085019B@petig-baender.de>
Date: Fri, 06 Jul 2001 10:07:14 +0200
From: Christof Petig <christof@petig-baender.de>
Organization: Adolf Petig GmbH & Co. KG
MIME-Version: 1.0
To: =?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= <hs@cybertec.at>
CC: pgsql-interfaces@postgresql.org
Subject: Re: ECPG error:  break statement not within loop or switch
References: <3B0BC6D7.E6C65E2A@cybertec.at>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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