Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread DBMemo save in DBisam-Table with Query
Sat, Feb 4 2006 12:05 PMPermanent Link

Thomas
i want to save a text in a DBMemo with a DbisamSQL-Query. The table have the name artplan,
the fielname is info from DataType memo.
when i save, the memo is empty, the data-type letters change from MEMO to Memo (checking
with dbsys)

the code in my delphi-projecti is:

procedure Toutputsewing.Button4Click(Sender: TObject);
begin
dbisamquery3.SQL.Clear;
dbisamquery3.SQL.Add('update artplan set infos = '+quotedstr(dbmemo1.Text)+' where
artigo='+quotedstr(trim(combobox1.Text)));
dbisamquery3.ExecSQL;
combobox1.Text := ' ';
end;

what is the problem?



Attachments: artplan_leer.jpg
Sat, Feb 4 2006 1:05 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Thomas


I think its the embedded CRLFs in the memo - you'll need to use a parameter.

Roy Lambert
Sat, Feb 4 2006 7:50 PMPermanent Link

Thomas
Roy Lambert <roy.lambert@skynet.co.uk> wrote:

Thomas


I think its the embedded CRLFs in the memo - you'll need to use a parameter.

Roy Lambert

Roy, thanks for your help. i have to confess, i'm really beginner in programming and made
a course in delphi with dbisam-db, and i try to go on.
with another help from delphi-forum i got a help and i think, that is what you mean, with
parameter (?):

procedure Toutputsewing.Button4Click(Sender: TObject);
begin
dbisamquery3.SQL.Text:='update artplan set infos =:infos where artigo=:artigo';
dbisamquery3.ParamByName('infos').AsString:=dbmemo1.Text;
dbisamquery3.ParamByName('artigo').AsString:=combobox1.Text;
dbisamquery3.ExecSQL;
end;

it was also recommended not to use clear and add in query.

so its compiling well in delphi, also seams to save, but the same problem, the text is not
saved...
when i look on the memo in dbsys, the memo is empty and the datatype letters changed from
MEMO to Memo...??

who can help me???



Attachments: artplan_leer.jpg
Sun, Feb 5 2006 4:29 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Thomas


Looks ok to me

Roy Lambert
Sun, Feb 5 2006 11:08 AMPermanent Link

Thomas
Roy, i changed the dbmemo to a simple memo, now it is saving like i want
thanks for your help




Image