现在能写入数据库,但是读出来的时候总报错
var
stream :TMemoryStream;
begin
stream :=TMemoryStream.Create;
stream.Position :=0;
stream.WriteBuffer(ATime[0], Length(ATime));
ADOQuery1.SQL.Add('Insert Into PData (Data) values (:Data)');
ADOQuery1.Parameters.ParamByName('Data').LoadFromStream(stream, ftblob);
//TBlobField(ADOQuery1.Parameters.ParamByName('Data')).LoadFromStream(stream);
ADOQuery1.ExecSQL;
end
能正常写入数据库
但是读出来的时候总是报类型转换错误
var
stream :TMemoryStream;
begin
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('Select * From PData');
ADOQuery1.Open;
while not ADOQuery1.Eof do
begin
stream :=TMemoryStream.Create;
TBlobField(ADOQuery1.FieldByName('Data')).SaveToStream(stream);//此句执行报错
ADOQuery1.Next;
end;
end