Jump to content

Cached Join Results?


This topic is 5729 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi There

I have a minor issue i'm trying to get my head around. I am presenting statistcis via a portal to show the number of calls logged against a particular customer contract.

What I am finding though, is that when the portal has been accessed, I have to click off of it (i.e. background or another field) before the values are displayed.

When they have been displayed once, Filemaker seems to cache the stats ready (instantly) the next time this record is accessed. If you quit & relaunch the database, they need to be refreshed again.

The stats arrive via a relationship to another table which is using a summary field to calculate the statistic in the first place.

It seems to be a portal refresh issue, as in FMP5 the portal 'seemed' to refresh on the fly.

Can anyone shed any light on this for me?

p.s. hope this makes sence.

Link to comment
Share on other sites

It is a refresh issue, and you can force a refresh by invoking a Refresh Window [Flush cached join results] script step. You could possibly make the portal refresh automatically by changing a few things around, like using a Sum(related) calc instead of related summaries - but we would have to see your file to make sure.

Link to comment
Share on other sites

Thanks for the reply...

Yes it does solve the problem, but brings back one I was trying to avoid. By using the Sum calculation, this 'stalls' the database until the figures are displayed (which can be counting several hundred records in the child db).

This doesn't happen via the Summary method.

I also don't have the option to index/store the results as other calculation fields are referenced.


Link to comment
Share on other sites

This topic is 5729 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.