db name:-mydatabase
table name:-login
coulms:-id(int,identityspecification-yes,identity increment=1,identity seed=1)
username(varchar 50, primarykey)
password(varchar 50)

now when I'm trying to insert, theres no problem if the record is not available.
but problem occurs when a record already exists.

id |username|password
1 | biswa | bitan
2 | hoity | toity
[now if I try to enter username=biswa and password=bitan
and the error handler produce an error message and stop
data insertion. if 2 attempts stopped by error handler. then
when I try for a new data, it looks like...]

5 | jack | jill

m really in problem....I need to increment the id when a valid insertion is done
please help me out....


thanks

__________________
Get the will power n U will be powered

So fix your code. Don't even *TRY* to do the INSERT if the record already exists.

Don't depend on the error handler. Write the code to do the check first.

A stored procedure would be the best way, but you could also just use ad hoc SQL.