SQL to ORACLE CONVERSION(HELP!!!!!!!!!!)

[edwindow]

I am having a dificult time converting a SQL 7.0 report to Oracle. The Oracle database has the same tables as the SQL database. I change the driver and then set the locations and the only visual problems in the query are that the table names are in lower case. Running this against the Oracle database produces an invalid table name error. I look in the visual linking table and the field names are in upper case but the table name are still in lower case. Which in turn keeps the table names in the query as lower case. But if I drop the tables in the visual linking area to add the new tables i will loose fields that I have on the report which means I should have just done the report from scratch. Does anyone know an easy way to make this conversion without having to loose data on the report?


Ex. "security_profile"."EMP_ID" = "transactions"."EMP_ID"

 

[BFAGG]

When in the 'Set Location' window, simply go to the table name in the lower part of the screen and overtype it in UPPERCASE. Do this for all tables individually. This will resolve the problem.

Bill

 

[edwindow]

In the Set Location window the tables do reflect upper case names however the visual linking window and the rest of the code including the query still display in lower case.

 

[johndaniels]

There is a couple of handy tools on the Crystal Decisions web site for updating a reports' drivers and table names and locations. If you're using CRW v6 or v7, search for update60.zip, if you're using v8+ search for update8x.zip. Changing the locations and table names (and converting to uppercase) through this tool may help.