Re: ProC Mystery

Don't use EXEC SQL WHENEVER NOTFOUND DO break; You may be use SQLCA.SQLCODE for error handling.

"Melissa" <mp2114_at_my-deja.com> wrote in message news:8idgmh$qg4$1_at_nnrp1.deja.com...
> I am not sure how this is happening, but a co-worker was working on some
> ProC code and had typed a very simple INSERT instruction. After the
> ProC compiler finished generating the corresponding C file, the CC
> compiler indicated a compile error with the following message:
>
> Error 1571: Break statement has no enclosing loop or switch.
>
> The odd thing about this problem is that the ProC compiler has placed a
> line of code at the end stating the following:
>
> if (sqlca.sqlcode == 1403) break;
>
> This line should not even be present in the code. I have looked over
> the code several times and do not see anything wrong with the way the
> INSERT has been coded. To compound the situation further, if the INSERT
> command is commented out of the code, the CC compiler compiles with no
> errors.
>
> Has anyone else seen something similar to this? If so, how were you
> able to resolve the issue? My first suggestion was to take out that
> function in the current file and place it into a new *.pc file, then
> recompile.
>
> Any suggestions anyone could supply would be greatly appreciated!
>
> -- Melissa
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jun 20 2000 - 00:00:00 CDT