Similar problem as described in previeous mail, I get when I compare
parameter with some subselect for example:
SELECT CASE WHEN (@n0 IN (SELECT 'X' FROM rdb$database)) THEN 1 ELSE 0 END
FROM RDB$DATABASE
With this statement I get error:
Data type unknown
From: Matej Golob [mailto:ma...@pohorje.net]
Sent: Thursday, August 26, 2010 12:05 PM
To: 'firebird-net-provider@lists.sourceforge.net'
Subject: problem with parameters
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
