stored procedure save blob type field to file ?

osmantaskiran · Post by **osmantaskiran** » 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?

Falcon · Post by **Falcon** » 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;

osmantaskiran · Post by **osmantaskiran** » Mon 01 Mar 2010 14:15

thanks