Erratic refresh/update

January 9, 200818 yr

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?

January 10, 200818 yr

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

--sd

January 10, 200818 yr

Author

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

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

Edited January 10, 200818 yr by Guest

January 10, 200818 yr

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

January 10, 200818 yr

Author

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.