procedure CreateDBConnection()
begin
ADODataSet1.Close;
strSQL:='SELECT * FROM TB_Test WHERE FileID= '+sFileID ;
ADODataSet1.CommandText:=strSQL;
ADODataSet1.Open;
end;
procedure t2()
begin
CreateDBConnection;
ADODataSet1.Edit;
Memstream.Position:=0;
TBlobField(ADODataSet1.FieldByName('FileBody')).LoadFromStream(Memstream);
ADODataSet1.Post;
end;
procedure t2()
begin
CreateDBConnection;
ADODataSet1.Append;
ADODataSet1.Edit;
Memstream.Position:=0;
TBlobField(ADODataSet1.FieldByName('FileBody')).LoadFromStream(Memstream);
if (ADODataSet1.State =dsedit) or (ADODataSet1.State =dsinsert) then
begin
ADODataSet1.Post;