Subject Re: [IBO] Horizontal refinement in TIBOTable
Author Helen Borrie (TeamIBO)
At 09:37 PM 28-01-02 -0700, you wrote:
>TIB_Query has a flexible Master/Detail relationship
>via MasterLinks and MasterSource.
>TIBOQuery is appears to be missing this and Master/Detail
>link parameters seem to come from whatever matches an
>internal pool by the same fieldname used in the Query
>for the detail as 'field = :field', regardless the
>settings of Keylinks and then only when paramCheck is
>set to True, else I get an internal paramater mismatch error.
>Trying to Master/Detail link two TIBOQueries say for
>table A and B on Keylinks = B.Field1=A.Field2


1. Keylinks linking isn't for master-detail, it's for Keysource-Lookup relationships in the native IB_ datasets.

2. TIBOQuery uses TDatasource and so is stuck with its rather crippled way of linking detail queries to masters, through linking the detail's Datasource property to the master's TDatasource. There is no provision for specify the link columns - TDataset does it by matching column names alone.

If it is able to match column names, the link will work as long as both columns are of identical data type; otherwise you will get a parameter type mismatch. :(

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at