[FX.php List] Global field works on one table but not another?

[Joel Shapiro]

Dan, you're a better mind numb-er than I  :-)

However...

Jon, do you need to use the global value over the web or just locally  
in FMP?  I had thought I'd seen something the other day (on one of  
the FM lists) that opening scripts DO get called even when opened  
over the web (in the pseudo-client of FMS/WPE).  But I just created a  
new global field on a hosted file, put a SetField in an opening  
script, and my php page shows no value for the global.

So, if you do need the global value over the web, then it looks like  
Dale's original suggestion is what you'd need to do (close the file  
off of FMS, open the file locally, set the value, close the file,  
open it in FMS)

-Joel


On Aug 3, 2007, at 2:50 PM, DC wrote:

> LOL! joel... snap!
>
> but (IMHO) my answer was better because of the mind numbing detail  
> about opening scripts!
>
> dan
>
> Joel Shapiro had written:
>> Or alternatively you can have a script set to run on Opening that  
>> places the values you want into global fields.  (This way, you  
>> could change the globals in the future just by changing the  
>> script, instead of having to take the file off FMS, change it,  
>> then open back up in FMS)
>> -Joel
>> On Aug 3, 2007, at 2:36 PM, Dale Bengston wrote:
>>> When you're working on a hosted file, the globals are "temporary"  
>>> to the current user. If they were blank when the table was  
>>> hosted, they will revert the next time you open the file.
>>>
>>> To get globals to stick, you have to open the file locally with  
>>> FMP client, set the globals and then re-host the file.
>>>
>>> Dale
>>>
>>> On Aug 3, 2007, at 4:30 PM, Jon Montgomery wrote:
>>>
>>>> I have two data bases that were accessed via FX.PHP. Last year  
>>>> all worked
>>>> fine.  Clients entered events and then printed a billing sheet  
>>>> that they
>>>> mailed in.  Those billing sheets had some global fields for the  
>>>> fees and
>>>> every thing worked!
>>>>
>>>> Now to take advantage of another table that ended up being the  
>>>> same in both
>>>> data bases.  I move the information in the second data base to  
>>>> the first
>>>> data base (copy and paste the fields).  Recreated the needed  
>>>> layouts.  But
>>>> for some reason, the Global fields in this new table do not  
>>>> work.  I enter
>>>> the fees in FMP and then when I quit the data base and then go  
>>>> back on line,
>>>> those global fields are blank.  I am not sure what I did  
>>>> different?  The
>>>> global field in the other table work fine.
>>>>
>>>> Is there some checkbox I am missing in the Define Data Base?   
>>>> Indexing?  Any
>>>> help would be appreciated.
>>>>
>>>> I even tried going back to the old second data base (the one I  
>>>> copied the
>>>> fields from) and it works.  All global info is there.  But not  
>>>> in the new
>>>> table in the first data base.
>>>>
>>>> Any ideas?
>>>>
>>>> Jon Montgomery
>>>>
>>>> --Jon Montgomery
>>>> Illinois Grade School Music Association
>>>> Home email: vicepresident at comcast.net
>>>> IGSMA email: vicepresident at igsmasouth.org
>>>> School email: jwmontgomery at dqud300.perry.k12.il.us
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list