3 Replies Latest reply on Feb 16, 2009 12:32 PM by TSGal

    Globals working for one user but not for another

    gpaul

      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?

        • 1. Re: Globals working for one user but not for another
          TSGal

          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. 

           

          • 2. Re: Globals working for one user but not for another
            gpaul
              

            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.

            • 3. Re: Globals working for one user but not for another
              TSGal

              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.