Hi, could it be that your calculation is incorrect ?

should probably be Upper(Patrons::Country)="CANADA"

HTH,

Peter

Thanks, Harry --

I am using 8.5 v1 Advanced. How could I find out about this new ability to
re-calculate? It sounds like the tonic I need...




"Helpful Harry" <helpful_harry (AT) nom (DOT) de.plume.com> wrote

On Apr 20, 12:04 am, Helpful Harry <helpful_ha... (AT) nom (DOT) de.plume.com>
wrote:
In newer versions you can set auto-enter to update even if it already
has a value.

In some circumstances yes. But not in general.

Calculation fields cannot reference related files and be stored /
indexed.

Auto Enter calculations can reference related files and be stored /
indexed.

However, that doesn't buy you any functionality as they only update if
a referenced field in the same table changes. They will not update if
a related referenced field changes.

-cheers,
Dave

Rick -- you need to make sure that both of the following options ore NOT
checked:

"Do not replace existing value of field"

and

"Do not evaluate if all referenced fields are empty"

Greg



In article <2t2dnVKP9akXRLXbnZ2dnUVZ_vyunZ2d (AT) comcast (DOT) com>,
"Rick Altman" <rick.a (AT) NOSPAMaltman (DOT) com> wrote:

In article <1i4n2f8suhhy5.9ggeoi1o5ob.dlg (AT) 40tude (DOT) net>, Peter
<nomail (AT) homeorwork (DOT) tnx> wrote:

That would certainly help. )
Although it might just be a typo when transferring the calculation to
the newsgroup message.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On Apr 20, 5:40 pm, Helpful Harry <helpful_ha... (AT) nom (DOT) de.plume.com>
wrote:

Is Upper even necessary? Patrons::Country = "Canada" ,
Patrons::Country ="CANADA", Patrons::Country = "CaNAdA" all evaluate
the same, no?

In addition to the auto-enter calc, I'd also check the Auto Enter Data
box and put a 6 in there. Then on creation, you'll get the assumed US
shipping, unless you change it.

On Apr 20, 4:59 pm, Grip <g... (AT) cybermesa (DOT) com> wrote:
No upper isn't strictly necessary.

Most of the time.

Filemaker is language aware, and its comparison operators take that
into account. In "English" c=C and Canada=CANADA=canADA. However there
are some scenarios where Filemaker isn't using English rules; e.g. if
a field is defined as Unicode. In which case A < Z < a < z and
"c"="C" is false. The language rules affect sort order, comparison
operations, indexing, and even relational operations. On such a field,
upper would be required.

When you define a field, you can specify its 'language'. Check the
options, its on the "storage" tab in new versions of FM. Its one of
those options few devs ever use and it affects filemaker in subtle
ways.

But overall no, probably 99% of the time in filemaker you don't have
to worry about case.

-cheers,
Dave

PS -- if you want to worry about case, that's what the exact function
is for.