| empty field isn't considered as such in where clause of a block [message #438360] |
Fri, 08 January 2010 05:47  |
fcherri
Messages: 10
Registered: December 2009
|
Junior Member |
|
|
Hello,
I have 3 problems.
I have a form with a header for search criteria
and a a block for results of the search.
1- one of the search criteria field is a LOV. (XXHEADER.T_DRIVER)
when "VALIDATE FROM LIST" = Yes it doesnt work -- ANY IDEA WHY?
2- this (1) search criteria is in the where Clause of the Block as such
WHERE Driver_name like '%' || :XXHEADER.T_DRIVER || '%'
If i havent chosen any value: it should normally dispaly all the rcords But it is displaying Noone as if :XXHEADER.T_DRIVER is not Null.
3- if i delete any of the search criteria fields using the keyborad back space, and press find nothg is dispayed --->> I NEED TO CLEAR ALL FIELDS using the oracle apps clear -- ANY IDEA.
Thx
|
|
|
|
|
|
|
|
|
|
| Re: empty field isn't considered as such in where clause of a block [message #438413 is a reply to message #438360] |
Fri, 08 January 2010 15:34  |
bad_sector007
Messages: 12
Registered: December 2009
Location: Egypt
|
Junior Member |
 
|
|
Hello
for the first question Do you try to do this in the query mode(validate from list in query mode) ?
for the second question i can't find the problem but try to create a simple form based on hr schema (employee table only )
and try this code in the where Clause of the Block as this
WHERE FIRST_NAME like '%' || :FIRST_NAME || '%'
this code worked with me.
for the third question i can't understand it but all i can get that you want to clear all fields in the query mode if so you can try to query again and it will clear all the field .
khaled farouk
[Updated on: Fri, 08 January 2010 15:37] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
