RE: Everything looks OK, but...

Igor, I can think in two possible causes: - Is the database defined with ansi mode?. If this is true you might have to commit the changes before closing your connection. - Have you started a transaction in some other function of your program?. If this is true you might have to commit the changes before closing your connection HTH Tino > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Igor > Sent: Friday, August 13, 1999 11:34 AM > To: informix-list@iiug.org > Subject: Everything looks OK, but... > > > Hi All > > I have a strange problem. I run a program, which call db function. > This function should inser some information to tha table. > sqlca.sqlcode returns "0", but there is no changes in the table. > Here the code : > > #include <string.h> > #include "gl_common.h" > #include "db_common.h" > #include <stdio.h> > > > EXEC SQL INCLUDE sqlca; > > > db_00_ins_bctemp(barcode) > EXEC SQL BEGIN DECLARE SECTION; > char *barcode; > EXEC SQL END DECLARE SECTION; > { > int ret_value; > > ENTER_PROC("db_00_ins_bctemp"); > > db_prepare(DB_MODIFY); > > EXEC SQL INSERT INTO bc_temp > VALUES (1,:barcode); > > ret_value = db_status(DB_MODIFY); > > > RET(ret_value); > } > > Regards > > > Igor >