{Solved}Save File

I am not quite sure what I am doing wrong. I am trying to create my own saved file that I can then access when I want to create a report. I have tried different variations but I cannot get KFR to show up in the Table list. What is wrong with my code?

TABLE FILE WEBFOCUS_REPORT_AGENCY_DATA
BY AGENCYID
BY INDUSTRYID
BY MEMBERSHIPSTATUS
BY AGENCYNAME
BY TERRITORY
BY AGENCYTYPE
BY address1
BY CityStateZip
BY Inner
BY Engagement
BY JVP
WHERE PARENTAGENCYID EQ MISSING;
ON TABLE NOTOTAL
ON TABLE SAVE FILENAME
'compass/KFR.ftm'
END

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

WebFocus 7.6.4
SQL
HTML and Excel

Posts: 49 | Registered: June 06, 2008

Fernando

Guru

posted

Hide Post

Save files do not create master file and there nothing appears on the list. Try a hold file.

Fernando

Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03

Posts: 278 | Registered: October 10, 2006

Ignored post by Fernando posted

Show Post

<JG>

posted

Fernando is quite right You have to use HOLD.

However if you want to use it in a subsequent request then you need to hold both the data
and the master to a location on the APP PATH. lookup APPHOLD

susannah

Expert

posted

Hide Post

kf..
do you want to use this extract file now (in the current fex)? or later in a subsequent fex?
(a)if you want to use it now,
its quite sufficient to say
ON TABLE HOLD AS myfilename
END
-RUN
TABLE FILE myfilename
...and write your report.
(b) if you want to use it later,
you need to park it somewhere on your server.
Here we'll park in in the baseapp..

APP HOLD baseapp
TABLE FILE source
...
ON TABLE HOLD AS myfilename {FORMAT ALPHA}
END
...then later
APP PATH baseapp {or whatever you need}
FILEDEF MYFILENAME DISK baseapp/myfilename.ftm
TABLE FILE MYFILENAME
....
END