I forgot to mention... this worked perfectly fine (and still does) in FMP11.
I can't reproduce this on WIndows Xp with FMP 12.
I defined a brand new test file with an auto-entered serial number field.
Created 7 records
Ran a one line script that used set next serial value to set it back to 1.
Opened Manage | database and checked the settings on the field.
Next serial value was 1 as expected and a new record was automatically numbered 1 in this field.
Perhaps this is a Mac only bug or perhaps you should take a closer look at your script.
Hello r p:
Thank you for posting.
I am also unable to reproduce this behavior on Mac OS X Lion. If possible, I would like to review a copy of your file.
Check your inbox at the top of this page for instructions on how to submit your file for review.