Script Scope, and data subset....

[NickFaraday]

Dose anyone know what the "scope" of a script run in FM is?

Ex: I have a script that builds a many to many link table.

I have a subset of a table that I get by performing a find in the script.

I then loop though and build the link table with a goto "link table" command and set the appropriate fields.

My question is do I need to preform the find of data each time I return to that layout.

Go to layout 1

Preform Subset Find

Loop

Go To Table Layout A

Get Unique Id A

Go To Table Layout B

Preform Find

Get Unique Id B

Go To Table Layout C

Preform Find

Get Unique Id C

Go To Link layout

Set Links

Go To Layout 1 *will this take me to the same subset?

Next

End Loop

If there are multiple users running the script will the subset be kept per user?

[Ender]

Each table occurrence keeps its own found set, and that found set is the same across all the layouts that use that table occurrence. This is the same in multi-user environments (the found sets are local to each).

I'd wager that there's a more efficient algorithm to do what you need, but your pseudocode is not specific enough for me to suggest something.

[Fenton]

I'd agree with Ender, the info is a little vague. Table 1, Table A, Table B; these all sound like different tables, but we can't really be sure. If they are, it all looks (kind of) like it would work, and you should still be on the same record when you return to Layout 1.

But one has to wonder what the Finds are, where's that criteria coming from, and why, since it's using the same criteria in different tables? You say "get unique ID B", but you've just done a Find. How do you know it's only found 1 record? Or are you planning on capturing all the IDs you found?

BTW, each window maintains its own found sets. A new window will have the same as its "parent", but will not stay synched if its found sets are altered.

[Ender]

BTW, each window maintains its own found sets. A new window will have the same as its "parent", but will not stay synched if its found sets are altered.

Ooh, good catch, Fenton. Maybe it's my aversion to MS Windows; makes me forget about FileMaker's Windows. :