From: Hans-Jürgen Schönig <hs@cybertec.at>
To: pgsql-interfaces@postgresql.org
Subject: ECPG error: break statement not within loop or switch
Date: Wed, 23 May 2001 16:19:03 +0200
Message-ID: <3B0BC6D7.E6C65E2A@cybertec.at> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: hs@cybertec.at
Subject: Re: ECPG error: break statement not within loop or switch
In-Reply-To: <3B0BC6D7.E6C65E2A@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox