[FX.php List] Problem with Global fields

[Roger Price]

Gjermund

This explains why it worked with one global field and not the other. I began 
developing this solution before receiving my copy of FMPSA8 and was using 
FMP6U. I made all the database changes on the 'host' copy which was why the 
global field was available to all.

Thank you for solving the mystery!

kindest regards

Roger
----- Original Message ----- 
From: "Gjermund Gusland Thorsen" <ggt667 at gmail.com>
To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
Sent: Friday, April 13, 2007 1:03 PM
Subject: Re: [FX.php List] Problem with Global fields


> If the global field value is static
>
> Take the file offline
> change the value in the global field, close the file, reopen it and
> check with different users that the value is the same
> put the file online again.
>
> ggt667
>
> On 4/13/07, gerry.charest at agfa.com <gerry.charest at agfa.com> wrote:
>>
>>
>> Roger,
>>
>>  The blank global field is a result of context. Global field values are
>> unique by user. If several people have a copy of the database open they 
>> each
>> have a unique set of global values. The connection to the web can be 
>> viewed
>> as another user thus it has its own set of global values. Another
>> consideration you may wish to consider is the use of Auto enter 
>> calculation.
>> This allows you to store and index the value with less overhead than a
>> calculation.
>>
>>
>>
>>
>>  "Roger Price" <rp272 at cam.ac.uk>
>>
>>
>>
>>
>>
>>
>>
>> "Roger Price" <rp272 at cam.ac.uk>
>>  Sent by: fx.php_list-bounces at mail.iviking.org
>>
>> 04/13/2007 07:26 AM
>> Please respond to
>>  "FX.php Discussion List" <fx.php_list at mail.iviking.org>
>>
>>
>> To
>>  "FX.php Discussion List" <fx.php_list at mail.iviking.org>
>>
>>
>> cc
>>
>>
>>
>> Subject
>>  [FX.php List] Problem with Global fields
>>
>>
>>  I experienced a problem recently with an FMP calculation field that
>> included a global value as an option in an 'if' statement.
>>
>>  The field correctly displayed in FMP but the 'global' option did not 
>> show
>> up when selected by FX.php (the other other did!).
>>
>>  I was reccommended to get the values of both field found by FX.php and 
>> use
>> PHP to make the correct selection.
>>
>>  This worked!
>>
>>  I now have another 'global' field that I want to do something similar 
>> with
>> but the value of the 'global' field appears to be blank. If I use 'if
>> (isset($value['global_field'][0])){echo
>> "set";}else{echo"unset";}' it returns "set" so there must be something 
>> there
>> - just not the value I expect.
>>
>>  To overcome this problem I have changed the global field type to
>> 'calculation' and added the value required. There are not a great number 
>> of
>> records so the additional overhead is not excessive in this case. However 
>> I
>> would like to know what is happenning with these global fields.
>>
>>  In my original calc field I substituted a text string for the global 
>> field
>> which worked just fine, however reverting to the 'global' resulted in a
>> blank field!
>>
>>  Any ideas?
>>
>>  Roger
>>
>>  _______________________________________________
>>  FX.php_List mailing list
>>  FX.php_List at mail.iviking.org
>>  http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>