NULL in where statement
Posted: Mon 25 Mar 2019 14:09
Hi,
i'm new on devConnect universal. Actually i have the task to update some rows by the statement "where b_id is NULL".
Here is my statement:
update test set b_id=:b_id where b_id is @b_id
Parameter b_id: 2
Parameter @b_id: DBNULL.value
This returns errors. How do I have to do this?
Thanks for help.
i'm new on devConnect universal. Actually i have the task to update some rows by the statement "where b_id is NULL".
Here is my statement:
update test set b_id=:b_id where b_id is @b_id
Parameter b_id: 2
Parameter @b_id: DBNULL.value
This returns errors. How do I have to do this?
Thanks for help.