[Firebird-net-provider] FW: problem with parameters

2010-08-30 Thread Matej Golob
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

[Firebird-net-provider] problem with parameters

2010-08-26 Thread Matej Golob
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 =