| Parameters with possible null values [message #88778] |
Mon, 17 March 2003 06:33 |
Barry Dogger
Messages: 4
Registered: September 2002
|
Junior Member |
|
|
What I'm trying to accomplish is to create a report that has 4 paramaters.
The first one is mechanic name. This one is also the problem. This is a column called wo_craft which is a foreign key. However, nulls values are allowed.
Now, I created a parameter which values are restricted to a predetermined list. Because I want to be able to select all mechanics, I added the '%' as a wildcard.
So in the query I have the following where condition:
wo_crft like '%' || :p_Monteur
This works for all mechanics and for a specific mechaic but not for the null values. But I do need to see these null values.
What can I do?
Thanks in advance.
Barry
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
