Double-Quotes on table alias names

[mitchell123]

Hi -
Is there any way to STOP Crystal from putting double-quotes on table alias names when changing the datasource (Set datasource location)? (Version 9 or XI)

The details of my problem are as follows: I'm converting existing reports from Sybase to Oracle. The original reports were written in 8.5 which allowed you to manually change the SQL (in Show SQL).

The reports are now in version 9 and can't be opened in 8.5 any more so I can't re-change the SQL
The original table names are in mixed-case but the new Oracle table names are in all upper-case. When I change the datasource location, Crystal creates an alias for the table name and puts it in double quotes. Because this mixed-case name is double quoted, Oracle doesn't recognize the table name.

I tried to force the alias name with the "Overridden qualified table name" but this doesn't seem to change the sql in Show SQL (I updated version 9 to the lastest service pack and also tried this in XI)

Here's an example: Table1 in the where-clause doesn't get changed to double quotes since it is code that was manually edited/added in version 8.5 (and so can't be changed any more)

SELECT "Table1"."DATE_CLOSED" FROM "SCHEMA"."TABLE1" "Table1"
WHERE Table1.Date_Closed IS NULL


Any help, thoughts are appreciated!!

 

[synapsevampire]

I don't think there is a way to do so.

Perhaps the Report->Options->Database server is case sensitive will help, not sure.

You might be able to get around this by copying the SQL out and placing it in a Command Object.

As you can see, modifying the SQL directly was never a good idea, try to avoid proprietary solutions going forward by using Views, SPs, etc.

-k