I've noticed that when I repair a table that has a column with autoinc value
( generated, always ) that the value used in next insert is the seed value
and  this starts to increment again resulting in duplicate values.  Is this
the expected behavior?  Is there a better way to generate a unique  value
for each column.
thanks
randy

Randy,

<< I've noticed that when I repair a table that has a column with autoinc
value ( generated, always ) that the value used in next insert is the seed
value and  this starts to increment again resulting in duplicate values.  Is
this the expected behavior?  Is there a better way to generate a unique
value for each column. >>

I'll have to look further into this.  If it is an issue, then I will fix it
for the next 1.07 build.

--
Tim Young
Elevate Software
www.elevatesoft.com