Change the value for a Global field 1

[databasedeveloping]

When i change the value for my global field the "old" value pops up the next time i start my application.

Why doesnt my global field remember my changes?

thank u for answering

/dimi

 

[Philland]

Need more information please.
What type of global field is this? Text, number. etc.
Is it used with any script steps?
Is there a look up value designated with the field?
What's the function of this globl in your database?

Phil

 

[Schlogg]

Do others access your file - i.e. is it shared?

Cheers,
Paul J.

 

[databasedeveloping]

In one way i have sucseeded to solve the problem, but im not satisfied with the solution.

OK, i have a global field of the type text. The DB is shared via the Filemaker server. So when i´m opening the file I become a guest on the file. I change the global field and when i reopen the file my changes are gone.

I know se that my changes are gone because of the fact that i open the DB as a guest.

So, I closed the file for the FM Server, opened it directly with the FM client, made my changes and it was fine.

The question now is, how can i open my DB as a host when the file is shared via the FM server? Is this in any chance possible?

I dont want the close my files in the FM server every time i want to change the values for my global fields.

thank u for taking time answering my questions

/dimi

 

[Philland]

I have multiple databases running on Filemaker Server and pretty much all of them use global fields to move data or maintain relationships between bases. The use of a global field with Filemaker Server should not, in and of itself, be a problem.

Are there other users that may be setting the field back to previous settings? Is there a start up/shut down script that may set the global field? This script can be in a related database.

What does this field do in your database that requires it to be a global?

Phil

 

[databasedeveloping]

The global field in this case sets the path where i want to save my files. Im adding docs for each record, at the same time as i rename and moves these documents (this beacause of another application accessing my DB via ODBC.

Is it possible to changes global fields without openeing the DB as a host?

 

[Philland]

Changing a global field shouldn't be any different than changing any other field. I would double check your field definitions and confirm that this is properly inidicated as a global.

If you have a copy of Filemaker Developer, check to see if this field is used in any scripts.

Try this;

In layout mode go to format::field format and deselect "allow data entry" for this field. Write a little script that has "Go to field "global" in it to give yourself access and block other users out. This way only scripted changes can be made to the global field or changes made by accessing through your go to script.

Let me know if any of this helps.

Phil

 

[databasedeveloping]

OK, thank you for the tip, I´ll try in later this day!

/dimi

 

[databasedeveloping]

hmm, i think there is something strange with changing the values for global fields....

i have a global field (defined as a numberfield) with the value 1. Then I run a script with one simple row "set field("nameonthefield", "2&quot.

I close my file, and reopen it, now i the field value is 1.

If I do the same procudure but open the file as a host, the changes is remebered, iow the value becomes 2.

any comments?

 

[databasedeveloping]

AAH!! I got the hint! Listen to this...the phenomona simply occurs because of that my changes arent fast enought to saved to the sourze file!

If i do the same procedure as explained above, and then open the "define field" , there is a automatic save to the source file, and i have now problem to change the global field

so, the conclusion:
I cant open a file and ONLY make a fast change on a global field.I simply need to certify that the changes have taken affect on the file.

/dimi

 

[1234shu]

I have the same problem with a globale field. The value stays even I delete all the records. The field is a date type. I can set it to empty locally. But after I put the FM file on server, it can't be changed. Even I change it manully. But when I open the file I got the old value. Please help to solve this problem. Many thanks.

 

[Schlogg]

When a file is closed, FMP 'remembers' the global values set by the host so that, next time it is opened, the host's global values are there. Any changes made by guests are lost; they last only as long as the guest's session.

Cheers,
Paul J.