Re: rowid's changing

Scott Black wrote: > > 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. > > 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. I do not remember, have not used sperform in ages, but perhaps the problem is that sperform is really doing a delete and add rather than an inplace update! Have you tried an explicit SQL UPDATE statements in DBACCESS/ISQL query? Does it behave the same? Have you also tried a 4GL or ESQL-C program? What were the results? Give us a little more info, please. Art S. Kagel