Updating a memo field

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ashlar64
Posts: 75
Joined: Thu 04 May 2006 18:56

Updating a memo field

Post by ashlar64 » Tue 16 May 2006 14:49

Hello,

I am trying to update a memo field in a table. But when I do the statement below the memo field is given a True value. How can I get the text I want in it?




MyTable_Site_Upgrades->FieldValues["Notes"]= Memo_Upgrade_Notes->Lines;


Thanks!

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 17 May 2006 09:06

Try using something like

Code: Select all

MyQuery->FieldByName("c_text")->Assign(Memo->Lines);
to load data from TMemo into TMemoField field and

Code: Select all

Memo->Lines->Assign(MyQuery->FieldByName("c_text"));
to load data from TMemoField into TMemo.
You can also use TDBMemo component that provides automatic editing of TMemoField.

Post Reply