Not quite correct

In TIBOQUERY

SELECT * FROM DETAIL
WHERE ID_NO = :ID_NO /* :ID_NO THE NAME OF A MASTER FIELD */

The ':ID_NO' can be any fieldname of simular type. like ':FIRSTNAME' if
the master has a field FIRSTNAME. No errors will popup of the FieldName
specified after the : does not exist in the master.

Any combination of multiple field can be used. It is very flexible.
Have code example available.

Best Regards
Hans

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, October 11, 2004 7:51 PM
Subject: Re: [IBO] Master Detail with IBO


>
> At 01:24 AM 12/10/2004 +0000, you wrote:
>
>
> >When a user moves from ojne record to another in a master IBODataset I
> >need a detail IBODataset to change accordingly. Setting the datasource
> >property doesn;t seem to work?? Is there soething more that I need to do?
>
> With the TDataset-compatible comps, yes. Exactly as with its VCL
ancestor,
> the TDataset can't make the link if the name of the linking detail column
> does not exact;u match the name, type and, in the case of a composite key,
> the left-to-right order, of the primary key (or its KeyLinks, to be more
> exact) in the master.
>
> If that is your case, then use a parameterised query in the detail set,
> with a WHERE clause that specifies the link column(s). Then, by linking
> the detail's Datasource property to the master's datasource, the master's
> PK (i.e. KeyLinks) will be used to populate the detail's WHERE clause
> when the master's scroll event occurs.
>
> Helen
>
>
>
>
>
___________________________________________________________________________
> 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 !
> Yahoo! Groups Links
>
>
>
>
>
>
>