|
Replies:
3
-
Pages:
1
-
Last Post:
Sep 11, 2012 12:27 AM
by: Yoann
|
|
|
Posts:
58
Registered:
3/15/11
|
|
|
|
SQL page, bind parameter, how to put null value?
Posted:
Aug 1, 2012 1:57 AM
|
|
|
when having a select statement with bind parameters, I was trying to pass a NULL value, but the system takes it has being a string with the value 'NULL' instead of NULL.
and we have to provide a value to be able to execute the query.
I need to do this because I'm testing a query that exists in the code where there are conditions like
- WHERE :param IS NULL OR :param = COL_X ...
|
Eclipse SDK Version: 3.7.2(32bit) Build id: M20120208-0800
-
TEE 1.8.0
-
Windows Seven(64bit)
-
JRE 1.6.0_27(32bit)
|
|
Posts:
559
Registered:
1/26/11
|
|
|
|
Re: SQL page, bind parameter, how to put null value?
Posted:
Aug 7, 2012 2:41 AM
in response to: Yoann
|
 |
Helpful |
|
|
Hi Yoann,
thank you for reporting. Seems that the null value is handled incorrectly in the bind parameter dialog, we will find and fix this bug. TEE-432.
Tomas
|
|
|
Posts:
559
Registered:
1/26/11
|
|
|
|
Re: SQL page, bind parameter, how to put null value?
Posted:
Aug 16, 2012 1:31 AM
in response to: Yoann
|
 |
Answered |
|
|
Yoann,
this issue will be fixed in version 1.6.2. To enter a NULL value, you just leave the input field blank (it works similarly in Toad).
So wait for the next release and give it a try.
Tomas
|
|
|
Posts:
58
Registered:
3/15/11
|
|
|
|
Re: SQL page, bind parameter, how to put null value?
Posted:
Sep 11, 2012 12:27 AM
in response to: Tomas
|
|
|
Working. Thanks a lot.
|
Eclipse SDK Version: 3.7.2(32bit) Build id: M20120208-0800
-
TEE 1.8.0
-
Windows Seven(64bit)
-
JRE 1.6.0_27(32bit)
|
|
|
Legend
|
|
MVP: 2501
+
pts
|
|
Guru: 2001
- 2500
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
