Got one Oracle table with 10 fields where I changed the fieldnames using the FILE TOOL. It works fine. It works fine in Developer Studio and the gui part of Developer Studio. The fields show up in the gui as the changed fieldnames.

I took a second table that has 200 fields and changed the fieldnames using the FILE TOOL. It works fine in ETL but not in Developer Studio. When I do a PRINT * with a recordlimit in Developer Studio I receive the following error:
(FOC1400) SQLCODE IS 904 (HEX: 00000388)
(FOC1410) SQL COLUMN NOT FOUND. (FOR TABLE: CHECK ALIAS NAMES)
: ORA-00904: "T1"."WOPRICESEP": invalid identifier
: Erroneous token: T1
L (FOC1406) SQL OPEN CURSOR ERROR. : AMZRWO

When I get into Developer Studio Gui all the fields show up with the Alias name not the changed Fieldname. I did the changes the same way as the first table. Can anyone tell me what I did wrong?

Thanks,
Jim
WebFocus 7.13
Unix Solaris
Oracle 10g
Developer Studio client 7.14

Jim

I searched on the focal point site and found the same issue here

http://forums.informationbuilders.com/eve/forums/a/tpc/...261064771#9261064771

take a look it seems to be a known issue and it can be solved by a setting.
give it a try.

Frank

We have this resolved. we were changing the Alias and should have changed the Fieldname. The only other item I noticed was when I did the changes to the master using the Dev Studio editor, it didn't work. The report wouldn't recognize the new fieldnames. I had to end up
using the "FILE TOOL" in ETL and change each fieldname one at a time.

Thanks for the link,
Jim