Memo-Fields and ParamByName

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply

Memo-Fields and ParamByName

Post by Guest » Mon 04 Jul 2005 12:46


I have a problem with Memo-Fields in MySQL and ParamByName.

My Sourcecode is:
vQry.ParamByName('ADR_NOTE').AsString := memNote.Lines.Text;

After Executing the whole SQL-Statement, the Field ADR_NOTE is empty.
How can I solve this problem?

The problem is the same as Date-Fields.
Reading (SELECT) is no problem, but Updates and Inserts.

Best regards,

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 05 Jul 2005 12:15

Please specify a value of vQRY.SQL.Text.

Most probably, you set SQLInsert incorrectly. Usually it is not needed to set this property.

Post Reply