Thanks for your comments. I do not understand how this block code is just storeing the path.
I thought when you insert a picture in a blob field of a sqlite database it stored the image .
Is there some tutorial i can read to help me understand how this blck code works.
I use pascal to retrieve the image from the blob field like this.
procedure TAccessCameraAppForm.SpeedButton2Click(Sender: TObject);
var
BlobStream: TStream;
begin
AccessCameraAppForm.viewimgquery.ParamByName('_PicId').AsInteger :=
AccessCameraAppForm.FDQuery1.FieldByName('ID').AsInteger;
AccessCameraAppForm.viewimgquery.Open;
AccessCameraAppForm.viewimgquery.First;
while (not AccessCameraAppForm.viewimgquery.EOF) do
begin
// access a stream from a blob like this
BlobStream := AccessCameraAppForm.viewimgquery.CreateBlobStream
(AccessCameraAppForm.viewimgquery.FieldByName('pictures'),
TBlobStreamMode.bmRead);
try
AccessCameraAppForm.imgCameraImage.Bitmap.LoadFromStream
(BlobStream);
// itm := Form4.ListView1.items.Add();
finally
BlobStream.Free;
end;
AccessCameraAppForm.viewimgquery.Next;
end;
end;
I need some information on how to store the image in the blobfield and retrieve it.
If this blck code doesn't store the image in the blobfield and just the path I need some tutorial or example to help me understand.
Thanks for the help.