Solved

TBlob Filed ...

Posted on 2004-07-30
3
3,107 Views
Last Modified: 2008-02-01
Hi,

I am using MySQL database and in one table I have created 3 BLOB field type where I am storing JPG Images.

I able to store Images.

Using Following code :

ImageTable.Append;
ImageTable.FieldByName('ScopyNo').asInteger := 1;
TBlobField(ImageTable.FieldByName('Image')).LoadFromFile('C:\'Crop.jpg');
TBlobField(ImageTable.FieldByName('FinalImage')).LoadFromFile('C:\Crop.jpg');
 ImageTable.Post;

But Now I want to EDIT existing BLOB field value, So I using Following code:

ImageTable.Edit;
ImageTable.FieldByName('ScopyNo').asInteger := 2;
TBlobField(ImageTable.FieldByName('Image')).LoadFromFile('C:\'Crop.jpg');
TBlobField(ImageTable.FieldByName('FinalImage')).LoadFromFile('C:\Crop.jpg');
 ImageTable.Post;

But both BLOB fiels unable to store new image.

Please guide me what is the problem or is there other way to make changes in the field value.

Thanks & Regards,

0
Comment
Question by:smartvanl5
3 Comments
 
LVL 27

Accepted Solution

by:
kretzschmar earned 50 total points
ID: 11701088
?? usual it should work this way

two possibilities:
- no commit
- you store the same picture again
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question