Report 6i, changed table name, compile error

Hi,

[Quoted] [Quoted] 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.