Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Global fields in a multi-user environment

Posted on 2006-11-15
4
Medium Priority
?
248 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 2000 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

Independent Software Vendors: 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

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

610 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