Subject | Re: [IBO] Master-detail with TIBOQuery |
---|---|
Author | mitch_landor |
Post date | 2006-11-19T06:11:23Z |
At 10:28 AM 8/11/2005 -0300, you wrote:
of the detail set to point to the TDatasource of the master set. Provided
the foreign key of the detail table matches the primary key of the master
set by name and type, that is all you need to do.
and the master's PK do not match.
Helen
=======
I need to use the "where" clause because my Fkey/Mkey field names do
not match. In this case how do I get the Fkey field in the detail
table to fill in automatically when I add a detail row?
It was all working splendidly and I changed something (can't remember
what) and now detail inserts don't work properly.
Thanks
Mitch
>>Hi,It is just the same as TQuery in this respect. Use the Datasource property
>>
>>Is there any hide property in TIBOQuery to set master-detail? With
>>TIB_Query I use masterSource + masterLinks but I didn't find these
>>properties in TIBOQuery.
of the detail set to point to the TDatasource of the master set. Provided
the foreign key of the detail table matches the primary key of the master
set by name and type, that is all you need to do.
>Should I use "where" clause to do this?You will have to use a where clause only if the names of the detail's FK
and the master's PK do not match.
Helen
=======
I need to use the "where" clause because my Fkey/Mkey field names do
not match. In this case how do I get the Fkey field in the detail
table to fill in automatically when I add a detail row?
It was all working splendidly and I changed something (can't remember
what) and now detail inserts don't work properly.
Thanks
Mitch