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

[Stephe Pocock]

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: http://au.mobile.yahoo.com/mail
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20090715/ee2b85e1/attachment-0001.html