Cached Updates and Index Organized Tables

[CraigJ]

I think I've found a bug in DOA 3.4.5 using CB 5 and Index Organized tables. It seems that when the table is indexed organized cached updates is basicaly broken. I tried changing the lock mode but just got different errors. The main error I got was "record changed by another user".

When I created a similar table with the same primary, foreign keys, and constraints, but not index organized; the errors go away.

I've got a sample CB application if you want to look it over. I could also get you a SQL trace.

Thanks
Craig Jensen

 

[Marco Kalter]

The TOracleDataSet does not support Index Organized tables. The rowid format is different from other tables, and this requires some changes in the dataset code. This will be fixed in the next release.

------------------
Marco Kalter
Allround Automations

 

[CraigJ]

Thanks for the confirmation. We look forward to the next release.