Question on a calculation

#1

I have a container that I store a picture in and I am trying to have the
calculation check the container and tell me whether or not each record has
one:

Here is what I have:

CheckContainer = If ( Picture Database::Carded Picture= "" ; "Empty" ; "Not
Empty" )

For some reason the field will only show "Not Empty" when a picture appears,
if no picture there is nothing the field.

Any help?

#2

In article <hxhRq.5127$Xa1.3591 (AT) newsfe15 (DOT) iad>, "Iced Tea"
<icedteas (AT) cox (DOT) net> wrote:

Quote:

I have a container that I store a picture in and I am trying to have the
calculation check the container and tell me whether or not each record has
one:

Here is what I have:

CheckContainer = If ( Picture Database::Carded Picture= "" ; "Empty" ; "Not
Empty" )

For some reason the field will only show "Not Empty" when a picture appears,
if no picture there is nothing the field.

Any help?

There's an option in the Define Calculation window that says something
about not calculating when referenced fields are empty - turn that off (or
is it on?) so that the calculation is calculated even when the Carded
Picture field is empty.

Helpful Harry

)

#3

Thanks, I thought I had it unchecked..

"Iced Tea" <icedteas (AT) cox (DOT) net> wrote

Quote:

I have a container that I store a picture in and I am trying to have the
calculation check the container and tell me whether or not each record has
one:

Here is what I have:

CheckContainer = If ( Picture Database::Carded Picture= "" ; "Empty" ;
"Not Empty" )

For some reason the field will only show "Not Empty" when a picture
appears, if no picture there is nothing the field.

Any help?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Question on a calculation

comp.databases.filemaker comp.databases.filemaker

Question on a calculation - 01-17-2012 , 10:41 AM

Re: Question on a calculation - 01-17-2012 , 01:59 PM

Re: Question on a calculation - 01-18-2012 , 08:49 AM