whats new ¦  programming tips ¦  indy articles ¦  intraweb articles ¦  informations ¦  links ¦  interviews
 misc ¦  tutorials ¦  Add&Win Game

Tips (1541)

Database (90)
Files (137)
Forms (107)
Graphic (114)
IDE (21)
Indy (5)
Internet / LAN (130)
IntraWeb (0)
Math (76)
Misc (126)
Multimedia (45)
Objects/
ActiveX (51)

OpenTools API (3)
Printing (35)
Strings (83)
System (266)
VCL (242)

Top15

Tips sort by
component


Search Tip

Add new Tip

Add&Win Game

Advertising

15 Visitors Online


 
...save a file to a TBlobStream and read it back?
Autor: Mike Shkolnik
Homepage: http://www.scalabium.com
[ Print tip ]  

Tip Rating (53):  
     


{
  If you develop a database related software, then a very popular task is to
  save some files (documents/images/reports/etc) in some BLOB field of table
  and use these saved data later.
  In this tip I want to show how this task could be solved.
}

// To save a file to BLOB:
procedure TForm1.Button1Click(Sender: TObject);
var
  
blob: TBlobStream;
begin
  
blob := yourDataset.CreateBlobStream(yourDataset.FieldByName('YOUR_BLOB'), bmWrite);
  try
    
blob.Seek(0, soFromBeginning);
    fs := TFileStream.Create('c:\your_name.doc', fmOpenRead or
      
fmShareDenyWrite);
    try
      
blob.CopyFrom(fs, fs.Size)
    finally
      
fs.Free
    end;
  finally
    
blob.Free
  end;
end;
  // To load from BLOB:

procedure TForm1.Button1Click(Sender: TObject);
var
  
blob: TBlobStream;
begin
  
blob := yourDataset.CreateBlobStream(yourDataset.FieldByName('YOUR_BLOB'), bmRead);
  try
    
blob.Seek(0, soFromBeginning);

    with TFileStream.Create('c:\your_name.doc', fmCreate) do
      try
        
CopyFrom(blob, blob.Size)
      finally
        
Free
      end;
  finally
    
blob.Free
  end;
end;

{
  Using this code you can work with any database engine (BDE/ADO/DAO/ODBC/etc)
  and any file format (document of MS Word, spreadsheet of MS Excel, bitmap or
  jpeg pictures, wav-files etc)
}

 

Rate this tip:

poor
very good


Copyright © by SwissDelphiCenter.ch
All trademarks are the sole property of their respective owners