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.

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?

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

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?

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

Ok, that makes sense.

Thank you much.