Devart Forums

Posted: **Fri 26 Feb 2010 12:42**

hi; I m using Codegear 2010 and SDAC component on SQL Server 2008 I inserted my file to sql server table with stored proc.
I need to retrieve my blob file to local filesystem with stored proc How can I do it?
I can't find savetofile procedure in storedproc component in dynamically, please help me?

Posted: **Mon 01 Mar 2010 14:14**

To save BLOB field to file use the code like this

Code: Select all

var
  BlobField: TBlobField;
begin
  MSStoredProc.ExecProc;
  BlobField := MSStoredProc.FieldByName(ImageField) as TBlobField;
  BlobField.SaveToFile(Filename);
end;

Posted: **Mon 01 Mar 2010 14:15**

thanks

Devart Forums

stored procedure save blob type field to file ?

stored procedure save blob type field to file ?