Focal Point
[CLOSED] Read the attribute from Maintain

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7167023206

April 17, 2011, 11:39 PM
LMP
[CLOSED] Read the attribute from Maintain
i gave all my conversiosn for time within maintain as following:

MAINTAIN FILE CAR

old/I9 = '-21600000';
compute pri2/I8 = &UTC_DIF;
compute pri/I9 = EDIT(old - pri2);

END

TABLE FILE CAR
PRINT
pri
ON TABLE PCHOLD FORMAT XML
END

But i get an error stating (FOC003) THE FIELDNAME IS NOT RECOGNIZED: pri when i gave
i even tried using -SET . Its not working.

Please let me know your suggestions.

This message has been edited. Last edited by: Kerry,


7.6.9, Windows
Excel and HTML
April 18, 2011, 07:07 AM
Waz
MAINTAIN is used to select insert update delete records in a data source.

You need to use DEFINE FILE to calculate pri.

I would suggest reading up on DEFINE and TABLE FILE


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

April 18, 2011, 09:03 AM
Maintain Wizard
LMP
I am not sure what you are trying to do here with Maintain. Are you writing that value back to a database? Please let me know what you are trying to do so we can help.

Mark
April 18, 2011, 09:32 AM
Francis Mariani
LMP needs access to WebFOCUS manuals.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server