[Lazarus] Loading an image to a mysql blob
John Landmesser
jmlandmesser at gmx.de
Thu Nov 1 11:17:33 CET 2018
Am 31.10.18 um 13:05 schrieb Terry A. Haimann via Lazarus:
> I tried loading an image into a Medium Blob. The image uploads and
> shows up on my form, but when I click post on my DbNavigator the
> program gives me an access violation.
>
> Here is the source code:
>
> procedure TPropertyForm.ImgButClick(Sender: TObject);
> Var
> MyImageFile, MyDir: String;
> begin
> MyImageFile := '/';
> if OpenDialog1.Execute then
> begin
> MyImageFile := OpenDialog1.Filename;
> end;
> DbPropImg.Picture.Jpeg.LoadFromFile(MyImageFile);
>
> End;
>
> Am I missing something I have to do? The blob should be large enough,
> they are supposed to be able to hold 16 Meg and the jpegs are running
> about 2 - 3 meg. I am running Mint 18.3, using Mysql 5.7.22 and using
> ZeosDBO.
>
> Terry Haimann
.. perhaps a Dataset.edit before
DbPropImg.Picture.Jpeg.LoadFromFile(MyImageFile);
DbPropImg.Picture.Jpeg.LoadFromFile(MyImageFile);
More information about the Lazarus
mailing list