Jump to content

unstored calculated fields accessed with fx.php

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

Recommended Posts

I have a database layout with some unstored calculated fields that are referencing data from another file with some calculations applied to that data.

When I call these fields from PHP (for a record that I know has this data when looking at the layout), they have no value in them. Is this because they are unstored, or because they are based on a related file?

The problem is that it is not just a simple go get the value from the related field, it has some logic applied to it, otherwise I would either pull another record set using the key field between those tables or stick the related fields on the layout in FileMaker and pull them that way.

Any help would be appreciated.

Link to comment
Share on other sites

  • Newbies

Is it possible you are using 8.0v1 or 8.0v2? There were known problems with finding on unstored calcs with these versions. 8.0v1 failed completely on some unstored-calc searches, and 8.0v2 had very severe performance problems with these searches.

If you are not on 8.0v3, update and try again (and let us know)


Edited by Guest
Link to comment
Share on other sites

I am running Server Advanced 8v3. I applied that the first day it was out hoping that it would improve performance in another area.

It is really strange. I can see the correct data on the layout inside FileMaker but it does not show up in the array that comes out. I have been trying to read anything that I can get my hands on, but everything I have read doesn't even mention anything special about this situation, so I am assuming that the normal behavior should be that the field would show up like any other field.

Link to comment
Share on other sites

This topic is 5682 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.