informix 4gl and sql 7.x and rowids

during the process of upgrading from 3.x to 7.x, we spent a lot of time removing all refs to rowid, as we were told that rowids were no longer supported ( unless the table was created "with rowid"). i just created a test program on our 7.x system selecting a record and its rowid, then updating the record "where rowid = variable_name", and, to my surprise, it worked!!!. whats the deal here? did we waste all our time removing these pesky varmints?

Hi! Yes and No. They still work fine if you don't use fragmentation. If you do the rowid's will not uniquely identify the record. Regards, Michael DSL wrote: > during the process of upgrading from 3.x to 7.x, we spent a lot of time > removing all refs to rowid, as we were told that rowids were no longer > supported ( unless the table was created "with rowid"). > > i just created a test program on our 7.x system selecting a record and its > rowid, then updating the record "where rowid = variable_name", and, to my > surprise, it worked!!!. > > whats the deal here? did we waste all our time removing these pesky > varmints?