Retrieving images from database in delphi

Question

I want to store and retrieve images from sql database in Delphi XE.

My code:

TBlobField(query.FieldByName('image')).SaveToStream(MStream);    
Image1.Picture.Graphic.LoadFromStream(MStream);

What have you done ? What is the exact problem you're having ? Do you have some error message ? Can you show us the relevant portion of code ? — Pascal MARTIN, Mar 30 '11 at 11:14
David, banita doesn't saw your link. his only concern is about that code. — RBA, Mar 30 '11 at 12:03
@Radu Indeed. I just can't find enough motivation to answer. — David Heffernan, Mar 30 '11 at 12:08
It seems that this question is too hard for you, me, Cosmin, and others... — RBA, Mar 30 '11 at 12:10
@David, good point in your last two comments. I'll take care of the answer I just posted to a different question. It was probably wrong anyway. :) — Ken White, Mar 30 '11 at 12:45
Nice balance, -4 at question and all comments except OP's are voted as great :) @banita - isn't that a reason to amend yourself ? — , Mar 30 '11 at 14:56

score 2 · Answer 1 · edited Apr 01 '11 at 00:55

2

Don't forget to set the stream position to 0 between saving from the database and reading from the image.

edited Apr 01 '11 at 00:55

Rafe Kettler

answered Mar 31 '11 at 06:04

Birger

1

You should have read the comments to the original question before answering. There's a point being made. – Ken White Mar 31 '11 at 15:53
5

There is no point to not answering. Its not a game about collecting points, its about helping out when you can. – Gregor Brandt Apr 01 '11 at 05:19
1

@Gregor: not signing which answer solved the problem, the site looses parts of its utility - and you help less people. Some times, the most voted was not the selected - because the OP solved the problem with that answer or just the most voted appeared AFTER the selecion of accepted answer. – Fabricio Araujo Apr 01 '11 at 17:57
Maybe none of the answers solved his problems? – Gregor Brandt Apr 01 '11 at 21:15
1

@Gregor: So the OP has posted 13 questions and received answers that solved his problem only once? Then why didn't the OP post follow-up questions about the same topic? It's a matter of taking advantage of people and not having the courtesy to work with the community. The point is that this site was set up to work a certain way, and if you're willing to use it you should be willing to support it as designed. – Ken White Apr 01 '11 at 21:50

1 Answers1