Any reason why you are not doing it simpler like this: to get list of user id's for specific view SELECT USER_VIEWS_MAP.USER_ID FROM USER_VIEWS_MAP WHERE USER_VIEWS_MAP.VIEW_ID = @viewid
and something like this get the user table: SELECT USER_INFOS.* FROM USER_INFOS INNER JOIN USER_VIEWS_MAP ON USER_VIEWS_MAP.USER_ID = USER_INFOS.ID WHERE USER_VIEWS_MAP.VIEW_ID = @viewid Joins are normally much faster than IN SELECT because of better index use. ~Gerdus On Thu, Apr 29, 2010 at 4:36 PM, Jiri Cincura <[email protected]> wrote: > On Thu, Apr 29, 2010 at 15:30, korkless <[email protected]> wrote: >> it's a bug or i'm doing samething wrong? > > You can't use a parameter there, as server isn't able to infer the > type. Easiest way is to do there a cast. > > -- > Jiri {x2} Cincura (CTO x2develop.com) > http://blog.cincura.net/ | http://www.ID3renamer.com > > ------------------------------------------------------------------------------ > _______________________________________________ > Firebird-net-provider mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
