> 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) Develope
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 wrote:
> I have problem when I use parameters and compare parameter value with null.
> I've create simple snipet code, which represents problem:
>
>
>
>
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
d
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
