Subject Updating detail TIBOQuery causes PK violation
Author Ed Dressel
I have a M/D relationship between 2 TIBOQuerys where the detail query
uses a DataSource and has a parameter for the detail query.

When I go to change a value in the detail query and the update SQL is
prepared, it uses the master_id field as the record identifier rather
then the record identifier. (But it just makes that assumption about
it--I did not set a record identifier anywhere... where would I?)

Below is the detail query. The master field identifier is
TAXTABLE_ID, the detail field identifier is not shown (TAXYEAR_ID).

object qryYears: TIBOQuery
Params = <>
AutoFetchAll = True
DatabaseName = 'APTAXFILES_1'
IB_Connection = ibConn
KeyLinks.Strings = (
'TAXTABLE_ID = :TAXTABLE_ID')
ReadOnly = True
RecordCountAccurate = True
DataSource = dsTables
JoinLinks.Strings = (
'TAXTABLE_ID=:TAXTABLE_ID')
SQL.Strings = (
'select * from TaxYear')
FieldOptions = []
...<field list/>

Is there a way to set the record identifier?

I realize I set the EditSQL statement (which I have done) but it
seems that I am doing something wrong in the SQL as I haven't had to
do this before (with other backends).

Thanks
Ed Dressel