Like :
Code: Select all
WorkerQuery.SQL.Text :=
'INSERT INTO Activities (Duration, Text) VALUES (:Duration, :Text)';
WorkerQuery.ParamByName('Duration').AsInteger := 1;
WorkerQuery.ParamByName('Text').AsString := 'First line of text'+#13+'Second line of text';
WorkerQuery.ExecSQL;
if i use a TUniTable and a grid component to enter a multi line text, then work it as expected.
It seems that the #13 character will be removed before or while sending the script. If this is true, why?