Pro*C sqlca.sqlcode Error

From: <mstanbrook_at_my-deja.com>
Date: Fri, 15 Dec 2000 18:54:03 GMT
Message-ID: <91dpc8$bm5$1@nnrp1.deja.com>

We are having trouble reading the sqlca.sqlcode in the following code: EXEC SQL WHENEVER SQLERROR DO sqlerr_report EXEC SQL (select statement here)
...
if (sqlca.sqlcode < 0) intStatus = sqlerr_report();

Where sqlerr_report() contains:
sprintf(msg,"\n%.*s\n\n",sqlca.sqlerrm.sqlerrml,sqlca.sqlerrm.sqlerrmc);

The program hangs right at the point that sqlcode is accessed.

Any ideas/suggestions would be appreciated.

Michael Stanbrook
mstanbrook_at_yahoo.com

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 15 2000 - 12:54:03 CST