Hi!

I'm working on reports based on both Oracle and SQL Server. I began testing
these reports so that I would only need one report to run on both, instead
of having 2 separate lists of reports for each.
However I've been coming across errors when I run the report.

Does anyone have any information that would help me with this?
All I have done is taken out the database name in the 'set location' part of
the database specifications in Crystal. I've also implemented in VB to allow
for the to_char/convert functions in Oracle and SQL SERVER respectively.

All help would be greatly appreciated,

Jenny

You may be having problems with syntax. If your original SQL Server
statements creates joins according to recommended T-SQL syntax then
they will all have to be changed before a PL/SQL parser will be able to
read them(unless my knowledge of PL/SQL is out of date and that is not
unlikely).
In PL/SQL the joins are established in the where clause and the from
clause is simply a list of tables. Changing your syntax to reflect this
will not give you any problems in T-SQL as it understands both forms of
join.
As I say, I hope I'm not out of date on the PL/SQL question.
--
Eire abu!

Sent via Deja.com http://www.deja.com/
Before you buy.