Erratic refresh/update

[fiveshorts]

Hi,

I have a DB in development now that is a fairly modest creation — not more than 35 run-of-the-mill calculations; some summaries, a little conditional formatting. Not rocket science.

Yet every time I enter a value in a field (like a quantity of product), the dependent calculations only update when I move the scroll bar or resize the window... they won't update of their own accord when I tab out of the field. Nor will they update when I force-commit the record.

I'm running FM9 Pro on a Mac dual 2.5GHz machine with lots RAM and everything else performs perfectly.

Any ideas, please?

[Søren Dyhr]

You are basing some of the calc's on related summary fields aren't you? Instead use aggregate function over the related values.

--sd

[fiveshorts]

Thanks for your reply, I think I understand...

I'm going to have to stew on that riddle for a bit :)

Edited January 10, 2008 by Guest

[David Jondreau]

I've had similar experiences and it can be frustrating. What solves it for me is a Refresh button running a script with the following script steps:

Commit Records/Requests

Flush Cache to Disk

Refresh Window

[fiveshorts]

Once again, you're right on the money, thanks.

I'm going to still try and determine the root cause of the glitch (once I've deciphered Soren's advice...) but a refresh/update button will be enough til then.

thanks.

[Søren Dyhr]

Cascaded relationships and calc's involving global field or summary fields, could have issues - This thread:

http://www.fmforums.com/forum/showtopic.php?tid/171550/fromsearch/1/hl/freshen/tp/0/all/1/

...provides good info on the behaviour. Especially the links seen in this post wraps it up:

http://www.fmforums.com/forum/showpost.php?post/183403/

--sd