Open file script fails after user Cancels

May 5, 200421 yr

The script Opens a file. If the user hits the Cancel button during the log-in, the script will never open that file again until the database file containing the script is closed and reopened. The FileMaker application does not have to be restarted.

I have tried Get(Last Error). It returns the error, but does not "reset" whatever is going on.

Any suggestions?

Lynn

May 5, 200421 yr

Allow user abort: off ?

May 5, 200421 yr

Author

I have tried it with Allow user abort on and off and without Allow user abort in the script. Works the same in all cases.

May 5, 200421 yr

If you have Allow User Abort [Off] before the call to open the external file, a user should not be able to click any Cancel button, because only Continue would exist. If you Hide and Lock the status area, neither button will be accessible, by the way.

May 5, 200421 yr

"the script will never open that file again until the database file containing the script is closed and reopened"

You should only have to perform the script again, not have to close the file. If the script is run when the file opens and there is no other way for the user to perform the script, then it's an interface/design issue.

Maybe if the user cancels the script change to a layout with a big button on it "Try Again" that performs the open script.

May 6, 200421 yr

Author

Maybe I was not clear in my original post.

The script runs when the file (file A) opens.

Set Error Capture [On]

Open File ["Vendor File"]

If [Get ( LastError ) <> 0]

{corrective Action goes here}

When the Open file step executes, the user is asked for Account and Password for the Vendor File.

If the user hits Cancel in the log-in dialog (NOT the Cancel Script button), Get ( LastError) returns 1.

Re-running the script does not open the Vendor File or give a log-in dialog. I have to close file A (containing the script) and reopen it before the script will attempt to re-open the Vendor File.