About Picture Compare

[notrino]

Hello,

I attached my sample. You will see, in the form 2pcs. picture area with OLE. When I push the button, If this pictures are the same pictures, text area must be show 1, if they are not same pictures, text area must be show 0. Is that possible? Thank you.

https://www.access-programmers.co.uk...d.php?t=302424

[Minty]

What determines if the pictures are the same, how are you proposing they should be compared?
By a file attribute ?

[notrino]

Hi Minty,

Did you notice? You answer questions with questions always. Why? Isn't it easier to focus on the problem itself?

[isladogs]

Hi notrino

Did you notice? You answered Minty's questions with questions. Why? Isn't it better to answer them?

[notrino]

Hi ridders52,

First Situation;
I'm a simple user and I "always" ask questions. Because;
Simple users ask questions, experts answeres.(If they know or if they want) At the same time, this is the purpose of the forums.

If experts asking to me, thats mean; They are not expert, I'm the expert.

Second situation;
After taking the answer to my question with questions, "you" are asking questions too. So, My question creating 2 different question from 2 different "users" (I have to say "user", I can't say "expert" in this situation)

I'm asking again;
Is there anyone who can answer my first (topic1, it is showing on the screen like #1) question?

Thanks.

[Minty]

Hi Minty,

Did you notice? You answer questions with questions always. Why? Isn't it easier to focus on the problem itself?

I'm asking a question because without the additional information your question is currently unanswerable.
If you had asked a question with sufficient information to generate a viable answer then hopefully you would have had an answer after 67 views.

Did you notice? I haven't asked another question there.

[isladogs]

That was also the point I was making by mimicking your response but you seem not to have grasped my meaning.
When someone asks you a question, it is to try and clarify what you want so they can help you.

Depending on the criteria, all of the following pairs of image files could be said to be identical to each other
a) 1.bmp and 2.bmp (file type)
b) 123.bmp and 123.jpg (file name)
c) Two files with same dimensions
d) Two files with the same file size
E) Two files that look exactly the same but have none of the above features

Any one of those could be what you want ... OR something else entirely.
Each would require a different solution though I think e) would be impossible to do using Access

Do you understand the point now?

[Minty]

I have a feeling we won't hear any more on this thread.
The OP seems to have developed a habit of simply dropping out of threads they have started when the answers or suggestions don't provide an relatively immediate fix.

Or maybe as we are now classified as "users" we aren't worthy of a polite response

[notrino]

That was also the point I was making by mimicking your response but you seem not to have grasped my meaning.

No ridders52, I understand very well.

First of all,
Instead of asking me unnecessary questions, you can say this details;

a) 1.bmp and 2.bmp (file type)
b) 123.bmp and 123.jpg (file name)
c) Two files with same dimensions
d) Two files with the same file size
E) Two files that look exactly the same but have none of the above features

This is a much more expert approach.

On the other hand,
My question is very clear. If you were studying the example I added, you would see the picture and the nature of the file. Have you examined my example really? If yes, You shouldn't have asked the following details;

a) 1.bmp and 2.bmp (file type)
b) 123.bmp and 123.jpg (file name)
c) Two files with same dimensions
d) Two files with the same file size
E) Two files that look exactly the same but have none of the above features

Thanks.

[isladogs]

Actually, despite the unhelpfulness of your responses (something you do seem to be an expert in), I did look at your database.
That was partly why I listed 5 of the possible criteria for deciding whether both images were the same

a) file type - YES - both are bitmap images of a horse in a field
b) file name - not sure I can tell that without looking the the files' extended properties
c) same dimensions - YES - both 800px width x 500 px height
d) same file size - don't know without looking at the extended file properties but unlikely as one appears to be higher resolution than the other (total pixel count)
e) Two files that look exactly the same - YES - at least they look the same to me

So are they the same image? The answer depends on your criteria.

One more thing - it is more efficient to store the path to the external images files rather than using OLE images (whether embedded or linked).

[Minty]

This is painful.
Ridders kindly listed a set of some of the possible comparison criteria.
You still haven't actually told which of those criteria YOU want to use to compare the pictures.
We aren't mind readers, so without YOU supplying the criteria to be used we are simply guessing.

However as a basic user I might have tried this in a query ;

SELECT T1.ID, [pic1]=[pic2] AS PictureMatch
FROM T1;

Does that guide you ?

[notrino]

Yes Minty,

Thank you. Answere is your anwere, it is working.
Simple question, simple answere, that's all.

Now, I can ask real question;
What about the principle of "PictureMatch" code? file tyep comparing? or file size comparing? or file name comparing?.... PictureMatch is matching for what?
Thanks..

[Minty]

It is directly comparing the two OLE objects stored against each other. (I'm guessing this is a bitwise comparison, but don't actually know for certain).

I suspect if you changed just one pixel in either one of the objects it may fail, hence us asking how you wanted to compare them...
To the naked eye there probably wouldn't be any difference, so this method of comparison is possibly flawed for your applications perspective.

As Ridders pointed out storing images IN the database is generally discouraged as it causes database files size to grow very quickly.
And storing them outside the database would render this simple query ineffective.

[notrino]

Normally, PictureMatch=-1 value for same Pic1 and Pic2. (It is normal, because they are same) (I changed horse pictures, I used simple rectangle shape with red filled) When I deleted 1pixel from Pic1 and run the query, PictureMatch=0. It is normal too. But, later, I filled again that 1pixel with paint program, but PictureMatch =0 again. I wonder, what it's comparing.

I know, generally I'm using file path with filedialog applications for picture insert in my databases. But I have to understand this picture comparing base principles.

Thanks a lot, see you.

[Minty]

I wonder, what it's comparing.

But I have to understand this picture comparing base principles.

FACEPALM !

Go back to post #2 and post #7 and actually read what we asked you in the first place.

Just in case you missed it, we asked you by what criteria you wanted to compare the pictures.
14 posts later you have now decided that this is important.

Do you now understand why we asked this in the first place?