Using AS to rename a field

polo022 · Mar 15, 2006

Hello,
Me again...

I have a problem using AS to rename a field.
Here is the source code :
TABLE FILE MYFILE
PRINT MYFIELD AS 'NEWNAME'
ON TABLE HOLD AS HOLD1
END

TABLE FILE HOLD1
PRINT NEWNAME
END

This works when I run it from the editor or from the saved procedure but it does not work when run from ReportCaster.
The error messsgae is INF32073.

Thank you

Tyrian · Mar 15, 2006

hi!
try this
SET ASNAMES=ON

polo022 · Mar 15, 2006

Hello,
I already tried it and even with ASNAMES=ON ReportCaster does the same error. But it works if run from the editor. :-/

polo022 · Mar 16, 2006

Could anyone help me please?

focwizard · Mar 17, 2006

After you issue the HOLD AS HOLD1 and END, can you issue the following:

?FF HOLD1

This will show what fields are found in the HOLD file called HOLD1. You may find that there's another HOLD1.MAS somewhere. To find where it is, issue:

WHENCE HOLD1 MASTER

and it'll tell you where the HOLD1 Master file is found.

polo022 · Mar 19, 2006

Hello

?FF HOLD1 run from the editor returned "NEWNAME" (renamed field).
?FF HOLD1 run from ReportCaster returned "MYFIELD" (original field).

WHENCE HOLD1 MASTER returned the file path but Icannot find the file HOLD1.MAS because it was already deleted I think.

polo022 · Mar 20, 2006

OK, problem solved.

I have done a big mistake. Instead of typing "SET ASNAMES=ON" I typed "-SET ASNAMES=ON".

Thank you for your help, sorry for the mistake

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Using AS to rename a field

polo022

Programmer

Tyrian

Programmer

polo022

Programmer

polo022

Programmer

focwizard

Vendor

polo022

Programmer

polo022

Programmer

Similar threads

Part and Inventory Search

Sponsor