I have found no problem with M/D as long as the
":Client_Number" part is the same name as a field "Client_Number"
in the master. TIboQuery.ParamCheck must be set to true
No error message if it is not, but it just won't work.

Thus very flexible, a detail can follow an master field :)

Best Regards
Hans

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

qryB.SQL.Text = select * from Addresses where Client =
:Client_Number

Jason Wharton wrote:

>
> I don't understand the nature of this problem.
> Can anyone shed me some additional light on this issue?
>
> Thanks,
> Jason Wharton
>
> ----- Original Message -----
> From: "Sandeep" <sandeep@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Thursday, October 18, 2001 2:06 PM
> Subject: Re: [IBO] TIBOQuery
>
> > On 18 Oct 2001, at 14:20, Jason Wharton wrote:
> >
> > > > Can I use the Datasource property of TIBOQuery to setup master-
> > > > detail relationship.
> > >
> > > Yes, did you try it?
> > >
> > > It works just like TQuery.
> >
> > yes I did, it doesn't works. I'm using Dialect3.
> > I have a 2 queries
> >
> > qryA.SQL.Text = select * from "Client"
> >
> > and
> >
> > qryB.SQL.Text = select * from "Addresses" where "Client" =
> > :"Client_Number"
> >
> > and I have a datasource 'dtsA' that has dataset pointing to qryA
> > and datasource property of qryB is pointing to 'dtsA'.
> >
> >
> > Sandeep
> >
> > Software Developer
> > CFL
> > sandeep@...
> > http://www.cfl.co.nz
>
>
> ___________________________________________________________________________
> 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/