ADO uses ROWID on index-only table
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?
I am not a ADO guru,
But you can try a update statement and execute it with the recordset.
Click Here to Expand Forum to Full Width