首先谢谢:fengqingwanzhong(风情万种) , 用你的方法是可以保存和读取,但读出来的内容不是我当初存进去的内容.为何读出来后总是同一个字符呢?就是{ 这个字符呢? 我把程序也贴出来: procedure TForm1.Button1Click(Sender: TObject); //保存到数据库 var l_Stream: TStringStream; begin l_Stream := TStringStream.Create(RichEdit1.Text); RichEdit1.Lines.SaveToStream(l_Stream); //此程序为修改记录 with DataModule2.ADOQuery1 do begin close; sql.clear; sql.add('insert into doctable (doc)'); sql.add('values (:vn)'); Parameters.ParamByName('vn').Value:=l_Stream.DataString; //客户号 prepared; execsql; end;end;procedure TForm1.Button2Click(Sender: TObject); //从数据库加载 var l_Stream: TStringStream; begin with DataModule2.ADOQuery1 do begin close; sql.clear; sql.add('select * from doctable '); open; l_Stream := TStringStream.Create(FieldByName('doc').asstring); end; richedit1.Lines.LoadFromStream(l_Stream); end;
Get: Memo.Text := FieldByName('FieldName').AsString;
Set: FieldByName('FieldName').Value := Memo.Text ;
如何实现。还有,我是用RICHEDIT控件的,不用MEMO控件。
RichEdit.PlainText:=False;
然后把
RichEdit.Text的内容当做字符串保存到数据库,或者用Blob字段保存也可以!
var
l_Stream: TStringStream;
begin
l_Stream := TStringStream.Create(FieldByName('fieldname').asstring);
richedit1.Lines.LoadFromStream(l_Stream);
end;
//保存到数据库
var l_Stream: TStringStream;
begin
l_Stream := TStringStream.Create('');
Editor.Lines.SaveToStream(l_Stream);
FieldByName('fieldname').value := l_Stream.DataString;end;
用你的方法是可以保存和读取,但读出来的内容不是我当初存进去的内容.为何读出来后总是同一个字符呢?就是{ 这个字符呢?
我把程序也贴出来:
procedure TForm1.Button1Click(Sender: TObject);
//保存到数据库
var l_Stream: TStringStream;
begin
l_Stream := TStringStream.Create(RichEdit1.Text);
RichEdit1.Lines.SaveToStream(l_Stream);
//此程序为修改记录
with DataModule2.ADOQuery1 do
begin
close;
sql.clear;
sql.add('insert into doctable (doc)');
sql.add('values (:vn)');
Parameters.ParamByName('vn').Value:=l_Stream.DataString; //客户号
prepared;
execsql;
end;end;procedure TForm1.Button2Click(Sender: TObject);
//从数据库加载
var
l_Stream: TStringStream;
begin with DataModule2.ADOQuery1 do
begin
close;
sql.clear;
sql.add('select * from doctable ');
open;
l_Stream := TStringStream.Create(FieldByName('doc').asstring);
end; richedit1.Lines.LoadFromStream(l_Stream);
end;