Hi,

I am using FB.Net 2.0.1.0. And I try to use FbCommand do the follow query:
SELECT * FROM USERS WHERE ROLEID IN (10,20)

So my query in FbCommand like this: SELECT * FROM USERS WHERE ROLEID IN
(@ROLELIST)

At first, I try to set FbParameter ROLELIST as DBType.String, and value as
"10,20,30", but it seems not working.

Can anyone give me some suggestion please?


Cheers,
-- 
Tao
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to