procedure TForm7.Button1Click(Sender: TObject); //保存.bmp格式的文件到更新包里。 var str:Tmemorystream; begin str:=Tmemorystream.Create; str.LoadFromFile('d:\cai.jpg');//OpenDialog1.FileName 也可以 str.Position:=0; adoquery2.Append; //图片 Tblobfield(adoquery2.FieldByName('image')).loadfromstream(str); try adoquery2.Post; finally str.Free; end; end;
procedure TForm5.Button1Click(Sender: TObject); var str:Tmemorystream; //修改图片POS_mgxid begin IF not ADOQUERY2.IsEmpty Then //如果更新编号不为空 Begin str:=Tmemorystream.Create; //读取远程更新包的数据到程序执行的目录下面 str.Position:=0; Tblobfield(adoquery2.FieldByName('image')).savetostream(str); str.SaveToFile(ExtractFilePath(Application.ExeName)+'image\cai.jpg'); str.Free; end;
TBlobfield(table1.fieldbyname('iamge').savetofile(savedialog1.fileName);
image1.picture.loadfromfile(savedialog1.filename);
table1.Edit;
table1image.Assign(image1.picture);
table1.Post;
table1.close;
var str:Tmemorystream;
begin
str:=Tmemorystream.Create;
str.LoadFromFile('d:\cai.jpg');//OpenDialog1.FileName 也可以
str.Position:=0; adoquery2.Append; //图片
Tblobfield(adoquery2.FieldByName('image')).loadfromstream(str);
try
adoquery2.Post;
finally
str.Free;
end;
end;
var str:Tmemorystream; //修改图片POS_mgxid
begin
IF not ADOQUERY2.IsEmpty Then //如果更新编号不为空
Begin
str:=Tmemorystream.Create; //读取远程更新包的数据到程序执行的目录下面
str.Position:=0;
Tblobfield(adoquery2.FieldByName('image')).savetostream(str);
str.SaveToFile(ExtractFilePath(Application.ExeName)+'image\cai.jpg');
str.Free;
end;
打开BDE ADMINSTRATOR,选择你的ALIAS,然后将BLOB SIZE改为1024(1M),还有BLOBS TO CACHE也改的大一些。