保存的代码 S:=TMemorystream.Create(); try image1.Picture.Bitmap.SaveToStream(S); s.Position:=0; ADOQuery1.Close; ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add('INSERT INTO test(field,bz)'); ADOQuery1.SQL.Add('VALUES(:field,:bz)'); ADOQuery1.Parameters.Items[0].LoadFromStream(s,ftVarBytes); // ADOQuery1.Parameters.Items[1].Value:='1';读取的代码: ADOQuery1.SQL.Add('SELECT field FROM test '); ADOQuery1.SQL.Add('Where ID=:ID'); ADOQuery1.Parameters.Items[0].Value:='1'; try try ADOQuery1.Open; s:=TMemorystream.Create ; with ADOQuery1 do (FieldByName('field') as TBlobField).SaveToFile('c:\1.bmp');读取时候出错!!!
存储的时候用
TBlobField(AdoTable.FieldByName('field')).SaveToFile('c:\temp.bmp');
这样不会出现乱码
报错
S:=TMemorystream.Create();
try
image1.Picture.Bitmap.SaveToStream(S);
s.Position:=0;
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('INSERT INTO test(field,bz)');
ADOQuery1.SQL.Add('VALUES(:field,:bz)');
ADOQuery1.Parameters.Items[0].LoadFromStream(s,ftVarBytes); //
ADOQuery1.Parameters.Items[1].Value:='1';读取的代码: ADOQuery1.SQL.Add('SELECT field FROM test ');
ADOQuery1.SQL.Add('Where ID=:ID');
ADOQuery1.Parameters.Items[0].Value:='1';
try
try
ADOQuery1.Open;
s:=TMemorystream.Create ; with ADOQuery1 do
(FieldByName('field') as TBlobField).SaveToFile('c:\1.bmp');读取时候出错!!!