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 procedureThis 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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.