Problems with wordwrap
Posted in 1994
Topics: Stored Procedures & SPL
I am trying to use the "wordwrap" function in an ACE report to display a field defined as "text" in the table. I am having the following problems: 1. Get error -8121 (wordwrap right margin value out of range) even though I do not have the right margin parameter coded. The text field seems to think that the right margin limit on the report is 128, even though I have defined it as 166 in a right margin statement (creating a report that will be printed landscape on a laser printer using a small font). I discovered this by putting a right margin parameter in, and getting -8121 errors until I reduced the number to under 128. 2. After I create the report by moving the text field more to the middle of the report (columns 60 thru 120) to avoid problem #1, it works except now the fields after the wordwrap field are not placed in the proper column (even after using a column statement). I notice when editing the report file using vi that the line after the wordwrap line contains many spaces (ranging from 160 to 254 blanks). This high number of blanks causes the fields after the wordwrap field to be offset. Even if the wordwrap text field is put on a line by itself, the next line in the report contains this high number of blanks. 3. I tried to get around problems 1 and 2 by doing something like this: print column 1, char_field1, column 20, char_field2; print column 121, char_field3; print column 61, text_field wordwrap right margin 120 Believe it or not, I got the -8121 error, even though my right margin was less than 128, and much less than the right margin of the report. Has anyone experienced similar problems, and if so, any suggestions for getting around them? I would like to have the character fields and the text field on the same line of the report, but so far my only solution has been to put the text field on a separate line, and live with the extra blank line THANKS in ADVANCE! Tom Horner -- Thomas R. Horner @ AT&T, Alpharetta, GA Office: 404-750-5812 8am-5pm Eastern trh@cbnewsi.att.com or thorner@attmail.att.com