Re: SE to Online? any major problems?

bashir Akram (bash@bash.demon.co.uk) wrote: : I understand rowid has a slightly different meaning in Online, : some of the old code uses rowid, does this need to be re-written? : will updates/selects happen on wrong tables/records? : or will it still work? Rowids are still (relatively) stable -- they will change if the table is re-built (eg for ALTER TABLE), but not usually in the course of normal processing (SELECT, INSERT, UPDATE, DELETE). In version 5, anyway. Version 7 is a totally different story. The "different meaning" is that in OnLine, it is the actual location of the row, not just a sequence number, and rowids will not be consecutive in OnLine. This probably won't affect your code, but only you know that. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park, on a break from Beijing ----