Problem updating multi field unique index tables
Posted: 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);
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);