Subject TIBOQuery Master/Detail
Author hans@hoogstraat.ca
Hi Helen,

Since this question repeatingly pops up, would you mind
including this snippit in TIBO Docs ?

============================================================
TIBO_QUERY Master/Detail

>From my experience, this works:

Assume IBO_MASTER : TIBOQuery with DS_IBO_MASTER : TDataSource
and IBO_DETAIL : TIBOQuery

set IBO_DETAIL.SQL.TEXT = 'Select * from Detail where FieldA = :FieldB
and
set IBO_DETAIL.DataSource := DS_IBO_MASTER
and
set IBO_DETAIL.ParamCheck := True

Now IBO_DETAIL will follow IBO_MASTER on
IBO_DETAIL.FieldA = IBO_MASTER.FieldB

No Error exception is raised if IBO_MASTER.FieldB doesn't exist.

Don't forget unique keylinks on IBO_Master and IBO_Detail

=================================================================