i have a problem that I'm sure there is a solution for but just can't quite figure it out.
what i need to do is create a parametized view where the value may, or may not, be need to be taken into consideration. I can write the sql to do this however, I can't get the View designer to do it.
i.e.
if I have a remote parametized view xyv, with name C(10), age N(2) fields
name age
tom 20
tom 30
Here is the SQL that I wrote to get the results and it works just fine.
select * ;
from xyz ;
where ;
iif(empty(m.name),.t.,xyz.name = m.name) and ;
iif(val(m.age)=0,.t.,xyz.age = m.age)
so if m.name = 'tom' and age = 0, I get the 2 records
or if m.name = 'tom' and age = 20, I get the one record,
or if m.name is empty and age = 20 I get the one record.
I just can't get the View designer to spilt this out ?????
Please help
Thanks :-)
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