I've got a two file setup that works fine in FIleMaker 6 but fails in
FileMaker 9. The problem seems to be that an external script is not
working in FileMaker 9. By the way, the FIleMaker 9 files are just
converted FileMaker 6 files.

When I click a button in file 1 it evokes an external script in file 2.
Basically, this script makes a query to Oracle (based on a lab number
passed to file 2 from file 1), imports the info from Oracle, builds a
report and takes the user to the Preview mode to view the report.

When the user hits the Continue button, the script pauses and asks if
the user wants to print the report. If they do, the script goes to the
"printout" layout, prints and then deletes all records in file 2 so that
file 2 is now "clean" and ready to build another report when called on
by file 1.

If they hit the default (no) button, file 2 also deletes all the records
in file 2 so that file 2 is now "clean" and ready to build another
report when called on by file 1 (as above).

The last step in this script in file 2 calls a subscript in file 2
called "Go to file 1." Go to file 1 simply calls a script in file 1
called "Go to related record." In other words, the last step is a
subscript that calls an external script in file 1.

For some reason, this last step is not working in FileMaker 9.

If I manually chose the Go to file 1 script from the script menu in file
2 it switches back to file 1 just fine. But when it's included as a
subscript at the end of the report generating script in file 2, it fails.

I seem to recall something about an additional script step needed for
some FileMaker 6 scripts to work correctly in FileMaker 7 and above.
Can someone refresh my memory?

Bill

Well, there can be multiple issues in dealing with Go To Related Record
(GTRR) steps and with external scripts. Make sure you have Select
Window steps in the correct place -- you will likely need to delete one
in one or more of the scripts after a conversion. GTRR steps will no
longer change focus to the related file if there are zero related
records, so you may need to add checks for that, in case the related
file is expecting there to be a correct set to work on.



On 6/17/2010 3:32 PM, William Maslin wrote:

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker Certified Developer
Associate Member, FileMaker Business Alliance

An other point: did you convert the two files simultanious? NOT first one,
then the other. BUT select both files and drag-drop them in one go onto
filemaker.

--
Keep well / Hou je goed

Ursus

"Howard Schlossberg" <howard (AT) nospam (DOT) fmprosolutions.com> schreef in bericht
news:hveqn2$bka$3 (AT) news (DOT) motzarella.org...

In article <hveqn2$bka$3 (AT) news (DOT) motzarella.org>,
Howard Schlossberg <howard (AT) nospam (DOT) fmprosolutions.com> wrote:

Thanks, Howard. I'll see what I can do with the Select Windows and
further investigate GTRR in FMP 9. Strangely, the script will work fine
when I "perform" it from within the Scriptmaker in file 2, i.e., it will
return the user to file 1) but fails at the last step when the script is
invoked from file 1

In article <8a00a$4c1b21af$535399fa$7012 (AT) cache4 (DOT) tilbu1.nb.home.nl>,
"Ursus" <ursus.kirk (AT) ziggo (DOT) nl> wrote:

Thanks, Ursus. The answer to your question is no. Therefore, I
reconverted files 1 & 2 simultaneously as you suggested but the script
still doesn't work.

Bill