RE: Help ?? : 4GL Informix 6.0 Porting Problem

Sticking my neck out here a bit, but I have heard from numerous sources that rowid should not be used by appications that are going to run on versions of informix from 6 onwards. I would say this is where your problem lies and suggest that you add a serial column to all your tables and populate this column with suitable values (suggest unloading data from V5 database with the rowid, and use the rowid for the new serial column). You will then need to convert all your SQL statements to use the serial key instead of rowid. Mark Denham BBC London, UK Mark.Denham@bbc.co.uk ---------- From: ilist To: informix-list Subject: Help ?? : 4GL Informix 6.0 Porting Problem Date: 12 July 1995 12:57 We have recently moved from Informix Online 5.1, 4GL 4.1 to Online 7.1 4GL 6.0 environment. Under SCO Open Server 3.0 While the programs worked perfectly under 4.1 4GL. We have problems in 6.0. We are using <rowid> to update all the data using rowid cursor. Under new version all the updates fails with the following error Cusor <Hex Decimal> cursor not found Error No 507. Thanks in Advance. Kalyanaraman shanke11@singnet.com.sg