I have problem when I use parameters and compare parameter value with null.
I've create simple snipet code, which represents problem:
FbCommand com = connection.CreateCommand;
com.CommandText = "SELECT * from rdb$database where @n0 is
null";;
FbParameter par = new FbParameter("n0", FbDbType.VarChar);
par.Value = "a";
com.Parameters.Add(par);
var reader = com.ExecuteReader();
No mather what value is, If I execute this I get error: Invalid data type.
If I do >same< with literals (>SELECT * from rdb$database where 'a' is
null<) of course everything works fine, so I assume there should be problem
in provider.
Thanks for help.
Matej
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
