Focal Point
[CLOSED]-WRITE an END to the file

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

August 31, 2010, 11:45 PM
Landerman
[CLOSED]-WRITE an END to the file
Hi,ALL
I want to write a dbafile.

the fex is bellow
FILEDEF MYCAR DISK mycar/mytest.mas
-RUN
-WRITE MYCAR
-WRITE MYCAR FILENAME=MYTEST,$
-WRITE MYCAR SEGNAME=mmmmm,$
-WRITE MYCAR FIELDNAME=fffff,$
-WRITE MYCAR END

FILEDEF MYCAR DISK mycar/mytest.mas (APPEND
-RUN
TABLE FILE CAR
ON TABLE HOLD AS MYCAR
PRINT
COMPUTE AA/A200 = 'USER ='||CAR||',ACCESS=R, RESTRICT=VALUE_WHERE, NAME=SYSTEM, VALUE=CAR EQ '''||CAR||''',$'; AS ''
ON TABLE SAVE AS MYCAR FORMAT TAB

END
-RUN


BUT when the fex run to END the procedure ended.
the result :

FILENAME=MYTEST,$
SEGNAME=mmmmm,$
FIELDNAME=fffff,$
END


so the table file procedure does not run.

question:
can anybody modify the -WRITE MYCAR END to write "END" to the file and not end the procedure

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


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
August 31, 2010, 11:59 PM
Waz
Works for me on 7.6.9, Win XP.

Could be an issue with 7.7.01

Do you have an earlier verion to try it on ?


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!

September 01, 2010, 02:01 AM
Dan Satchell
Did you try removing this unnecessary line of code?
ON TABLE HOLD AS MYCAR



WebFOCUS 7.7.05
September 01, 2010, 02:54 AM
Landerman
Thanks Waz and Dan
I have resolved this problem


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
September 01, 2010, 05:31 PM
Waz
How did you solve the problem ?

It may help others in the future.


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!

September 01, 2010, 09:43 PM
Landerman
here is my fex:

FILEDEF MYCAR DISK C:\ibi\apps\mycar\mytest.mas
-RUN
-WRITE MYCAR
-WRITE MYCAR FILENAME=MYTEST,$
-WRITE MYCAR SEGNAME=mmmmm,$
-WRITE MYCAR FIELDNAME=fffff,$
-WRITE MYCAR END

FILEDEF MYCAR DISK C:\ibi\apps\mycar\mytest.mas (APPEND
-RUN
TABLE FILE CAR
PRINT
COMPUTE AA/A200 = 'USER ='||CAR||',ACCESS=R, RESTRICT=VALUE_WHERE, NAME=SYSTEM, VALUE=CAR EQ '''||CAR||''',$'; AS ''
ON TABLE SAVE AS MYCAR FORMAT TAB

END
-RUN


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
September 01, 2010, 09:56 PM
Waz
So you changed your FILEDEF to an absolute location.


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!

September 01, 2010, 10:01 PM
Landerman
yes

thanks Waz.


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
September 01, 2010, 10:11 PM
Waz
Do you mind updating the title to [SOLVED] -WRITE an END to the file.

This can be done by clicking on the Edit from the first post.


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!