DEFINE FILE CAR CD1/A3='500'; CD2/A4='AKCO'; COUNTRY/A2='NL'; AMOUNT1/D11.2c=ABS(SALES); AMOUNT/A11=FTOA(AMOUNT1, '(D11.2c)', 'A11'); STRING/A20=CD1|CD2|AMOUNT|COUNTRY; END TABLE FILE CAR PRINT STRING BY COUNTRY NOPRINT END
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
DEFINE FILE CAR CD1/A3='500'; CD2/A4='AKCO'; COUNTRY/A2='NL'; AMOUNT1/D11.2C=ABS(SALES); AMOUNT/A11=FTOA(AMOUNT1, '(D11.2c)', 'A11'); STRING/A20=CD1|CD2|AMOUNT|COUNTRY; END TABLE FILE CAR PRINT STRING BY COUNTRY NOPRINT ON TABLE HOLD FORMAT ALPHA END -RUN -HTMLFORM BEGIN <html> <pre> !IBI.FIL.HOLD; </pre> </html> -HTMLFORM END
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
TABLE FILE CAR PRINT COUNTRY CAR MODEL SALES/I9C RETAIL_COST/D10.2M ON TABLE SAVE AS TMP_TEXT FORMAT WP END -RUN FILEDEF TMP_TEXT DISK tmp_text.wp (LRECL 132 RECFM V EX -LINES 5 EDAPUT MASTER,TMP_TEXT,CV,FILE FILENAME=TMP_TEXT, SUFFIX=FIX,$ SEGNAME=TMP_TEXT, $ FIELD=PRNTCTL ,ALIAS= ,A2 ,A2 ,$ FIELD=ROW ,ALIAS= ,A130 ,A130 ,$ -RUN TABLE FILE TMP_TEXT PRINT ROW ON TABLE SET SHOWBLANKS ON ON TABLE SET STYLE * FONT=COURIER NEW, $ ENDSTYLE END
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! |
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
OUT1/I1 = PUTDDREC('PUTDD1',6, STRING, 20, OUT1);