Problem with Oracle Views

[jcl5]

Hi

Using CR10 and Oracle 8i

I have written a simple view as follows;
create or replace view vw_maxtrdate (transdate,compno) as
(select max(transdate), compno from trans
where trantype_code<>'MLLMLL'
group by compno);
It works fine and I can use it in Crystal no problem.

However, I wanted to add a date parameter to that view as follows:
(select max(transdate), compno from trans
where trantype_code<>'MLLMLL'
and trandate<'30-Jun-04'
group by compno);

This still works ok - I can see the records via SQL+ and through MS Access but when I use the view in Crystal it doesn't find any records.

Any idea what's wrong?

Thanks

jcl5

 

[Turkbear]

Hi,
No obvious reason..If the View returns data in SqlPLus and the user is the same, then it should return the same records when the view is used as the datasource for the report.
If you are using the same report as you used before altering the View, be sure to use the 'DataBase..Verify Database' option before running it.