Re: Wordwrap on forms

Path: emory!europa.asd.contel.com!darwin.sura.net!wupost!zaphod.mps.ohio-state.edu!uakari.primate.wisc.edu!ames!apple!voder!pyramid!infmx!dranney From: dranney@informix.com (David Ranney) Newsgroups: comp.databases.informix Message-ID: <1992Feb19.212010.8732@informix.com> Date: 19 Feb 92 21:20:10 GMT References: <1992Feb18.210321.4410@cbnews.cb.att.com> Sender: news@informix.com (Usenet News) Organization: Informix Software, Inc. In article <1992Feb18.210321.4410@cbnews.cb.att.com> mvctm@cbnews.cb.att.com (carl.t.mosley) writes: >I am using SQL 4.10. > >I have a char(80) column in a table which is represented on a form with >two 40 character fields using the wordwrap attribute: > > [This is my sample of the eighty ] > [character field with word wrap. ] > >When I select this column via a report, I get: > > This is my sample of the eighty character field with word wrap. > >I don't want the database to store these extra spaces created by the word >wrapping on the form. Reports look real ugly when printing out like this. > >Any way around this? Yes and no. You can't really get around the storage of the spaces since you're entering data like this: [This is my sample of the eighty ][character field with word wrap. ] and shoving it into the same column. It's just doing what you're telling it to. The "yes" part of the answer is more encouraging. Since your form splits up the 80 character column the same way for every user, you can take advantage of that in your report. Let's say you do the following in your form: f000 = tabname.col1[1,40]; f001 = tabname.col1[41,80]; In your report you could print it out the same way: ON EVERY ROW PRINT col1[1,40] CLIPPED PRINT col1[41,80] CLIPPED This will make the report look just the way the user typed it in.