Auto Increment Problem

[vaniKanabathy]

Hi , i had a problem where if i delete 1 row manually , the next auto increment field do not follows the last one in database where by it continue with the auto no of i deleted one. like if the last record is 847 and i delete the record so now the last 1 should b 846 and when i insert 1 data via system it should be 847 but it being 848. please help me.

[missinglinq]

What code are you using to generate your auto incrementing field?

Welcome to bytes!

Linq ;0)>

[mshmyob]

If you mean you have an autonumber field then it is doing what it is supposed to do. Deleting an autonumber field does not allow you to reuse the number once it has been used even if you delete it.

If you are creating the incrementation by code then you would need to post it.

cheers,

Hi , i had a problem where if i delete 1 row manually , the next auto increment field do not follows the last one in database where by it continue with the auto no of i deleted one. like if the last record is 847 and i delete the record so now the last 1 should b 846 and when i insert 1 data via system it should be 847 but it being 848. please help me.