I'm running RDS 4GL 4.10 under Online 5.0 on a SCO UNIX 486 box.
I've some new code that uses a temp table over and over, and
I'm getting -710 errors randomly, but quite often.
I'm totally puzzled by the error description, because it in no
way describes what is going on in the SQL statement in question.
==========
-710 Table table-name has been dropped, altered, or renamed.
After a statement has been prepared in the database server and before the
user executes it, the table has been renamed or altered, possibly changing the
structure of the table. Problems may occur as a result.
==========
The code does not alter or rename at any point.
The table is dropped after being used, but is recreated before being
used again. I create it from a 'select into temp' and with
'create temp table.' The error occurs in both cases.
In fact it also occurs on the 'creat temp table' statement itself
sometimes.
The program is enourmous, but in essence it repeatedly:
creates the temp table (as described above)
does one or more of the following: delete from, insert into, update
selects from
drop temp
There is only one database in use by the program.
The program uses a few other temp tables, and never has an error with them.
Anyone seen this behaviour or have any advice?
Thanks,
Joey Duhon
duhon@group1.com
duhon@netcom.com