Re: ProC Mystery

[Quoted] Actually, it was a mystery to me because my co-worker had several of the

EXEC SQL WHENEVER NOT FOUND DO BREAK; in other functions, but not in this particular function. Could it be possible that, for whatever reason, the precompiler picked up this line from one of the other functions? When I commented out this line out of all of the functions that he had created before adding this function, [Quoted] the file was able to compile fine. I just found it very strange.

Thanks for your help!

• Melissa

> There's no mystery at all, ProC compiles correctly according to your
 *.pc
> file.
>
> The statement
> if (sqlca.sqlcode == 1403) break;
> is generated, because you have a line like
> EXEC SQL WHENEVER NOT FOUND DO BREAK;
> in your *.pc file.
>
> The WHENEVER line itself does not generate any code, but it controlls
 the
> error checking code, that is generated after each DML statement.
>
> For further details have a look in the "Pro*C/C++ Precompiler
 Programmer's
> Guide", chapter 11 "Handling Runtime Errors".
>
> Dieter Rohlfing
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jun 17 2000 - 00:00:00 CEST