Subject | RE: [IBO] Master - Detail with TIBOQuery |
---|---|
Author | Salim Naufal |
Post date | 2003-06-10T17:26:41Z |
Hi Marcel,
Yes, you can achieve that:
In the master query, you should have a field whose name will be passed as
parameter to the detail query. For example:
In the master TIBOQuery: SELECT CODE, NAME FROM MASTER_TABLE
In the detail: SELECT A, B, C FROM DETAIL_TABLE WHERE MASTER_CODE = :CODE
Add a DataSource and set the DataSet To the Master TIBOQuery
In the detail Query, Set the Datasource to the one you just created.
That's it.
-----Original Message-----
From: Marcel G|ttler [mailto:guettler@...]
Sent: Tuesday, June 10, 2003 18:18
Subject: [IBO] Master - Detail with TIBOQuery
is there a way to connect two Querys of TIBOQuery (iboTDataset) in a
Master-Detail Relation. The Problem is, that TIBOQuery has no
"Mastersource" - property. I can' t use TIBOTable and TIBQuery, because of
Thrid Party Grids (XpressQuantumGrid cannot connect with TIB_Datasource only
with TDatasource).
Yes, you can achieve that:
In the master query, you should have a field whose name will be passed as
parameter to the detail query. For example:
In the master TIBOQuery: SELECT CODE, NAME FROM MASTER_TABLE
In the detail: SELECT A, B, C FROM DETAIL_TABLE WHERE MASTER_CODE = :CODE
Add a DataSource and set the DataSet To the Master TIBOQuery
In the detail Query, Set the Datasource to the one you just created.
That's it.
-----Original Message-----
From: Marcel G|ttler [mailto:guettler@...]
Sent: Tuesday, June 10, 2003 18:18
Subject: [IBO] Master - Detail with TIBOQuery
is there a way to connect two Querys of TIBOQuery (iboTDataset) in a
Master-Detail Relation. The Problem is, that TIBOQuery has no
"Mastersource" - property. I can' t use TIBOTable and TIBQuery, because of
Thrid Party Grids (XpressQuantumGrid cannot connect with TIB_Datasource only
with TDatasource).