| parameter null value [message #149238] |
Wed, 29 March 2006 06:50 |
Eclipse User |
|
|
|
Originally posted by: r.budner.abg.com.pl
Dataset parameter's default value can't be null but from the other hand
Report's parameter allow null values.
In my opinion it is bad idea.
However it is strange behaviour.
I allow user to pass null value for report's parameter and I want to
pass it to dataset's query. My query contains the following condition:
....
WHERE id = nvl(:p_param, id)
Such query will return all rows when :p_param is null or exactly one row
when :p_param is not null.
Unfortunately it can't be done with BIRT. When user passes any value
everything is OK. But when he/she will pass null an exception would be
raised. The message of that exception is misleading:
org.eclipse.birt.data.engine.core.DataException: Default value for input
parameter cannot be null.
The default value of my parameter is 1.
I'm curious how do you handle that issue.
Robert
|
|
|
Powered by
FUDForum. Page generated in 0.03701 seconds
Home