Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 5 of 5 total |
DBMemo save in DBisam-Table with Query |
Sat, Feb 4 2006 12:05 PM | Permanent 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 PM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Thomas
Looks ok to me Roy Lambert |
Sun, Feb 5 2006 11:08 AM | Permanent Link |
Thomas | Roy, i changed the dbmemo to a simple memo, now it is saving like i want
thanks for your help |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |