Forum post
Globals working for one user but not for another
Forum post posted February 12, 2009 by Gerald, last edited February 9, 2012
77 Views, 3 Comments
Title:
Globals working for one user but not for another
Post:
I have a client that I host their database on FMSA 9 latest version. I am running FMP 8v3 Advanced and they are running FMP 8 to 9. Certain scripts are not working since the global is not set for them properly. Here is what I have to run the queries.
Fields:
gRecID = Global Number
RecID = Serial Number
Script
setfield (gRecID, RecID)
enter find mode
setfield (RecID,gRecID)
perform find
This works on mine, but on theirs. I understand globals and how they work for network users.
Has anyone ever seen this problem?
Answer
Gerald:
Thank you for your post.
Without seeing the file, my first thought is that the RecID field is blank for the user. This would then not find any records and/or give an error message.
Something else you may try is:
If [ not IsEmpty (RecID) ]
Set Variable [ $var ; RecID ]
Enter Find Mode []
Set Field [ RecID ; $var ]
Perform Find []
End If
--------
This checks first to make sure there is a value in RecID. If so, then it stores the contents of RecID into a variable, enters Find Mode, and puts the value of the variable in RecID and performs the find.
Let me know if this works for you.
TSGal
FileMaker, Inc.
Be the first to like this
|
Sign in to "Like"
What is happening is the global field seems to not get the recid. If I do the exact procedure from my computer, then it works. If I go back to the other computer and do the same, it won't work. I am very confused on this. I am planning on rebuilding my FMSA Server anyways, so this might be good time to recover all the files at the same time.
Be the first to like this
|
Sign in to "Like"
Gerald:
Thank you for your post.
Put a "Halt Script" after the "Set Field" script step. Let's make sure there is a value in the gRecID field. This may offer a clue.
TSGal
FileMaker, Inc.
Be the first to like this
|
Sign in to "Like"