There used to be a way to change the auto increment value of a table by right clicking on the table and selecting Alter Table.
I see this is now in Maintenance/Table Tools in the Bulk table editor tab.
When clicking on the Checkbox for Reset Auto Increment Value, the update button does not become available. I had a quick look at the source code - forgive me please if i'm way off, I know nothing about pascal, but it seems that a call to chkBulkTableEditCheckComboClick onClick might be missing for that check box, around line 446 in tabletools.dfm
thanks! and is there a plan to include a way to set the auto increment value to something other than 0 like used to be possible?
thanks again!
k.
Reset Auto Increment Value
I found a way to reset the auto increment for tables in version 7.0.0.453.
Right mouse click on a table > Maintenance > Bulk Table editor. You'll notice checking the 'Reset auto increment value' check box doesn't active the 'Update' button at the bottom of the box. If you check the 'Move to database' check box for example, the update button becomes active. Un-check the 'Move to database' check box again and the update button remains active for 'Reset auto increment value' and it will now allow you to reset the table auto increment.
Do this for all your tables you want to reset.
Right mouse click on a table > Maintenance > Bulk Table editor. You'll notice checking the 'Reset auto increment value' check box doesn't active the 'Update' button at the bottom of the box. If you check the 'Move to database' check box for example, the update button becomes active. Un-check the 'Move to database' check box again and the update button remains active for 'Reset auto increment value' and it will now allow you to reset the table auto increment.
Do this for all your tables you want to reset.
Please login to leave a reply, or register at first.