rowid's changing
Posted in 1997
I have a table (nothing special; not fragmented or anything) that =
changes rowid's whenever I update a row.
For instance I'll have two screens up. The first running isql query -> =
select rowid, * from table where key_field =3D "key_value" The second =running sperform on the same table. Using just the normal update =
function when I hit escape, if I re-run the query from screen one the =
rowid is now changed. Also if I hit update in screen two again I get an =
error (100), I believe because isql has now lost track of the row. =20
I have been talking with technical support and they have never heard of =
this. Also we are unable to re-create it. Therefore they can't really =
do anything to fix the problem. I'm sure I can fix this instance of the =
problem by dropping and re-creating the table, but this does not address =
the larger problem; rowid's should NEVER change.
Has anyone else experienced this?
Thanks in advance
PS Please no lectures on how the use of rowid's is not supported. I am =
aware of the implications of using rowid's, I'm more concerned about why =
the engine is doing this and if it might be a symptom of larger problems =
to come.