FrankInBerlin
IS-IT--Management
Hi everybody!
I have big problems with an OR-statement after we changed a database view.
We have a Oracle 8 database and use CR 8.5.
I created a report using a view and some tables.
The statement in the select expert looked like this:
({view.name_1} = ?Name or
{view.name_2} = ?Name or
{view.name_3} = ?Name ) and
table.cond <>1
This worked fine!
Then we added another field to the view called 'name_s'
I used the 'verify Database' option and added the new field:
({view.name_s}= ?Name or
{view.name_1} = ?Name or
{view.name_2} = ?Name or
{view.name_3}= ?Name ) and
table.cond <>1
Now I get only records where ({view.name_s}= ?Name is true. :-(
If I change the order to:
({view.name_1}= ?Name or
{view.name_2} = ?Name or
{view.name_3} = ?Name or
{view.name_S}= ?Name ) and
table.cond <>1
I get all records except those where ({view.name_s}= ?Name is true.
I also ran the SQL-Statement form CR directly on the DB and the results were perfect.
I removed the view and added it again; no improvement!
I am running out of ideas..
Please help...
Frank
I have big problems with an OR-statement after we changed a database view.
We have a Oracle 8 database and use CR 8.5.
I created a report using a view and some tables.
The statement in the select expert looked like this:
({view.name_1} = ?Name or
{view.name_2} = ?Name or
{view.name_3} = ?Name ) and
table.cond <>1
This worked fine!
Then we added another field to the view called 'name_s'
I used the 'verify Database' option and added the new field:
({view.name_s}= ?Name or
{view.name_1} = ?Name or
{view.name_2} = ?Name or
{view.name_3}= ?Name ) and
table.cond <>1
Now I get only records where ({view.name_s}= ?Name is true. :-(
If I change the order to:
({view.name_1}= ?Name or
{view.name_2} = ?Name or
{view.name_3} = ?Name or
{view.name_S}= ?Name ) and
table.cond <>1
I get all records except those where ({view.name_s}= ?Name is true.
I also ran the SQL-Statement form CR directly on the DB and the results were perfect.
I removed the view and added it again; no improvement!
I am running out of ideas..
Please help...
Frank