Devart Forums

I installed the new version of ODAC and then found that I could no longer change data in my Oracle tables. No changes were made to my Delphi2005 code and when I re-installed the earlier version of ODAC - all worked OK.
Note that the ReadOnly property of the table is set to FALSE.

I have the same problem since version 5.55.1.25.
So I'm still using version 5.55.1.24. I thougt the problem
is fixed in 5.70 - but ...

Found something that have changed in OraSmart.pas (CreateFieldDefs
sets FieldDesc.ReadOnly := True and after Update a "ROLLBACK TO SAVEPOINT" is made).


@CoreLab
Steps to reproduce:
1. Create a table TESTTAB with 280 Fields (FIELD001 ... FIELD280, type doesn't matter, NUMBER(5) work's quite well)

2. Create a new application with a TSmartQuery (qr), TDataSource, TDBGrid and TNavigator.

3. Set qr.SQL to "SELECT FIELD001, FIELD002, FIELD171, FIELD200 FROM TESTTAB", set qr.UpdatingTable to "TESTTAB", set qr.KeyFields to "FIELD001"

4. Rightclick on qr and add the four fields.

5. In the property-inspector you will see that FIELD171 and FIELD200 have set ReadOnly to True!!!
Why??

6. Set Readonly-Property for FIELD171 and FIELD200 to False.

7. Run the programm and insert a record fill the four fields with 1, 2, 3 and 4. Click Post.
The Grid shows 1, 2, 3 and 4.

8. Click Refresh.
The Grid shows 1, 2, and .

Please fix this ASAP

We couldn't reproduce your problem. Please send to ODAC support address more detailed description of your problem and small sample to reproduce your situation including script to create server objects.

Sample sent.

Thank you for your sample. We reproduced your problem and fixed it. This fix will be included in the next ODAC build.

I have just tried version 5.70.0.29 and it has not fixed the problem

This bug was fixed in ODAC 5.70.0.30.