为何我的blob数据总是存不进去,错误返回值为-1?
为何我的blob数据总是存不进去,错误返回值为-1?
integer fh,ret
blob tmp_php,lb_php
string filename,named,ls_bh,defext="bmp"
string filter="图形文件(*.bmp),*.bmp"
long fsize
int num,i //从磁盘选择文件
ret=getfileopenname("选择文件",filename,named,defext,filter)
messagebox("kk","succed!"+string(ret))
if ret=1 then
fsize=filelength(filename)
fh=fileopen(filename,streammode!)
messagebox("fh","succed!"+string(fsize)+" "+string(fh))
num=int(fsize/32765)+1
if fh<>-1 then
for i=1 to num
fileread(fh,tmp_php)
lb_php=lb_php+tmp_php
next
fileclose(fh)
end if
end if
ulong mid
mid=dw_1.getrow()
UPDATEBLOB books
SET book_cover = :lb_php
WHERE id=:mid;
messagebox("code",string(sqlca.sqlcode))
if sqlca.sqlcode<>0 then
messagebox("提示信息","保存失败!",exclamation!,OK!,1)
rollback using sqlca;
else
commit using sqlca;
end if
为何我的blob数据总是存不进去,错误返回值为-1?