Trouble w/ Constrain Found Set & Get(LastError)

[automator]

Has anyone noticed that when you constrain a found set in FMPro7 and the result is 0, for some reason you are still left with the same found set that you started with?

Also, has anyone had trouble in FMPro7 using the Get(LastError) scripts?

I can't seem to correctly execute in FMPro7 the same scripts that worked fine in FMPro6.

Thanks in advance.

[bruceR]

Yes, that is the new, intentional behavior of FileMaker 7. It makes a lot of sense to not destroy the user's found set but you do have to trap for errors.

[gmmac]

I'm having the same problem with scripted constrain found set, and it doesn't make sense to me that that is FM Pro 7's new intentional behavior. Scripts are intentional! One uses a given step for a reason, and to have inaccurate results is frustrating.

So, that said, do you have an error trapping suggestion?

Thanks if you can!

[n1k0]

The "go to related records" script-step is also tweaked. Set it to "show record using layout BLAH" and "show in new window". If executed where a record has no related records, it neither switches layout nor opens a new window. The only "error trap" I can see is to check if the layout is still the same. Bummer!

[-Queue-]

You can test whether related records exist before performing the step.

If [isEmpty(relationship::serial)]

Show Custom Dialog ["No related records exist..."]

Else

Go to Related Record [relationship]

End If