Newbie: Finding all records with pictures

[gravitythread]

My database has two container fields, used to store pictures. How would I perform a find, or write a script to find all records with a picture loaded.

We're trying to export all these pictures, which sounds like it'll be a whole other can of worms...

Thanks.

[Zero Tolerence]

The easiest way, that I know of. Would be to have a separate calculation field that is a 1 or a 0.

If( Container 1 = "" and Container 2 = ""; 0; 1)

Put that in it, then just run a search for 1's.

Exporting the pictures is going to require that you loop through them, then export field contents each time. What version of FileMaker are you using?

[gravitythread]

Zero,

Unfourtunately, no one thought to do that originally. Is there a way to do the find without a seperate field though? Something like ContainerIsNotEmpty(container1)

Also, this is for FM 4.1. Kinda dated...

Thanks

[Zero Tolerence]

Unfourtunatley, FM does (to my knowledge) not allow you to search using Not Equals. If it did, you could find everything that ≠ "".

4.1 is way before my time, but when you add a calculation field doesn't it calculate the data for every record in the table?

[-Queue-]

Try a calculation of not IsEmpty(containerField), with a numeric result. Or loop through all records and omit the ones where IsEmpty(containerField).

[gravitythread]

Ok, that makes sense.

Thank you much.