hi
i have a table which generates the next number in a sequence, but i make this number able to be over written by a user as the sequence can sometimes be upset by jobs happening outside the database.
So, a user modifies a number and sets it to 200,000 more than it should be by mistake... now i delete that job but the next number in sequence created by the auto increment column does not see that i have deleted this number.
Is there anyway to reset the auto increment field other than wiping the table and starting again? Meaning, say the number went to 20004 and someone change this to 200004 by mistake, when i delete it i need the next number to be 20005, not 200005.
thanks for all help
Darren
i have a table which generates the next number in a sequence, but i make this number able to be over written by a user as the sequence can sometimes be upset by jobs happening outside the database.
So, a user modifies a number and sets it to 200,000 more than it should be by mistake... now i delete that job but the next number in sequence created by the auto increment column does not see that i have deleted this number.
Is there anyway to reset the auto increment field other than wiping the table and starting again? Meaning, say the number went to 20004 and someone change this to 200004 by mistake, when i delete it i need the next number to be 20005, not 200005.
thanks for all help
Darren