我用下面方法更新image,就说TEXT与IMAGE类型不兼容,而下面方法对于MEMO就没有问题.
procedure TForm1.Button1Click(Sender: TObject);
var
st: TStringStream;
begin
st := tstringstream.create('');
Dbimage1.Picture.Bitmap.SaveToStream(st);
CLientdataset1.CommandText:='insert into 学生资料表(学号,班级代号,照片) values(''1'',''610002'',:pic)';
CLientdataset1.Params[0].AsBlob:=st.DataString;
CLientdataset1.Execute;
end;
procedure TForm1.Button1Click(Sender: TObject);
var
st: TStringStream;
begin
st := tstringstream.create('');
Dbimage1.Picture.Bitmap.SaveToStream(st);
CLientdataset1.CommandText:='insert into 学生资料表(学号,班级代号,照片) values(''1'',''610002'',:pic)';
CLientdataset1.Params[0].AsBlob:=st.DataString;
CLientdataset1.Execute;
end;
CLientdataset1.Params[0].AsBlob:=st.DataString;
只能这样:CLientdataset1.FieldByName('BLOB').LoadFormFile(...);