Re: esql-c update return code

Chaiw Kok Kee (chaiw@ibm.net) wrote: : I would like to update a row in a table and if not found, insert the record. : The return value of update (sqlca.sqlcode) returns a 0 when the record is not : found. I thought it should return 100 just like a select statement. : Is this a bug? Now I have to do a select first. : I am using Informix On-line 5.0 : Any advice appreciated. : -- : Chaiw Kok Kee : Consultant : Multi-Purpose Information Technology : kkchaiw@mit.com.my : www.jaring.my/mphb/ Try use - sqlca.sqlerrd3] - number of inserted/updated rows |||||||| | ~ ~ | (| @ @ |) --------------oOOo---(__)---oOOo---------------- ################################################ # Ing. Peter Obert , e-mail : peobe@softec.sk # # tel. 0862 / 258 39 # # fax. 0862 / 264 80 # # SOFTEC Bratislava,Pobocka Prievidza # ################################################