From: =?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= <hs@cybertec.at>
Subject: ECPG error:  break statement not within loop or switch
Date: Wed, 23 May 2001 16:19:03 +0200
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 45
Message-ID: <3B0BC6D7.E6C65E2A@cybertec.at>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
To: pgsql-interfaces@postgresql.org

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

ecpg retrieve.pgc -o file.c
gcc -g -I /usr/include/pgsql -o prog file.c -L /usr/share/pgsql -lecpg
-lpq
retrieve.pgc: In function `main':
retrieve.pgc:57: break statement not within loop or switch
make: *** [x] Fehler 1

What does it mean?
I have listed the crucial piece of code below:

 EXEC SQL DECLARE mycursor CURSOR FOR mystatement;
        EXEC SQL OPEN mycursor;

        EXEC SQL WHENEVER NOT FOUND DO BREAK;
        while   (1)
        {
                EXEC SQL FETCH IN mycursor INTO :id, :name;
                flag=1;
                printf("records found: %i, %s\n\n", id, name);
        }

        if      (flag == 0)
        {
                printf("Insert the name of the OS: ");
                scanf("%256s", inos);

                EXEC SQL INSERT INTO os (id, name) VALUES (':intext',
':inos');         // THE ERROR OCCURS HERE
                if      (sqlca.sqlcode)
                {
                        printf("%s\n", sqlca.sqlerrm.sqlerrmc);
                        exit(0);
                }
        }

        EXEC SQL CLOSE mycursor;
        EXEC SQL DISCONNECT;

Can anybody help me?

    Hans