Memo-Fields and ParamByName

Memo-Fields and ParamByName

Postby Guest » Mon 04 Jul 2005 12:46

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
Guest
 

Postby 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.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components