Hi me again, yes i'm working this sunday and that's why I have many
questions today....

I have a calculation field that result a "text" and it's display in a layout
as a merge field.... the result is a calculation with expiration date base
on a field (contrat start) and another one that ask user to enter duration
(1 year, 2 years .....) and the result is the expiration date....

My problem is that the merge text doesn't refresh and display the instant
result. I use those seting on the field, Its not storing the value, and I
uncheck "do not evaluate...."

So when I change the duration field, the text will not change right now on
screen... commit record, enter, clicking anywhere on screen doesn't change a
thing, switching from browse to layout to browse, bring the right result on
screen.....

What iM doing wrong, or it's just FM8.5.... I remember with FM6 never had
this behavior.

Thank you

JF

On 04/01/2007 12:17:11 "JF" <bizouman_takethisout (AT) hotmail (DOT) com> wrote:

In the Storage Options for the calculation, do you have the box "Do not store calculation results -- recalculate as needed." CHECKED?

FM's default is to store the results, essentially a one-time calc.

Matt

Yes that's what I said in my mail..... does'nt change a thing !

JF

"Matt Wills" <I'm (AT) witz (DOT) end> a écrit dans le message de news:
41147.IEYPBQBY (AT) news (DOT) verizon.net...

Would you share with us exactly what your calc says? Is it that the
calc field itself is not updating or that the screen is not refreshing
to show that changed calc?

JF wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

I don't know if the formula gets update and/or it's juste the screen refresh
?!?!

OK this is a simplefy form of my calc. formula

cPPM_Expiration is a Custom Fonction
[
Date ( Month ( Min ( Entretien_Mois_Visite::EM_Mois_Visite ) ); 1;Year (
Min ( Entretien_Mois_Visite::EM_Mois_Visite ))+LeftWords (
Entretien_Data::ED_Durée_Contrat; 1 ))
]

Basicelly this take the earlyest date entry in a relationship and transform
it into a date format and adding up the amount of year(s) in the field
Entretien_Data::ED_Durée_Contrat [ value list of : 1 year, 2 years, 3
years.....]

The formula is:
"Contract will expire on " & Monthname ( cPPM_Expiration )& " " & Day
(cPPM_Expiration) & " " & Year ( cPPM_Expiration )

Is that possible the custom fonction make the formula not update ??


JF


"Howard Schlossberg" <howard (AT) antispahm (DOT) fmprosolutions.com> a écrit dans le
message de news: 1310776tfctct3f (AT) corp (DOT) supernews.com...

"JF" <bizouman_takethisout (AT) hotmail (DOT) com> schreef in bericht
news:bkWPh.20195$ig1.111522 (AT) weber (DOT) videotron.net...
I see the fault, you are trying to add a number to some text.

The number part is:
Date ( Month ( Min ( Entretien_Mois_Visite::EM_Mois_Visite ) ); 1;Year (
But LeftWords is a textfunction.

You have to make a number of this part first.

GetAsNumber ( LeftWords ( Entretien_Data::ED_Durée_Contrat; 1 ))

That should do the trick

Keep well, Ursus

Thanks but the calculation was working anyway.... I was searching for that
fonction (in FM6 it had another name ?!?!) but the result was good, it's
only the redraw of the awnser that was not working....... If I change record
and come back.... voila! it change...... the funny thing my calculation is
longer then what I told you, I take information if there's a check box check
and change the text base on this 1st validation..... as soon as I check the
box, the result change automaticaly... but not when it need to do some
calculation using the custom fonction ?!?!

It's not working as a standard field and a text merge field.....

JF

"Ursus" <ursus.kirk (AT) wanadoo (DOT) nl> a écrit dans le message de news:
461037cb$0$79450$dbd4d001 (AT) news (DOT) wanadoo.nl...

I have found the problem...... it's the CustomFonction !!

I have replace in my calculation field the custom fonction by its equivalent
data and now the result is instant !! the text change the second I change
the the duration field......
haaaa let me see if FM8.5v2 fix that problem ??? I did'nt install it at home
!!

JF


"JF" <bizouman_takethisout (AT) hotmail (DOT) com> a écrit dans le message de news:
D0ZPh.26687$ig1.153090 (AT) weber (DOT) videotron.net...