Problem updating multi field unique index tables

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
valentl
Posts: 16
Joined: Wed 22 May 2013 06:15

Problem updating multi field unique index tables

Post by valentl » Thu 13 May 2021 06:35

I created a sample.
I have a table, with two fields, and a unique index for this two fields.
when I drop a TOraTable component onto a form, and try to open-edit-post, I get an error message for posting.
I did not set any property to the key fields, order fields, anyithing, only the table name.
Oracle DB Monitor does not show anything.
With the previous version, I did not had this problem.

Field FIELD1,FIELD2 not found.
Delphi Debug call stack shows this:
:0070e5f6 TCRRecordSet.FillFieldDescs + $10E
:0070e384 TCRRecordSet.GetKeyFieldDescs + $84
:0070e4c1 TCRRecordSet.GetKeyAndDataFields + $31
:0071fc2c TDASQLGenerator.GenerateSQL + $A8
:00831aac TCustomDBOraSQLGenerator.GenerateSQL + $50
:00747057 TDADataSetUpdater.CheckUpdateSQL + $327
:0074956b TDADataSetUpdater.PerformSQL + $53
:00830633 TCustomOraDataSetUpdater.PerformSQL + $4B
:0074a2a3 TDADataSetUpdater.PerformAppend + $33
:008309da TCustomOraDataSetUpdater.PerformAppend + $AE
:008594b3 TSmartDataSetUpdater.PerformAppend + $B

Using Delphi 10.2 update 3,
Odac 11.4
Oracle Database 11g Release 11.2.0.3.0

The Delphi component is very simple.
object TBL: TOraTable
TableName = 'twofields'
Session = OraSession1
end


create table twofields(
field1 number,
field2 number
);

create unique index twof1 on twofields(field1,field2);

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Problem updating multi field unique index tables

Post by MaximG » Mon 17 May 2021 18:22

We've reproduced the issue and fixed it. The fix will be included in the next build of our product. As a workaround, we can send you a night ODAC build including the required changes. For this provide us with your license number and IDE version you are interested in For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

valentl
Posts: 16
Joined: Wed 22 May 2013 06:15

Re: Problem updating multi field unique index tables

Post by valentl » Fri 11 Jun 2021 06:39

Thank you, but we downgraded to the previous ODAC version, we can use it without problems.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Problem updating multi field unique index tables

Post by MaximG » Fri 18 Jun 2021 11:20

We can send you the nightly build that includes the fix, if you want.

Post Reply