Click here to Skip to main content
15,867,978 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am using SQL Server 2005 as back end and asp.net as front end. In my project i have a critical issue. i will explain this issue as brief .

I have a table in sql, the table have three coulmn. one for amount ,one for a status flag and one primary key. during the initial transaction of a day the first insertion will occur, that is ok. At the end of the day the approval autority approve the transaction with a new updated amount and a new approval flag. Sometimes this amount or flag will lose. This will occur very rare in a year, but this issue is very critical, it will stop the next day works.

This is my issue, any one face this type of problem and any one know the reason for this type of updation missing problem, then inform me.
Posted
Updated 20-Dec-11 22:43pm
v2
Comments
Pete O'Hanlon 20-Dec-11 3:38am    
What do you mean by the amount or flag will lose? Lose what? I'm sorry, but while your question is mostly clear, I just can't get my head around that bit.
Elk Cloner 25-Dec-11 22:26pm    
insert into Table1(Slno,Amount,Flag) values(15,250,'N') this is the code from transaction page.
At the end of the day the statement from approval page is like this
Update Table1 set Amount=3500,Flag='A' where Slno=15 in this statement sometimes the updation to the Amount field or Flag field is lost. please not that this lost may happen only one or two times in six months.
OriginalGriff 20-Dec-11 3:45am    
WE can't really tell from just that - we need to know how you are doing this. Show us the relevant code fragments for your first insertion (and it's check code) and the update. It would also help to know what kind of environment the SQL server is working in - single PC? Farmed?
Use the "Improve question" widget to edit your question and provide better information.
Elk Cloner 25-Dec-11 22:24pm    
insert into Table1(Slno,Amount,Flag) values(15,250,'N') this is the code from transaction page.
At the end of the day the statement from approval page is like this
Update Table1 set Amount=3500,Flag='A' where Slno=15 in this statement sometimes the updation to the Amount field or Flag field is lost. please not that this lost may happen only one or two times in six months.
Dylan Morley 20-Dec-11 4:09am    
Moved comment from D Anil Kumar:

can you show me the sample code which you have written.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900