Subject Re: [IBO] Master Detail with IBODataset
Author Hans Hoogstraat
As a matter of fact it is very easy with TIBOQuery.

Assume the common column between master and detail is Detail_No

Set the Detail.MasterSource to the Master DataSource Module

Just use say ' Select * from Detail where Detail_No = <double colon>
:Detail_No'

Now everything is automatically down for you :)

The fieldname don't have to be the same, as long as they exist. You won't
get a warning
if they don't exist. You can use multiple fields if required

-------------------------------------------




----- Original Message -----
From: "Lee Jenkins" <lee@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, November 20, 2003 11:37 AM
Subject: Re: [IBO] Master Detail with IBODataset


| Lee Jenkins wrote:
|
| > Hi,
| >
| > It appears that setting this up is different than standard dataset
| > behavior because I see no MasterKey field property, etc.
| >
| > Would someone kindly provide an example of syntax to use to setup MD
| > relationship on a form?
| >
| > I am assuming the KeyLinks property is for this....
| >
| >
|
| Hmmm. Looks like I cannot do this with an IBOQuery, only the TIBOTable...
|
| If this is the case, I think I will have to do it manually...
|
| --
|
| Warm Regards,
|
| Lee
|
|
|
|
___________________________________________________________________________
| IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
| without the need for BDE, ODBC or any other layer.
|
___________________________________________________________________________
| http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
| keyword-searchable FAQ, community code contributions and more !
|
| Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|