Re: Multiple Memo fields to TRichEdit

Thanks both of you for suggestions.

I decided to create a calculated field that combines the memo fields
together, but I didn't succeed to make it work.
I tried to create Report field, which is calculated, type WideString, and
linked to dbrichedit and I made something like that:

AdoDataset2Report.AsWideString := ADODataset1Summary.AsWideString +
AdoDataset3Comment.AsWideString;

this will display in DBrichedit only a few lines from Summary field.
I tried also with ADODataset1Summary.AsVariant +
AdoDataset3Comment.AsVariant, with same result.

What is the solution to combine the memo fields? I didn't find anything on
Internet to help me...
(Please, bear a beginner questions!)

Thank you very much!


"Andrew" <abaylis_nos@xxxxxxxxxxx> wrote in message
news:45a82255$1@xxxxxxxxxxxxxxxxxxxxxxxxx
"Habib" <habibz@xxxxxxxxxxxxx> wrote in message
news:45a80181@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi,



I need to display multiple fragments of text stored in an Access Database
formatted memo fields in a single TRichEdit.

For example, I have ADODataset1 with Summary (Memo field), and ADODataset2
with Comment (Memo field) and I want to display in a RichEdit:

Summary

Comment

How can be done this?



Thanks in advance,

As the TDBRichEdit can only display from one field, you'll need to create a
calculated field that combines the two bits of text together and then get
the DBRichEdit to display it. As you are using ADO, a quick way would be to
modify the SQL statement, or you can create a persistent field in one of the
datasets and write an OnCalcFields handler.
HTH
Andrew


.

Relevant Pages

  • Re: Multiple Memo fields to TRichEdit
    ... I decided to create a calculated field that combines the memo fields ... I tried to create Report field, which is calculated, type WideString, and ... this will display in DBrichedit only a few lines from Summary field. ...
    (borland.public.delphi.database.ado)
  • Data corruption problem Access03
    ... I have a table with several memo fields that display the entered data ... queries on the table also display the returned data ... ) the first 255 characters are rendered correctly, ...
    (microsoft.public.access.modulesdaovba)
  • Re: losing part of string
    ... Truncation of Memo fields ... I concact a string field in the my report detail print event, and display ...
    (microsoft.public.access.reports)
  • Re: Memo fields dont display properly in VFP 9.0 runtime (sometimes)
    ... Almost all of these tables have memo fields, ... however I usually run it in VFP. ... :display properly. ... :line and they angle up toward the upper right corner of the screen at ...
    (microsoft.public.fox.programmer.exchange)
  • Memo fields dont display properly in VFP 9.0 runtime (sometimes)
    ... Almost all of these tables have memo fields, ... however I usually run it in VFP. ... display properly. ... line and they angle up toward the upper right corner of the screen at ...
    (microsoft.public.fox.programmer.exchange)