Hi Koby,

> Can some one please help me with this query.
> I want to be able to connect that param bellow
> With "MasterLinks" Or With "MasterParamLinks"
> and it always return with an error who look like this:
>
> "the CLient_ID is unknone column"

At what point? When the query is prepared?

And do you also get that error when you remove Master(Param)Links
and MasterSource, and reprepare the query?

> SELECT distinct CLIENT_INTEREST.INTEREST_ID,
> CLIENT_INTEREST.INTEREST_SUBJECT
> FROM CLIENT_INTEREST
> where Client_Interest.Interest_ID Not IN
> (Select Client_Interest_ID
> From Client_Belong_Interest
> Where Client_id = :ID);
>
> IS this mean that i can not assign param into a
> sub query ?

That should be possible. But... do you really have a Master-Detail
relation with another dataset, where the query you showed is the
Detail set? Have you set the MasterSource property, and does the
Master set indeed have a field called Client_ID (not only in the
database table, but also in your master query) ?

If so, it would help if you showed the SQL of the master set too, and
the exact contents of your Master(Param)Links.


Greetings,
Paul Vinkenoog