Subject | TIBOQuery Master/Detail |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2002-02-12T01:21:22Z |
Hi Helen,
Since this question repeatingly pops up, would you mind
including this snippit in TIBO Docs ?
============================================================
TIBO_QUERY Master/Detail
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
=================================================================
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
=================================================================