Re: SQLCODE and SELECT ... INTO TEMP

Posted in 1998

ccremid — Fri, 30 Jan 1998 13:09:04 -0500 — source: Informix-list mailing list archive (1991-1998)

Georg Winkens wrote: > Does anybody know a way to find out whether a SELECT ... INTO TEMP > TmpTable actually inserted a row or not without doing an explicit SELECT > COUNT(*) FROM TmpTable? > SQLCODE and SQLSTATE contain always 0 even if there was no row inserted > in the temporay table. Look into sqlcode.sqlerr[2] for ESQL/C or sqlcode.sqlerr[3] for 4GL. This fieldcontains the number of rows processed. > Thanks for your help, > GW Hope this helps Tino