Problems with version 5.70.0.28 - unable to edit data in tables

Helen Annels · Post by **Helen Annels** » Thu 26 Jan 2006 15:49

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.

cis-wurzen · Post by **cis-wurzen** » Fri 27 Jan 2006 09:53

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

Challenger · Post by **Challenger** » Fri 27 Jan 2006 10:01

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.

cis-wurzen · Post by **cis-wurzen** » Fri 27 Jan 2006 13:29

Sample sent.

Challenger · Post by **Challenger** » Mon 30 Jan 2006 09:58

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

Helen Annels · Post by **Helen Annels** » Tue 21 Mar 2006 15:37

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

Challenger · Post by **Challenger** » Mon 13 Nov 2006 13:03

This bug was fixed in ODAC 5.70.0.30.