Page 1 of 1

Memo-Fields and ParamByName

Posted: Mon 04 Jul 2005 12:46
by Guest
Hello,

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,
Stefan

Posted: Tue 05 Jul 2005 12:15
by Ikar
Please specify a value of vQRY.SQL.Text.

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