[FX.php List] FX.php problem ... Calculated Values not shown

[Joel Shapiro]

Hi Stephen

FX.php requires the XML (fmxml) Extended Privelege, not the PHP  
(fmphp) Extended Privelege (which is required for the FM API).  Is  
that what you're using?

I've never heard of using the guest account for web access, but if  
that works, make sure that both FMP files are using the guest account  
and both are using the fmxml Ext. Priv.

HTH,
-Joel


On Jul 15, 2009, at 9:13 PM, Stephe Pocock wrote:

> Hi
>
> That rings a bell.  I think I have dramas with this before, and  
> with this database.
>
> OK, one of the related files is an odbc connection (AM_HBM_MATTER),  
> so I have removed that from my calculation.  The other relationship  
> is to another FM database and that database has the guest account  
> enabled with web access only.
>
> Thanks Tim
>
> S
>
> From: Tim 'Webko' Booth <tim at nicheit.com.au>
> To: FX.php Discussion List <fx.php_list at mail.iviking.org>
> Sent: Thursday, 16 July, 2009 11:18:36 AM
> Subject: Re: [FX.php List] FX.php problem ... Calculated Values not  
> shown
>
>
> On 16/07/2009, at 1:10 PM, Stephe Pocock wrote:
>
>> Hi all
>>
>> Long time lurker here :).  Following GGTs advice I have used  
>> pastebin.
>>
>> I have a page that is used to claim an email by entering a matter  
>> number (case ID).
>>
>> I have a calculated value that checks if the matter is valid using  
>> a couple of relationships.
>> c_MatterCheck =
>> Case (
>> not IsEmpty ( AM_HBM_MATTER::MATTER_NAME ) ; "Yes" ;
>> not IsEmpty ( AM_MatterNumbers_Matter::Matter Description Calc ) ;  
>> "Yes" ;
>> "No" )
>
> Does the web account have access to those tables? As the default is  
> No, if the accoutn can't get the data, it will always be No
>
> Cheers
>
> Webko
>
> Access Yahoo!7 Mail on your mobile. Anytime. Anywhere. Show me how.
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list