• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1172
  • Last Modified:

Memo.Lines -> Table1.FieldByName('MEMO').As???

Using Delphi 3, and given:

1 TMemo
1 TTable

and where the Table1 contains a MEMO record (Paradox and of Blob type) how do I get the contents/lines of a TMemo component into the 'MEMO' memo field for a record?

This obviously does not work:

Table1.FieldByName('MEMO').AsMemo := Memo1.Lines;

What would work?
0
Monroe406
Asked:
Monroe406
  • 2
1 Solution
 
simonetCommented:

Try this:

Table1.FieldbyName('MEMO').asstring := Memo1.lines.text;

Yours,

Alex
Athena's Place: http://www.bhnet.com.br/~simonet

0
 
Monroe406Author Commented:
Thanks...

However, next/new question...

How does one VIEW the contents of the Memo/blob field once it is in the Table/Record?

A little sheet of paper icon appears in the table's field cell currently.  How do I view that?
0
 
simonetCommented:

You can try double-clicking it, but I don't think that's gonna work (it works in Database Explorer).

You need a TDBMemo in order to view the contents of a memo field, or the kind of DB component that suits the kind of data in the blob field (like OLE objects, graphics, audio, AVIs, etc).

Yours,

Alex
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now