-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: sairambab
Message 1 in Discussion
Hi, we are facing the problem with autoincrement number in sql transaction.
This is scenario.Our Application has categories data and having data id and
parent catdata id. (Self Referencing Table) . For First Time , the data set
is added with 5000 records , when it is updating the transaction failed and
there is no code for rollback. the data is not inserted . but auto increment
column will keep the incremented value. catadataid parentcatdatid -1
0 1 -1 2 -1 3
1 4 1 5 1 6
2 7 2 then again the code is executed , again
transaction failed. but this time the data is inserted like this when we
suppress self foriegn key reference. catdataid parencatdatid -1
0 1 -1 2 -1 3 5001 4
5001 5 5001 6 5002 7 5002
.....5000 Again executed the code Again transaction falied. we have
resetted the identity column data base to 1 this time code is inserted like
this catdataid parencatdatid -1 0 1 -1 2
-1 3 10001 4 10001 5
10001 6 10002 7 10002 ....5000 we are thinking
that , since the trnsaction failed , the auto increment column in transaction
is not reset to 1 Please tell me any idea to solve this.. Thanks in Advance
Rambabu
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
