Scripts disappear from script menu...

[Jeep Watson]

I've been developing FM databases since v3 and have never encountered this - wondering if anyone else has seen it or has an idea what's going on. I have 2 simple scripts - one to backup a database and another to restore from the backup. The Backup works fine - no anomalies. But when I restore, the scripts that are set to show in the scripts menu disappear from the menu. The scripts still work fine if invoked by clicking on a button but are gone from the menu and their associated quickeys also fail. If I open Scriptmaker and close it, the scripts reappear and the quickeys work again also???

There are 2 files in the solution related by Customer ID. I restore the Customer database first - the script 1) Shows all records, 2) Deletes all records and 3) imports all from the backup. When it deletes all records, it empties the the related file (called Services) since those records are set to delete when the master record is deleted. Then I run a script that calls a script in Services that imports all the data from it's backup.

I've tried placing all sorts of script steps at the end of the original script in Customers to try to make something happen but nothing seems to work. I noticed that if I call the Backup script again, that DOES restore the menu - just seems a little inelegant. Seeing that I tried one thing that DID work but is unnacceptable for the end user - I initiated an EXPORT of records and cancelled out of the ensuing file dialog box. I can't ask the end user to do that just to recover keyboard shortcuts. The shortcuts aren't even that important (Command 1,2,3 & 4 to navigate to layouts) since there are tabbed buttons on all layouts to accomplish the same thing. It just bugs me that it's happening. Any ideas?

[Lee Smith]

This sounds like corruption. If it were me, I would import the data into some clean backups before they fail.

Lee

[transpower]

You could run FileMaker Recovery on the files and see what happens...

[Jeep Watson]

I dunno Lee, it doesn't feel like corruption - only 9 records (it's in development) and I have tried recoveries to no avail - AND, I can reliably and repeatedly restore the Scipts in the Script Menu every time simply by re-running the Backup script.

Seems that it is more likely a bug or something I'm implementing incorrectly, OR a conflict with something else I'm running (I use QuicKeys and haven't tried isolating it yet). I was curious if anyone else had encountered similar behavior.

[Lee Smith]

I have the v6 and OS 9.2 (the sound of knocking on wood, and then the dreaded words), and haven't had this happen to me. In fact, I have found version 6 to be pretty stable (Bug Wise). Could this have something to do with OS X, memory allocation, etc?.

Since you are still in development, why not post the files and let others try and recreate your situation (Striped of any confidential data of course). I'll be happy to give it a try, or feel free to send them to me back channel at:

[email protected]

[Jeep Watson]

Thanks Lee, I'll post the files (they're small). I'd be curious to see if the behavior persists in OS9. I'll try Win XP early this coming week at my client's place and I have Win 2000 running on a few machines at work that I can test.

[Lee Smith]

Okay, want to make sure I'm doing this the same way.

Not sure of what to do, so I check two files on the List View, then:

I went to Maintenance layout and hit the Backup button. It appeared to work (not sure what to look for). Scripts in the Menu are still there.

Then Hit the Restore Button, and it seem to do something. Then I looked at the Scripts and the were there.

My feeling is that this is a OSX problem.

Lee

[Jeep Watson]

Thanks Lee - that confirms that it's probably something in my setup. I'll be back at work tomorrow and will try it in several versions and platforms. I still suspect QuicKeys (though it's a HUGE production time saver).

[Lee Smith]

Maybe it has something to do with Quickeys? I thought that Quickeys didn't work in OSX?

Lee