1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Donation with Paypal!!!

    Go to your paypal account and send directly donation to [email protected]

    1 month - 10 $ - Standart VIP

    6 months - 20 $- Standart VIP

    1 year - 30 $- Standart VIP

    2 years - 50 $- Standart VIP

    Gold member for life - 150 $- Standart VIP

    High Vip (Standart VIP include) group please send PM or email to [email protected] for info

    After Donation please send email to [email protected]

  3. Donation Ways 2020


    Paysend
  4. Telegram
Dismiss Notice

Donation with Paypal!!!

Go to your paypal account and send directly donation to [email protected]

1 month - 10 $ - Standart VIP

6 months - 20 $- Standart VIP

1 year - 30 $- Standart VIP

2 years - 50 $- Standart VIP

Gold member for life - 150 $- Standart VIP

High Vip (Standart VIP include) group please send PM or email to [email protected] for info

After Donation please send email to [email protected]

Dismiss Notice
For open hidden message no need write thanks, thank etc. Enough is click to like button on right side of thread.

Read And Write A Blob Field Using FireDAC

Discussion in 'Delphi Android And IOS' started by AdminDF, Feb 28, 2014.

  1. AdminDF
    Online

    AdminDFAdminDF is a Verified Member Delphifan Staff Member DF Staff

    If you’re using the FireDAC components that comes with Delphi XE5 Firemonkey and you want to save a bitmap or some other type of data to a blog field on your embedded database (either SQLite, IBlite, or Interbase To Go) it can be a bit tricky. For saving it is pretty standard fair with the TFDDataSet.LoadFromStream() which will load a stream like a memory stream into a field. The important piece to reading the blob back out is is the TFDDataSet.CreateBlobStream() function. I have included two functions below which show an example of how to read and write a string and bitmap data from an image using a FireDAC TFDQuery component. This method of reading and writing a blog works on Android and IOS as well as Windows and OSX.


    Code:
    procedure SaveToFireDACBlob;
    var
    MemStream: TMemoryStream;
    begin
    FireDAC.Connected := True;
    MemStream := TMemoryStream.Create;
    try
    Image1.Bitmap.SaveToStream(MemStream);
    MemStream.Seek(0,0);
    FDQueryInsert.ParamByName(‘Media’).LoadFromStream(MemStream,ftBlob);
    FDQueryInsert.ParamByName(‘MType’).AsString := ’0′;
    FDQueryInsert.ExecSQL();
    except
    on e: Exception do
    begin
    //ShowMessage(e.Message);
    end;
    end;
    MemStream.Free;
    FireDAC.Connected := False;
    end;
    
    procedure LoadFromFireDACBlob;
    var
    BlobStream: TStream;
    begin
    FireDAC.Connected := True;
    try
    FDQuerySelect.Open;
    FDQuerySelect.First;
    while(not FDQuerySelect.EOF)do begin
    // access a stream from a blog like this
    BlobStream := FDQuerySelect.CreateBlobStream(FDQuerySelect.FieldByName(‘Media’),TBlobStreamMode.bmRead);
    // access a string from a field like this
    if (FDQuerySelect.FieldByName(‘MType’).AsString=’0′) then
    begin
    // load your blob stream data into a control
    ImageViewer.Bitmap.LoadFromStream(BlobStream);
    end;
    BlobStream.Free;
    FDQuerySelect.Next;
    end;
    except
    on e: Exception do
    begin
    //ShowMessage(e.Message);
    end;
    end;
    FireDAC.Connected := False;
    end;
    

    More in this site
     

Share This Page