Focal Point
[SOLVED] focus error on reading a temporary file

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

May 31, 2012, 02:28 AM
Ponnakudam
[SOLVED] focus error on reading a temporary file
The following below is a focus statements. i am printing file CAF00100 contents to a temporary file STUD (line no: 7). when i tried to define this file again (line no: 10), the following error is obtained. let me know the reason for this:-

DEFINE FILE STUD
ERROR AT OR NEAR LINE 10 IN PROCEDURE CP00100FFOCEXEC
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: STUD
BYPASSING TO END OF COMMAND

focus statements

1 TABLE FILE CAF00100
2 PRINT STDID AS 'STUDENT ID'
3 TOT AS 'TOTAL'
4 AVG AS 'AVERAGE'
5 WHERE AVG GT 60.00
6 BY STDID NOPRINT
7 ON TABLE SAVE AS STUD
8 END
9 RUN
10 DEFINE FILE STUD
11 STDID1/A5=STDID;
12 TOT1/I3=TOT;
13 AVG1/P5.2C=AVG;
14 END
15 TABLE FILE STUD
16 PRINT STDID1
17 TOT1
18 AVG1
19 BY STDID1

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


WebFOCUS 7.6
Windows, All Outputs
May 31, 2012, 02:52 AM
Ponnakudam
when i changed SAVE AS to HOLD AS the issue is resolved

Thanks


WebFOCUS 7.6
Windows, All Outputs
May 31, 2012, 05:27 PM
Waz
FYI,

The SAVE command only created a data file. HOLD creates a datafile, and a description that FOCUS can use to read it.


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!