var l_Stream:TMemoryStream; begin l_Stream:=TMemoryStream.Create; RichEdit1.Lines.SaveToStream(l_Stream); dm1.dm.Query1.Edit; TBlobField(dm1.dm.Query1.FieldByName('Info')).LoadFromStream(l_Stream); dm1.dm.Query1.Post; end;
ADOQuery1.Close; ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add('insert into lcdcpk (Chartx) values(:Pic)'); ADOQuery1.Parameters.ParamByName('Pic').Assign(Image1.Picture.Bitmap); ADOQuery1.ExecSQL;
对于大量的这类记录,我担心其速度。关注ing
//保存 begin with ADOQuery1 do begin close; SQL.Text := 'select Image1 from t_1'; Open; TBlobFile(Fields[0]).LoadFromFile('xxxx.bmp'); Close; end; end;
l_Stream:TMemoryStream;
begin
l_Stream:=TMemoryStream.Create;
RichEdit1.Lines.SaveToStream(l_Stream);
dm1.dm.Query1.Edit;
TBlobField(dm1.dm.Query1.FieldByName('Info')).LoadFromStream(l_Stream);
dm1.dm.Query1.Post;
end;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('insert into lcdcpk (Chartx) values(:Pic)');
ADOQuery1.Parameters.ParamByName('Pic').Assign(Image1.Picture.Bitmap);
ADOQuery1.ExecSQL;
begin
with ADOQuery1 do
begin
close;
SQL.Text := 'select Image1 from t_1';
Open;
TBlobFile(Fields[0]).LoadFromFile('xxxx.bmp');
Close;
end;
end;