lookup condition and constraints
Posted: Wed Jan 03, 2007 8:00 am
Hello dsxians !
In first I wish you a happy new year 2007 !
I'm trying to do a lookup that work with 2 oracle tables:
the first is input and the second is the reference_date and I want all the input rows if the table reference_date is empty.
Then if the reference_date is not empty we use the lookup but if is empty we want to pass all rows.
And I don't want to use the reject link
Thanks in advance for your ideas !
In first I wish you a happy new year 2007 !
I'm trying to do a lookup that work with 2 oracle tables:
the first is input and the second is the reference_date and I want all the input rows if the table reference_date is empty.
Then if the reference_date is not empty we use the lookup but if is empty we want to pass all rows.
And I don't want to use the reject link
Thanks in advance for your ideas !