RDA question

i am using RDA to synch data between sql server 2000 and my PDA. i try to
get a parameter list according to the group of a user in my program. my
query to pull is something like that :
"select id ,name from parametertable where groupid in ( select g.id from
grouptable g inner join usertable u on u.groupid = g.id where u.is =
<<userid>>)" with TRACKINGOFF option
this query works well in sql server 2000 and brings what i want. but it
gets all the items of parameter table in the PDA. i do not understand why.
i am new to RDA , is there anything that i miss ?
thanks
try rewriting the query to not use subquery for the RDA pull.
use a join if possible.
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Yener" <someone@.com.com> wrote in message
news:ORi4O$6wFHA.2620@.TK2MSFTNGP09.phx.gbl...
>i am using RDA to synch data between sql server 2000 and my PDA. i try to
>get a parameter list according to the group of a user in my program. my
>query to pull is something like that :
> "select id ,name from parametertable where groupid in ( select g.id from
> grouptable g inner join usertable u on u.groupid = g.id where u.is =
> <<userid>>)" with TRACKINGOFF option
> this query works well in sql server 2000 and brings what i want. but it
> gets all the items of parameter table in the PDA. i do not understand
> why.
> i am new to RDA , is there anything that i miss ?
> thanks
>
>
|||i found another code at the bottom that pulls the same table again!
i am sorry!!
"Darren Shaffer" <darrenshaffer@.discussions.microsoft.com> wrote in message
news:O0%238iFgxFHA.1252@.TK2MSFTNGP09.phx.gbl...
> try rewriting the query to not use subquery for the RDA pull.
> use a join if possible.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
> "Yener" <someone@.com.com> wrote in message
> news:ORi4O$6wFHA.2620@.TK2MSFTNGP09.phx.gbl...
>
|||so is your problem solved? not sure if we've helped you here or not.
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Yener" <someone@.com.com> wrote in message
news:%232QRy5CzFHA.2540@.TK2MSFTNGP09.phx.gbl...
> i found another code at the bottom that pulls the same table again!
> i am sorry!!
> "Darren Shaffer" <darrenshaffer@.discussions.microsoft.com> wrote in
> message news:O0%238iFgxFHA.1252@.TK2MSFTNGP09.phx.gbl...
>
|||yes Darren it is solved now. thanks anyway.
"Darren Shaffer" <darrenshaffer@.discussions.microsoft.com> wrote in message
news:eqyDGkMzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> so is your problem solved? not sure if we've helped you here or not.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
> "Yener" <someone@.com.com> wrote in message
> news:%232QRy5CzFHA.2540@.TK2MSFTNGP09.phx.gbl...
>