July 01, 2004, 04:26 PM
<Cisco>Printing TX50 fields
Does anyone know if there are any known issues when doing this in webfocus 5.2?
No matter what way I print, I only ever get the first instance of a TX50? All other instances are blank.
Here is the code
TABLE FILE ISSUINFO
HEADING CENTER
"PSDB Reporting"
PRINT
UPDATEDETAILS ** Text file one
BY ISSUENUMBER NOPRINT PAGE-BREAK
ON ISSUENUMBER SUBHEAD
"Issue Number:
"
" < EXPR2 > " text file 2
ON ISSUENUMBER SUBFOOT
"Method of Implementation: "
END
In the above code, EXPR2 display ok, but Update Details only gives me the first row
Also if I just try a normal print
TABLE FILE ISSUDETL
""
END
or
TABLE FILE ISSUINFO
""
END
All I get the first instance in the database then a long list of blanks. Yet stranfely in my first example EXPR2 will print ok.
Does anyone know of any problems with TX50 printing? Or any techniques to print TXT50 fields?
Thanks!!
July 01, 2004, 05:18 PM
LeahIs this a join issue, you don't show one. If so are you expecting multiple instnces if so may need a join xxx to ALL xxx.
Or you may have a key issue in your join.
July 02, 2004, 09:17 AM
<Cisco>The first example is a join yes, but I'm pretty sure the join is correct.
The second two examples though
TABLE FILE ISSUDETL
" < USERDETAILS > "
END
or
TABLE FILE ISSUINFO
" < EXPR2 > "
END
don't use a join at all and I still get the same problem. They are just simple prints from an MFD.
TABLE FILE ISSUINFO
PRINT EXPR2
END
TABLE FILE ISSUDETL
PRINT USERDETAILS
END
Give the same problem