setting the start of auto-increment field to the next value
to change the structure of a table I wrote a script to open a table provided with a new structure and import records from the old table then switch the files containing these tables. The problem I am having is to control the auto-increment field to take over from where the one in the old table stops.
Is there a way to do this without manual intrvention.
Take a look at your script steps and functions.
There's a script called Set Next Serial Value. There's a function named: GetNextSerialValue
You can also sort records immediately after importing so that the largest serial value is the first or last record and then you can use that value plus 1 to set the next serial value.