Hello everyone,

I recently wrote a rediculous number of scripts, some of which paste the calculated values into Global text fields. After I close the database, though, these values disapear. Then I need to re-run the scripts to paste tham again.

Is this normal?

Thanks for the advise

If your database is shared, only changes made to global fields by the host will be retained. If it is served, the server is the host, and no users changes to global fields will be saved.

If you are trying to have global variables relevant to all users whose data can be changed by any user and whose data is saved every time it's changed, the seemingly preferred method is to put it into a related database that has only one record. I say seemingly because with multiple users, if one user is accessing that single-record related database, another user cannot.

Not quite correct: only one use can *edit* the record at any one time. Multiple users can access the record to read data from fields etc.

Since preferences don't get changed often and access is often limited to an admin user, it's no problem.

Thanks for the posts, guys.

I don't care about editing the global fields by the users. What I wonder about is why the global text fields that I paste values into don't persist like the ones I set in the script.

It just seems like the values should persist, and after I close and re-open the database, the values I pasted into the global text fields should still be there.

BB

Only 2 reasons:

1. You are NOT the host when setting the globals

2. The fields are NOT globals

Only 2 reasons:

1. You are NOT the host when setting the globals

that's right, the files are on the server

2. The fields are NOT globals

They are. I understand, that the whole idea behind globals is volatile persistance, like variables. But the curious thing is that sometimes some global fields persist, while other times others don't. Irrespective of text globals or number globals.

I think it has something to do with the Server writing dirty pages from cache to disk, data dumps and such.

Globals only persist when a file is not hosted by FM Server and is opened by a client copy of FM as the only user. When hosted by FM Server, every session is transient and globals always revert to the values they had when opened last as mentioned above.

-bd

Ladies and Gents,

I'd like to share with you, that now globals persist just fine, even though hosted on the server. But before they did not.

Go know....