FIND on container fields

[DonH]

Is it possible to do a FIND on a container field JUST to see if there is something in it? Or maybe looping over the entire database and some type of check to see if there is anything in the container field.

[Lee Smith]

You will need to do a baloon calculation on the field and do a find on it.

your calculation would look like this:

Case(Image of File=0,"No", "Yes")

Note: Image of File is your container file name.

HTH

Lee

[DonH]

Case? Hmmmm. Looking looking. In FM6 where is that?

[Lee Smith]

create a new field, make it a calculation, use the calculation modified as stated previously, and then make the results of the calculation "text".

HTH

Lee

[LaRetta]

Hi Don,

I believe that a calculation (number) with not IsEmpty(Container) may be a TAD more efficient when searching through large-record databases. Then you would just Find on this calculation field for a 1. I may be wrong though.

LaRetta

[DonH]

Ahhh okay. I was doing it in the script. A calculation field sounds much easier.

[-Queue-]

Baloon? Ah, you mean Boolean!

Poor George must have just rolled over in his grave.

[Lee Smith]

Back off

[DonH]

Baloon calculations are for floating numbers.