Re: Help With Delphi and Informix Please
Posted in 1996
Topics: Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL
An UPDATE of zero rows is not an error, though it evidently isn't what you wanted. You can inspect the sqlca structure in ESQL/C; I don't know how the equivalent information is handled in ODBC. You can also look for SQLNOTFOUND (100) if you are running on a MODE ANSI database, if my memory serves me correctly. On a non-ANSI database, you simply get the zero rows processed, no error detected notification. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: jfalck@eden.com (jay falck) >Date: 11 Mar 1996 20:50:41 GMT >X-Informix-List-Id: <news.21984> > >I am at a loss. I have looked everywhere I can think of and cannot find >what should be a simple answer. I want to know how to find out if an >ExecSQL statement was successful. > >For instance, if I issue an update statement where the row does not exist, >what error code should I expect. Running updates against non-existent >rows does not seem to be returning errors. I am using ODBC to get to >an Informix database. Delphi is 1.02.