Re: 5.01 SE Runtime Question

->From: Ian Timms <itimms@vprp333q.prop.telecom.com.au> ->To: informix-list@vprp333q.prop.telecom.com.au ->Subject: 5.01 SE Runtime Question ->Date: Mon, 20 Jun 94 14:58:09 EST -> ->Hi, -> ->We are currently developing under version 4.10 Informix ->on a SCO Unix 3.2.4 platform using 4GL RDS and SE with the ->intention to port and run the resulting app under Solaris 2.3 ->with SE 5.01 and 4GL Runtime 4.10. -> ->In our current setup (and as we do not presently use transaction ->logging etc.) anything other than an SQL Select statement will ->return and SQLCODE of 0 instead of 100 when the required rows ->cannot be found. -> ->Can anyone tell me whether or not this will still be the case ->in the new (SE 5.01) environment? -> ->Thanks in advance, -> ->Ian Timms. I would expect this behavior to be unchanged. As I see it, an UPDATE or DELETE that changes zero rows because zero rows satisfy the WHERE clause has completed successfully. So SQLCODE = 0 is appropriate. However, you might want to check SQLERRD[3] (sqlerrd[2] for you ESQL/C folks), which contains the number of rows processed. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\