Re: Report 6i, changed table name, compile error

hi

just use aliases (even if it seems useless in this case) select column1 column1, colums2 column2, ... from table

if this doesn't word, first try different names as aliases then the real column name.

i suppose once you've got it using the alisases in the query you can remove them without changig the names again (just try after saving)

hth
SL

Suresh Bhat schrieb:

> Hi,
>
> One of our Developer had to change a table name from SA_AWARDS to
> SAFETY_AWARDS in Oracle reports 6i. This was only a table name change
> everything being the same.
>
> When he changed the table name in SQL Query to SAFETY_AWARDS, he got
> compilation errors because all the column names have 1 appended to it.
>
> He says he cannot change the column names either in the Object
> Navigator, property palette or the Layout editor.
>
> Is there any way to change the column names back to what they were ?
>
> Thanks.
>
> --
> Suresh Bhat
> Oracleguru
> www.oracleguru.net
> oracleguru_at_mailcity.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 02 2000 - 08:23:45 CET