Re: Error -710: Table has been altered, rename or drop

> From ilist@rmy.emory.edu Fri Jun 13 13:19 MDT 1997 > Return-Path: <ilist@rmy.emory.edu> > From: "Telecom" <toto@magrit.com> > Subject: Error -710: Table has been altered, rename or drop > Date: 12 Jun 1997 15:01:59 GMT > Organization: INT > To: informix-list@rmy.emory.edu > Status: RO >=20 > Does enybody have some cues to fix this problem. The problem raise > ramdonely. To fix the problem presently, we rerun the stored procedure = or > querie 2 or 3 times and finaly we get the result. >=20 > Tank You. > Alain Martin. > INT Systemes d'Informations I have come accross this problem recently. The problem I had was that I = was creating a temp table, then I prepared an sql statement on that table = and=20 declared a cursor. I then was inserting into the table. After inserting = into the=20 temp table I created indexes on the columns I am using in the query. I = then=20 proceeded to access the temp table with the prepared cursor. I believe = that it=20 was processing some of the rows and then erroring out.=20 When I moved the prepare and declare statement after creating the = indexes,=20 everything worked well. So take a look at your logic and see if you are altering the table in = any way=20 after preparing and declaring your cursor. Hope this helps, David Sandmann