2 Replies Latest reply on Dec 1, 2009 11:58 AM by philmodjunk

    Delete Record/Request Script

    SmallTown

      Title

      Delete Record/Request Script

      Post

      FM Server 9 & 10 /Windows Server 2003 sp2  FM Pro 9 & 10 /Windows XP sp3. Two Files work together via the Server. One file has all the data tables and one file has all the layouts. Set up this way for ease of update for remote users not connected full time, the large data tables are not sent with updates just the layout file. Access privileges is set the same in both files ie Level_3  allows to create and edit records but not to delete. I have a delete record script in the layout file and set it to "Run Script With Full Access Privileges". It gives a message that your access privileges does not allow this! There is only a one layout I have a button to run this script. Any ideas on how to get this to work.

        • 1. Re: Delete Record/Request Script
          TSGal

          SmallTown:

           

          Thank you for your post.

           

          If the "Delete Record" script is set to "Run script with full access privileges", then you should be able to delete the record.  It could be something corrupt with the script or the layout.  Try the following:

           

          1. Create a new table "Test" with one text field "Name", and enter one record with Name: SmallTown

           

          2. Create a new script "Delete Record" with the script step:

           

          Delete Record/Request []

           

          .... and be sure to check the option "Run script with full access privileges" at the bottom of the script dialog box.

           

          3. Save the script and execute the script.  You should get a warning "Permanently delete this ENTIRE record?".  Click Cancel.

           

          4. On the layout, create a rectangle, and with the rectangle still selected, pull down the Format menu and select "Button Setup..."  Select "Perform Script" and select the script "Delete Record".  Return to Browse Mode and save the Layout changes.

           

          5. Click the button.  You should get the warning "Permanently delete this ENTIRE record?"   Click Cancel.

           

          6. Assuming this file is being hosted, have the limited access user open this same file.  Go to the layout and click the button.  The user should get the same warning message.  If not, then create another user account with a similar privilege set and access the file with this new account.  Try deleting the record again.  Does this work?

           

          Any other information you can provide may be helpful in narrowing down the possible cause(s).

           

          TSGal

          FileMaker, Inc. 

          • 2. Re: Delete Record/Request Script
            philmodjunk
              

            I was tripped up by this one just recently. The "run with full access privileges" is only "full access" for the current file. If your script attempts to modify a field or delete a record in a related file, that file's access privileges now apply. The solution is to create a delete script set to run with full access privileges in the data file and use a perform script in the layout file to run it.

             

            Quoting from Filemaker Help:

            "The Run script with full access privileges feature only functions in the file in which the script is defined. This command will not override access restrictions on external files. For example, a script to delete records in File A that has the Run script with full access privileges option enabled will not delete records in an access-restricted external file File B."