Hi,
Back end is Oracle.
Here is an ex:
Assume that my view has 3 fields, id(numeric),city, hire_date(date data type)
Some times I want to retieve data just by city. Then I give city value and dont bother about other two parameters(id and hire_date). I dont want id and hire_date fields to be null or blanks.
How can I set my id and hire_date params ??
Thanks
>>Hi,
>>
>>I have a remote view with numeric, date and char parameters.
>>If I want to retrieve my view based on blank numeric or date fields, how can I do that? I am able to do for char params, for ex., city like 'PARIS%'.
>>
>>Please advise me how to do for numeric and dates
>>
>>Thanks
>
>This is just a shot in the dark but have your tried to query for .null.?
>
>What is the bakend that you are using?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only