If you want the easy way, then change the field type to a text blob, and output it as is. Works perfectly.
The hard way is the way you have it now. To get the data you ideally create a select stored procedure and you then need to : find each instance of a hard return (ascii32 ?) say HR1 copy the data from the start of the field to HR1 -1 then find hard return 2 say HR2 copy the data from position HR1+1 to this HR2 -1 and so on... You can do it in a loop. I'm sure others already have SPs that do this, but I take the easy route. HTH Alan Alan J Davies Aldis On 28/06/2012 17:42, Mags Phangisa wrote: > I have a field that takes 1000 characters. When the data is captured it is > in paragraphs but when it is displayed in a report it comes up as a single > (big) paragraph. > > Is there a way to pick up the return key so that I can display the data in > the same way it was captured? > > Mags > > [Non-text portions of this message have been removed] > > ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
