换一种方法试一试:
string m_id
string filename
prepare sqlsa
from "update blobtest SET photo = xp_read_file(?) WHERE no = ? ";
execute sqlsa using :filename,:m_id;
----------------
注意,没有blob
换一种方法试一试:
string m_id
string filename
prepare sqlsa
from "updateblob blobtest SET photo = xp_read_file(?) WHERE no = ? ";
execute sqlsa using :filename,:m_id;
string m_name,m_id
prepare sqlsa
from "update blobtest SET name = ? WHERE no = ? ";
execute sqlsa using :m_name,:m_id;
执行成功了,可在用如下语句更新blob字段失败了,凡给看看
string m_id
blob m_photo
prepare sqlsa
from "updateblob blobtest SET photo = ? WHERE no = ? ";
execute sqlsa using :m_photo,:m_id;谢谢
谢谢,刚试了,提不出blob变量:语法如下
Prepare sqlsa from "updateblob "+ls_table+"set "+ls_column1+"=? where "+ls_column2+"="+string(li_id);
Execute sqlsa using :lb_tot_b;
麻烦你再给看一下。