Hi Alan,

I have changed the field to a text blob but the hard return is still not
being recognised. I use ibase_blob_echo($rec->FLDNM) to display the data.
What could I be doing wrong?

Mags

On Thu, Jun 28, 2012 at 8:04 PM, Alan J Davies <
Alan.Davies@...> wrote:

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

[Non-text portions of this message have been removed]