Solved

Global fields in a multi-user environment

Posted on 2006-11-15
4
246 Views
Last Modified: 2010-04-27
i have a filemaker database running on a stand alone computer. i have 4 users accessing the database through filemaker remote. i used to have just one user and we hired 3 more in the past month. the database was stable when only one user was accessing the database. now, every so often when 1 user prints a form, the data on the form is not from the record she is choosing.
my question is: do global fields apply to the specific user logged in or is it based on the database?
can each user have  values defined for the same global field that is unique to them?
0
Comment
Question by:kauakea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 28

Expert Comment

by:lesouef
ID: 17954307
If the file is stand alone, the global field is stored
If the file is shared and hosted by a fm server, the global field value is never stored and is local to each client. It may contain a value at file open, and this will be the last value used in stand alone mode before sharing the file and placing it on a fm server.
And finally, when sharing a file using the basic filemaker pro as you are doing, I have no idea and can't test now as I have only 1 fm client, but it's easy to check.
Change the value of the global field, and see if it changes on the screen of the other users: if yes, then the value is common to all and you're trapped, you must store the current user a different way. If you use FM8, use variables instead of global fields
0
 

Author Comment

by:kauakea
ID: 17959095
thanks lesouef, i didnt think to test the global values.
they are user specific. each user can have a different value. i inserted the global field in question on the main layout  and each user had a different value displayed.


the reason for my question is that i have a database that has one common control field in all the tables. the field is ts-number. i also have a ts-number global field that i set whenever the user moves away from the main information screen and i use the ts-number global  to do a find so that they return to the same ts-number screen they were on when they left the main information screen.
but sometimes they do not return to the same ts-number they originally left from on the main information screen. they would return to a different ts-number. it is not consistent and is not always the case. so i am trying to determine where the problem might lie.

are variables user specific?? are they more reliable than global fields?
0
 
LVL 28

Accepted Solution

by:
lesouef earned 500 total points
ID: 17959820
variables are user specific.
more reliable? no, but avoids wasting fields for temp things, and more flexible since they can be global to a user ($$var), or specific to a script ($var). they are also independant of any layout unlike fields.
back to yr problem, it should not happen for sure; there must be a script error somewhere or there must be a layout where it is not found?
I suggest you display that ts_number in all layouts to try to locate the pb.
0
 

Author Comment

by:kauakea
ID: 17959905
i didnt realize $$var was user specific. i thought it was database specific which is why i did not use it. i think i will change my global references to a $$var value in my scripts.
thanks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question