Re: ESQL/C question about sqlca.sqlcode after "EXEC SQL UPDATE..

Posted in 1994

Naomi Walker — 1 Sep 1994 20:33:07 -0400 — source: Informix-list mailing list archive (1991-1998)

> > > Hi > I'm using ESQL / C with Informix Online V5.0 > > Will a statement like > > "EXEC SQL update [tablename] set [columnname] = [expression] > where [columname] = [expression]" > > ever set sqlca.sqlcode to SQLNOTFOUND (100) > or > does it ALWAYS set sqlca.sqlcode to (0) (no error) even if no rows were updated I'm not sure if this applies, but in 4.11 Esql/C, I check sqlerrd[2] for number of rows processed. sqlca.sqlcode is indeed set to 0 if no errors occured while updating (even if no rows were updated). Naomi -- Naomi Walker (aka N7FSA) | naomi@anasazi.com | Phoenix, Arizona ----------------------------------------------------------------- Dyslexsics, Untie! | Visualize Whirled Peas