August 24, 200916 yr I'm using the Auto-enter serial number for most of my tables, but if I want to abandon an entry, how do I reset the number in code?
August 24, 200916 yr You can change your serial number to only increment on commit and that would get your id "back" because it's never assigned one in the first place. Otherwise you can use the set next serial value script step to set the fields serial number to something different but I wouldn't recommend that approach. What is your goal?
August 25, 200916 yr If the increment on commit is selected, it's possible to get serial numbers out of order. Two users create new records; the second new record gets committed first so it gets the earlier serial number.
Create an account or sign in to comment