Revert to original found set

[mswscco]

I'm trying to script a constrain that returns the original found set in case no matches are found. With the native Filemaker search, I know clicking on "Cancel" will return you to the previously shown records. With a scripted search, however, I get taken to a screen with no records. I'm using custom dialog boxes and capturing find errors. Thanks!

[bruceR]

See the example file for "Techniques for preserving, restoring and transferring found sets" in the 8/16/05 presentation here:

http://www.kevinfrank.com/demo-files-user-group.html

The idea is that you can have separate table occurrences for saved sets. You use GTRR to hold/restore the found set.

For small record sets there are other methods that capture all the record ID values.

We also have the new snapshot link feature in FileMaker 11 but it requires an external file, it is really too bad it is not natively scriptable.

[bruceR]

Also see this file, it is a demo of several techniques, one of which is accumulating record ID values by doing a replace on a global field. This is suitable for modest records sets.

CFReportingSAV.fp7.zip

[mswscco]

Thanks for the examples. I'll do some experimenting.

[mswscco]

Well, what I ended up doing is just scripting the constrain to search in a new window. Close the new window if the search is invalid and close the old window if the search is true. Seems to work okay for now.