Subject | Updating detail TIBOQuery causes PK violation |
---|---|
Author | Ed Dressel |
Post date | 2003-12-08T18:28:04Z |
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
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