[FX.php List] summation field not being red

[Andrew Denman]

"Are there any global fields being to initialize the relationship ? yes;
they make the difference between the different relations"

 

I think this is the issue here since globals are set on a per-connection
basis.  When the WPE connects, these global fields are probably empty so the
relationships are not connecting.  How do the global fields get set when you
are in FileMaker?

 

Look in the FX.php docs for the SetFMGlobal("FieldName", "Value") function
on how to set a global field during a FX.php connection.

 

Andrew Denman

 

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Robert Janssen
Sent: Wednesday, April 16, 2008 11:39 AM
To: FX.php Discussion List
Subject: RE: [FX.php List] summation field not being red

 

hi people
 
william, to answer the questions you asked .....
 

So, in Filemaker the fields are populated with the correct sum - is  
this summation an un-stored calculation field ? correct; un-stored
calculation field

How is the relationship built ? multiple relations to one database, based on
several different global fields 

Result = sum(relation1:uren) + sum(relation2:uren) + sum(relation3:uren) +
sum(relation4:uren)

 

Relation1 based on employeenumber, current year and global variable
"_relation1" with  fixed value

Relation2 based on employeenumber, current year and global variable
"_relation2" with  fixed value

Relation3 based on employeenumber, current year and global variable
"_relation3" with  fixed value

Relation4 based on employeenumber, current year and global variable
"_relation4" with  fixed value


Are there any global fields being to initialize the relationship ? yes; they
make the difference between the different relations
Is there any other related data being exposed ? - Can you see the  
field FLEX::uren for example ? In Filemaker the results of the calculated
fields are shown correctly. Also of each relation a portal is shown to be
able to visually check the results
Sorry for the questions,

 

grtz.

Robert.





 

  _____  


> From: william.downs at gmail.com
> Subject: Re: [FX.php List] summation field not being red
> Date: Tue, 15 Apr 2008 14:54:59 +0100
> To: fx.php_list at mail.iviking.org
> 
> Hi guys,
> 
> But it's not using Summary fields at all - only the sum function
> 
> So, in Filemaker the fields are populated with the correct sum - is 
> this summation an un-stored calculation field ?
> 
> How is the relationship built ?
> Are there any global fields being to initialize the relationship ?
> Is there any other related data being exposed ? - Can you see the 
> field FLEX::uren for example ?
> 
> Sorry for the questions,
> 
> William
> 
> On 15 Apr 2008, at 13:22, Gjermund Gusland Thorsen wrote:
> > Only the reports show the summery fields AFAIK, as it is heavily
> > relaying on the current selection.
> >
> > ggt
> >
> > 2008/4/15, Robert Janssen <janssen_robert at hotmail.com>:
> >>
> >> Hello,
> >>
> >> If anybody could shed some light on my following problem, I'd be 
> >> much
> >> obliged ...
> >>
> >> The value of a calculated field (summation of a related field ) 
> >> is not
> >> shown / not read by the fx module. (I can see the value of het 
> >> calculation
> >> in filemaker itself).
> >>
> >> If I change the fieldtype to a number instead of a calculated 
> >> field, the fx
> >> module reads the field perfectly.
> >>
> >> Here is the summation:
> >>
> >> Sum(FLEX::uren) + Sum(P125::uren) + Sum(P150::uren) + Sum 
> >> (P200::uren)
> >>
> >> greetz.
> >> Robert Janssen
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list



  _____  

Lees jij al je Hotmail op je mobiel? Probeer het nu!
<http://windowslivemobile.msn.com/BrowserServiceHotmail.aspx?lang=nl-nl> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20080416/2a170ff3/attachment.html