|
THE Problem is that if client1 is editting the record and before ending the system of client1 restarts . So how can other edit that record.(in this solution this record cant be edit for ever....)
|
|
|
|
|
Thats an armageddon scenario.
Why would the system restart?
If it restarts without ending the edit, then the edit would be lost.
You could put a time limit on open edited items, if not processed or closed within, say, 10 minutes, it closes automatically and resets the flag to 0.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC Link[ ^]
Trolls[ ^]
|
|
|
|
|
Yeah, and the flag would never get reset. What he wants just isn't really feasible to do and still have fault tolerance. One possible cause of a "failure" would be if Windows shutdown while the record was 'checked out' for edit.
|
|
|
|
|
Hi everyone,
I'm also facing same kind of problem.
Any help would be appreciate.
|
|
|
|
|
Then read the entire thread and figure out that what you want isn't really possible. You simply have to do research on "database concurrency" and pick the best option that fits your requirements.
|
|
|
|
|
Optimism is a great virtue, but not for a software developer...
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
I would suggest reposting this question in the Database forum; this has very little to do with C#. AFAIK you can lock database records to do what you want; but I don't know the technical details, I expect someone in the Database forum knows the answer.
I must get a clever new signature for 2011.
|
|
|
|
|
Good advice.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC Link[ ^]
Trolls[ ^]
|
|
|
|
|
As Richard suggested, this question suits better in the Database forum.
You can make use of with(rowlock) in your update statement. This will help you avoiding multiple edits on the same row. You can also make use of rowversion to do this. I don't know much about rowversion way but someone in database forum should be able help with this.
|
|
|
|
|
and once you're in the Database forum, have a look at this thread[^]; I think it relates to what you want.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Hi,
look at my Code. In my code DB_Command.Transaction = DB_Connection.BeginTransaction(System.Data.IsolationLevel.Serializable); defines transaction level. It locks(for update/insert) the database until the command is committed. Please never use flags.
public void Execute(string querystring)
{
DB_Command = new OleDbCommand(querystring, DB_Connection);
DB_Command.Transaction = DB_Connection.BeginTransaction(System.Data.IsolationLevel.Serializable);
DB_Command.CommandType = System.Data.CommandType.Text;
int afr=DB_Command.ExecuteNonQuery();
DB_Command.Transaction.Commit();
}
|
|
|
|
|
Thanks for reply.
But no use of these solutions.
|
|
|
|
|
The best solution is to set a flag (with date/time) and check the flag before starting an edit session. If there is a possibility of a client not being able to reset the flag (ex: restart) before completing the edit, run a job in the background to check for flags that are open for the last x mins and reset those flags.
|
|
|
|
|
I want to embed the Power Point Viewer in my Windows Panel Control.
and send slide show on tcp channel
Is ther anyway to do this. Please suggest
Thanks
|
|
|
|
|
this was asked and answered here[^]. Asked by you, answered by me.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
But Luc! That was two days ago, and you didn't come round and update his code for him... 
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
OriginalGriff wrote: That was two days ago
AFAIK my answer still stands. Its sell by date hasn't passed yet.
OriginalGriff wrote: you didn't come round and update his code
His code? I must have missed more than a simple reply, a thank you note, a quest for more information.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
It was a joke - a poor one - I was implying that the OP was expecting you to visit him in person and implement the changes for him.
It's the only reason I could see why he would repeat the question...
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
OriginalGriff wrote: It was a joke
Yeah, I did get it in one.
OriginalGriff wrote: a poor one
not really, it was OK for a Sunday morning.
BTW: did you notice the bad joke levels have dropped significantly in the Lounge?
On a different note: how is the summertime situation in the UK? did you adjust the clocks this weekend? or will you any time soon?
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Yes, the clocks went forward last night, so we lost another hours sleep. With the new cat trying to keep us awake all night for two weeks, we are both feeling a rather tired! You?
Later today I will have to visit my elderly neighbour, and do all her clocks - that'll take about half an hour, since she has quite a few and the only radio-controlled one she keeps in a bedside cabinet drawer "so she can look at it at night".
The bad jokes do appear to have dropped in the lounge - is it a coincidence that DD is on holiday? 
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
OriginalGriff wrote: Yes, the clocks went forward last night
Thanks, here too, so nothing has changed for me getting on line in time for the next CCC...
OriginalGriff wrote: rather tired! You?
I don't need a cat for that, in fact I'm allergic to all fluffy creatures. Our chess team just ended a tough chess competition pretty successfully. Up one league next year!
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Luc Pattyn wrote: Up one league next year
Good for you! Should be harder competition next year...
We are thinking of calling the cat "Shrekie", short for "Schroedingers Wrecking Ball" - if you know where the cat is, you don't know what it is destroying...
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
OriginalGriff wrote: if you <layer>know where the cat is, you don't know what it is destroying...
that is more of a Heisenberg behavior then.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Yes, but he had a silly name when it comes to abbreviating it for cats..."Heisie" doesn't really work
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
hi,
could you please some one tell me when should I use interface? what is it,exactly?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
