Hello,
 I have a table filled with data and i change the "recordid" to be generated by EDB. (i previously made my own generated integer keys)
 Now if i append a record i get a "duplicate key" error "0" so i have to repair the table in order EDB to fix the LastAutoInc value. (My point is that EDB should Set the correct LastAutoInc value when altering the field)

Thank you
 

Hello,

If the column is populated with the old integer values, you have to tell EDB where to start from now on :

ALTER TABLE <TableName> ALTER COLUMN <ColumnName> RESTART WITH <SeedValue>

--
Fernando Dias
[Team Elevate]

Fernando,

<< If the column is populated with the old integer values, you have to tell EDB where to start from now on :

ALTER TABLE <TableName> ALTER COLUMN <ColumnName> RESTART WITH <SeedValue> >>

Well, my point was EDB should do that automatically.

Thank you

On 9/9/2018 3:43 AM, Charalampos Michael wrote:
> Well, my point was EDB should do that automatically.

I disagree - otherwise one could not do alter without resetting seed
value each time.

Raul

Michael,

<< I have a table filled with data and i change the "recordid" to be generated by EDB. (i previously made my own generated integer keys)
 Now if i append a record i get a "duplicate key" error "0" so i have to repair the table in order EDB to fix the LastAutoInc value. (My point is that EDB should Set the correct LastAutoInc value when altering the field) >>

This FAQ explains the rationale for why it works the way that it does:

https://www.elevatesoft.com/supportfaq?action=view&category=edb&question=altering_identity_seed_value

Tim Young
Elevate Software
www.elevatesoft.com