Click here to Skip to main content
15,434,755 members
Home / Discussions / Database
   

Database

 
GeneralRe: Database Timeout!!!! Pin
__yash__20-Dec-07 0:39
professional__yash__20-Dec-07 0:39 
GeneralRe: Database Timeout!!!! Pin
David Crow20-Dec-07 2:22
MemberDavid Crow20-Dec-07 2:22 
Questionhow to check the already existing data Pin
ShimnaMukundan18-Dec-07 0:02
MemberShimnaMukundan18-Dec-07 0:02 
AnswerRe: how to check the already existing data Pin
Pete O'Hanlon18-Dec-07 0:12
mvaPete O'Hanlon18-Dec-07 0:12 
GeneralRe: how to check the already existing data Pin
ShimnaMukundan18-Dec-07 0:58
MemberShimnaMukundan18-Dec-07 0:58 
QuestionHow can I update databse record on application ending explicitly(power failure) Pin
Gokul Harsh17-Dec-07 22:42
MemberGokul Harsh17-Dec-07 22:42 
AnswerRe: How can I update databse record on application ending explicitly(power failure) Pin
Rocky#17-Dec-07 23:03
MemberRocky#17-Dec-07 23:03 
AnswerRe: How can I update databse record on application ending explicitly(power failure) Pin
Pete O'Hanlon17-Dec-07 23:49
mvaPete O'Hanlon17-Dec-07 23:49 
Gokul Harsh wrote:
HI all,
I have a windows application which runs a process,

I am updating database column "Status" with Processing when the application is running, and on completion I update it with Staus="Completed" or in case I close the application
I update db with Status="Interupted" .

I have problem that in case while proces is running, power supply or system turns off, the db Status="Processing", but in actual it is interupted.
How will i update?


If I were you, I'd use a transaction and two updates to do this. I would update the record to Interrupted and then create a transaction in which I updated the same record to Processing. Then, if the server crashes, once the server restarts the database transaction manager will rollback the uncommitted transactions which would revert the record back to the Interrupted status.

Deja View - the feeling that you've seen this post before.

My blog | My articles



GeneralRe: How can I update databse record on application ending explicitly(power failure) Pin
Rocky#18-Dec-07 0:30
MemberRocky#18-Dec-07 0:30 
GeneralRe: How can I update databse record on application ending explicitly(power failure) Pin
Pete O'Hanlon18-Dec-07 1:16
mvaPete O'Hanlon18-Dec-07 1:16 
GeneralSql2005: How to get the error msg thrown from Storedproc to C# class Pin
kssknov17-Dec-07 19:58
Memberkssknov17-Dec-07 19:58 
GeneralRe: Sql2005: How to get the error msg thrown from Storedproc to C# class Pin
That's Aragon17-Dec-07 21:46
MemberThat's Aragon17-Dec-07 21:46 
QuestionRe: Sql2005: How to get the error msg thrown from Storedproc to C# class Pin
kssknov18-Dec-07 21:02
Memberkssknov18-Dec-07 21:02 
GeneralProblem in writing a stored procedure in SQL SERVER 2000 Pin
Member 305788717-Dec-07 19:41
MemberMember 305788717-Dec-07 19:41 
GeneralRe: Problem in writing a stored procedure in SQL SERVER 2000 Pin
pmarfleet17-Dec-07 21:41
Memberpmarfleet17-Dec-07 21:41 
GeneralQuery regarding SQL Pin
sandhya1417-Dec-07 18:45
Membersandhya1417-Dec-07 18:45 
GeneralRe: Query regarding SQL Pin
That's Aragon17-Dec-07 18:52
MemberThat's Aragon17-Dec-07 18:52 
GeneralRe: Query regarding SQL Pin
sandhya1418-Dec-07 1:05
Membersandhya1418-Dec-07 1:05 
QuestionInsert vs Update Pin
Yusuf17-Dec-07 7:38
MemberYusuf17-Dec-07 7:38 
GeneralRe: Insert vs Update Pin
Colin Angus Mackay17-Dec-07 8:01
MemberColin Angus Mackay17-Dec-07 8:01 
GeneralRe: Insert vs Update Pin
GuyThiebaut17-Dec-07 8:51
professionalGuyThiebaut17-Dec-07 8:51 
QuestionFinding triggers that are disabled or not? Pin
Syed Mujtaba Hassan17-Dec-07 0:29
MemberSyed Mujtaba Hassan17-Dec-07 0:29 
AnswerRe: Finding triggers that are disabled or not? Pin
GuyThiebaut17-Dec-07 0:43
professionalGuyThiebaut17-Dec-07 0:43 
Generalhijri calender with sql server 2005 Pin
Ahmad Adnan16-Dec-07 22:38
MemberAhmad Adnan16-Dec-07 22:38 
GeneralRe: hijri calender with sql server 2005 Pin
GuyThiebaut17-Dec-07 1:30
professionalGuyThiebaut17-Dec-07 1:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.