Try something like this:
SELECT * from rdb$database where CAST(@n0 AS VARCHAR(10)) is null
On Thu, Aug 26, 2010 at 8:04 PM, Matej Golob ma...@pohorje.net wrote:
I have problem when I use parameters and compare parameter value with null.
I've create simple snipet code, which represents problem:
com.CommandText = SELECT * from rdb$database where @n0 is null;;
You can't parametrize the Column name.
You can use 'execute statement' rather :)
eMeL
--
Sell apps to millions through the Intel(R) Atom(Tm) Developer
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 =
I don't think you can pass a column name as a parameter. If I execute
the same query using Database Workbench I also get Dynamic SQL Error
SQL error code = -804 Data type unknown error so it must be
limitation of firebird database.
It would in any case not be any faster since I don't think the