hi,

I have an aplication development informix-4GL version 720 an the engine is informix-SE 7.24 where to do the follogind statement.

let inserta = "insert into tabla values (?,?,?,?)
prepare pp from inserta


execute pp using x1,x2,x3,x4
When I execute this statement the program show me the followind erorr

-710 Table <table-name> has been dropped, altered or renamed.

If anybody can help me with this problem thank you very much.

Hi,

When a user has open a table and another user alters this table, when wanting to accede, the first user to the table, gives east error.
Please run update statistics after alter table.
Or can be a bug.

Gustavo.

database test
main
define i integer
define str char(40)
let str = "insert into tab1 values(?,?,?)"
let str = str clipped
prepare see from str
for i = 1 to 100
execute see using i,i,i
end for
end main

Linux test 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 i686 unknown
IBM Informix Dynamic Server Version 9.40.UC2
IBM INFORMIX-4GL Version 7.32.UC1
IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC1


suggestion:
update statistics;
upgrade informix product;