Focal Point
Printing TX50 fields

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

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
Leah
Is 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