TMemo to TDBMemo Delphi 4

[BRADENSTOKE]

I have a Memo and want to copy it into a database TDBMemo.
FieldByName('NOTES').AsMemo := Memo1.Lines; doesn't work.
It doesnt like AsMemo.
Does anybody know the correct syntax ?

Frank.

 

[towerbase]

I'm assuming that you are using a TTable component called Test. Then the way to update your DBMemo (and write it to the database) is to code something like:

  Test.Edit;
  (DBMemo1.Field as TMemoField).Assign (Memo1.Lines);
  Test.Post;

The DBMemo1 should have the DataField and DataSource properties set appropriately.

Andrew

 

[SamC]

you can also use

FieldByName('NOTES').AsString := Memo1.Text;

Sam