Error 101 keeps happening and I can't seem to trab it...???

Followers

June 17, 201015 yr

I've got a simple script setup in FileMaker that's moving between two different layouts (one of which is a MySQL data source) to sync the data between the two. Basically pulling data from MySQL, then checking to see if that same records exists in Filemaker, and if not, delete it out of MySQL. Here's the script I'm working with...

As you can see I'm simply looping through a found set of records and I've got Go to Next Record (Exit After Last) set a the end of the loop.

Well, I keep getting a 101 Error - Record is Missing on that very last record when it attempts to go to the next record (which doesn't exist). I've never had this issue before as the Exit After Last generally handles it for me.

Any information about what I'm doing wrong here would be grealty appreciated. thanks!

June 18, 201015 yr

This is normal behaviour: the "exit after last" option actually generates an error and pops up the script debugger if the "pause on error" option is enabled.