ADO uses ROWID on index-only table

Hi all,

When using ADO (2.7) on an Oracle table created as "ORGANIZATION INDEXED", I get ORA-01410 (invalid ROWID) errors as soon as I update a record in a recordset (rstData.Update). AddNew works fine. I know index-only tables do not have an ROWID, so if ADO (provider OraOLEdb) uses them on this kind of table, the error makes sense. For performance/storage we desperately need this type of table (Prim.key is 75% of the record, w're talking millions of records), so does anyone know of a workaround?

André Hendriks

I am not a ADO guru,
But you can try a update statement and execute it with the recordset.

-dharma