Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Firedac SQLITE insert image into blob.


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 4 - Last Post: Nov 27, 2015 10:17 PM Last Post By: kerry manam
Stev Warby

Posts: 50
Registered: 10/19/14
Firedac SQLITE insert image into blob.  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 16, 2014 4:30 PM
I have a SQLITE database with field image1 as BLOB.
I need to be able to do the following on windows & Mac.

1. Drag and drop an image file (from explorer / finder) onto a image component or directly into a grid.
2. Insert that image into the Blob field.
3. Show the Image in a grid ( I presume it will just show if the grid is connected to the database).
4. On double click on a cell show that image in a 'popup' viewer.

Thanks

SW
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Firedac SQLITE insert image into blob.  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 16, 2014 9:26 PM   in response to: Stev Warby in response to: Stev Warby
So, what is your FireDAC question ?

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Ste War

Posts: 31
Registered: 1/9/15
Re: Firedac SQLITE insert image into blob.  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 17, 2014 8:53 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Dmitry Arefiev wrote:
So, what is your FireDAC question ?

--
With best regards,
Dmitry Arefiev / FireDAC Architect

I am using FireDac / SQLITE and need to get an image into a Blob field.

This is the Database / FireDac forum ?

If you mean I am in the wrong forum or have not asked the question correctly please feel free to answer in a polite manner. There is no charge for manners.....
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Firedac SQLITE insert image into blob.  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 17, 2014 10:31 AM   in response to: Ste War in response to: Ste War
If you mean I am in the wrong forum or have not asked the question correctly please feel free to answer in a polite manner.

Ok, I will rephrase. What you did and where you are failing with FireDAC ?

I am using FireDac / SQLITE and need to get an image into a Blob field.

For example:
FDQuery1.Append;
....
(FDQuery1.Fields[...] as TBlobField).LoadFromFile('c:\aaa.jpg'); 
FDQuery1.Post;


--
With best regards,
Dmitry Arefiev / FireDAC Architect
kerry manam

Posts: 1
Registered: 12/28/15
Re: Firedac SQLITE insert image into blob.  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 27, 2015 10:16 PM   in response to: Stev Warby in response to: Stev Warby
More about..... [Insert Image to database|http://net-informations.com/csprj/dataset/cs-insert-image.htm]

Kerry

Stev Warby wrote:
I have a SQLITE database with field image1 as BLOB.
I need to be able to do the following on windows & Mac.

1. Drag and drop an image file (from explorer / finder) onto a image component or directly into a grid.
2. Insert that image into the Blob field.
3. Show the Image in a grid ( I presume it will just show if the grid is connected to the database).
4. On double click on a cell show that image in a 'popup' viewer.

Thanks

SW

Edited by: kerry manam on Nov 27, 2015 10:16 PM
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02