I have some fields on a form, let's say one Tedit and Tmemo fileds.
Edit1 has as text "Customer 1"
Memo1 has as text
"south street 1
Now I want to insert them into MySQL and I use the following statement:
query.SQL.text := 'insert into test (name, address) VALUES ("'+edit1.text + '","' + Memo1.Text + "'";
But I always get an error that the query was not successfull... getting the SQL string it shows:
'insert into test (name, address) VALUES ("Customer1",""south street1
It is like when the memo contains more than one line then getting the memo text will add quotes at the
beginning and at the end...
Any idea on how to solve this issue?