Oracle数据库图片存取问题

saimaya 2003-02-21 11:35:38

我用的是Oracle9i+ADOQuery
请问怎样对数据库中的Blob子段进行数据存取呢

...全文

38 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

saimaya 2003-02-24

打赏
举报

有表TestPhoto(Oracle9i中),其中字段Photo为Blob类型，我用ADOQuery执行"Select Photo from TestPhoto"为什么出错？

saimaya 2003-02-23

打赏
举报

sysu 2003-02-22

打赏
举报

var
fs: TFileStream;
bs: TBlobStream;

// 写入
with ADOQuery1 do begin
Append;
fs := TFileStream.Create('image1.jpg', fmOpenRead);
bs := TBlobStream(CreateBlobStream(FieldByName('Pic'), bmWrite));
bs.CopyFrom(fs, 0);
bs.Free;
fs.Free;
Post;
end;

// 读取
with ADOQuery1 do begin
fs := TFileStream.Create('image1.jpg', fmOpenWrite or fmCreate);
bs := TBlobStream(CreateBlobStream(FieldByName('Pic'), bmRead));
fs.CopyFrom(bs, 0);
bs.Free;
fs.Free;
end;

saimaya 2003-02-22