Open file script fails after user Cancels

[Lynn Johnson]

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

[Ano Nimus]

Allow user abort: off ?

[Lynn Johnson]

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.

[-Queue-]

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.

[Vaughan]

"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.

[Lynn Johnson]

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.

[Vaughan]

Hmmm... FMP 7.... it may well be another "difference" between FMP 7 and FMP 6. Or a bug.

[Storm Cellar]

I have a similar problem. When the user hits the ESCAPE key, the entire script is exited. Allow User Abort (Off) doesn't stop it! I'm using FM7 v3