472,989 Members | 2,992 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,989 software developers and data experts.

Concurrency question

Bob
While testing my my program I came up with a consistency exception. My
program consists of three datagridviews, One called dgvPostes which is the
parent grid and its two children,one called dgvPlans and the other dgvTanks.
What happens is as follows. I will either create or edit a record in the
datagridview dgvPlans and call the Updatedb procedure (code below). The
first save works OK. Then when that is done, on the same record I will try
to edit it and do another UpdateDB. That updatedDB execution will catch a
concurrency exception error. But there is no concurrent use of the database.
I am the only one who is using it and updating the records. The code
structure that I used below is straight out of the Microsoft sample on their
web site. I went back to the dataset designer and changed the properties to
exclude (uncheck) the optimistic concurrency checking when creating the
datatable definitions. Then I tried my code again and I no longer got the
Concurrency exception. From what I see, if you do NOT check the optimistic
concurrency checking there is NO concurrency checking at all. On the other
hand if you do check it, it doesn't seem to work right since the changes
that it caught as concurrency violations were in fact ok.

This is the code snippet of my updatedb method. Can someone please tell me
if I should do something to it to avoid the concurrency exception on the
second edit-save. It occurs on the line
DsPlansEtCheminsPostes.AcceptChanges()

Private Sub UpdateDB()

Me.Validate()

Me.FKReservoirsPostesPostesBindingSource.EndEdit()

Me.FKPostePlansPostesBindingSource.EndEdit()

Me.PostesBindingSource.EndEdit()

'We can only update the database's PostesPlans table and the field that is
bound to the cheminPoste

'in table poste.

'if we had deleted any records in posteplans, find them

Dim deletedChildRecordsPostePlans As
dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Deleted),
dsPlansEtCheminsPostes.PostePlansDataTable)

'We do not need to verify the reservoirsPostes part of this because we can
never change them

'If we had deleted any poste plans, find em

Dim newChildRecords As dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Added),
dsPlansEtCheminsPostes.PostePlansDataTable)

'If we had modified any child records, get them

Dim modifiedChildRecords As dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Modified),
dsPlansEtCheminsPostes.PostePlansDataTable)

Dim modifiedChildRecordsReservoirs As
dsPlansEtCheminsPostes.ReservoirsPostesDataTable = _

CType(DsPlansEtCheminsPostes.ReservoirsPostes.GetC hanges(Data.DataRowState.Modified),
dsPlansEtCheminsPostes.ReservoirsPostesDataTable)

'Note we do not have any possibility of adding or deleting reservoirspostes
records in this application.

'So we don't have to check for new or deleted records, we will only check
for modified records.

Try

If deletedChildRecordsPostePlans IsNot Nothing Then

Me.PostePlansTableAdapter.Update(deletedChildRecor dsPostePlans)

End If

Me.PostesTableAdapter.Update(DsPlansEtCheminsPoste s.Postes)

If newChildRecords IsNot Nothing Then

Me.PostePlansTableAdapter.Update(newChildRecords)

End If

If modifiedChildRecords IsNot Nothing Then

Me.PostePlansTableAdapter.Update(modifiedChildReco rds)

End If

If modifiedChildRecordsReservoirs IsNot Nothing Then

Me.ReservoirsPostesTableAdapter.Update(modifiedChi ldRecordsReservoirs)

End If

DsPlansEtCheminsPostes.AcceptChanges()

Me.Cursor = Cursors.Default

MsgBox(My.Resources.msgSaveOK)

Catch ex As Exception

Me.Cursor = Cursors.Default

EM.HandleException(ex, False, My.Resources.msgNoSave,
My.Resources.msgActionNotPerformed, My.Resources.msgTryAgain)

Finally

Me.Cursor = Cursors.Default

If deletedChildRecordsPostePlans IsNot Nothing Then

deletedChildRecordsPostePlans.Dispose()

End If

If newChildRecords IsNot Nothing Then

newChildRecords.Dispose()

End If

If modifiedChildRecords IsNot Nothing Then

modifiedChildRecords.Dispose()

End If

End Try

End Sub

Thanks for your help,
Bob
Jun 19 '06 #1
4 1525
Bob,

It is so much code, that I cannot really see everything in this message
however the update sequence is in my idea.

Delete Child records
Do parent updates
Do Child added and modified updates.

I thought that is not the sequence you are using.

If you have "on delete cascade" in your database for these than you can even
forgot the first step.

Cor

"Bob" <bd*****@sgiims.com> schreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
While testing my my program I came up with a consistency exception. My
program consists of three datagridviews, One called dgvPostes which is the
parent grid and its two children,one called dgvPlans and the other
dgvTanks.
What happens is as follows. I will either create or edit a record in the
datagridview dgvPlans and call the Updatedb procedure (code below). The
first save works OK. Then when that is done, on the same record I will try
to edit it and do another UpdateDB. That updatedDB execution will catch a
concurrency exception error. But there is no concurrent use of the
database. I am the only one who is using it and updating the records. The
code structure that I used below is straight out of the Microsoft sample
on their web site. I went back to the dataset designer and changed the
properties to exclude (uncheck) the optimistic concurrency checking when
creating the datatable definitions. Then I tried my code again and I no
longer got the Concurrency exception. From what I see, if you do NOT check
the optimistic concurrency checking there is NO concurrency checking at
all. On the other hand if you do check it, it doesn't seem to work right
since the changes that it caught as concurrency violations were in fact
ok.

This is the code snippet of my updatedb method. Can someone please tell me
if I should do something to it to avoid the concurrency exception on the
second edit-save. It occurs on the line
DsPlansEtCheminsPostes.AcceptChanges()

Private Sub UpdateDB()

Me.Validate()

Me.FKReservoirsPostesPostesBindingSource.EndEdit()

Me.FKPostePlansPostesBindingSource.EndEdit()

Me.PostesBindingSource.EndEdit()

'We can only update the database's PostesPlans table and the field that is
bound to the cheminPoste

'in table poste.

'if we had deleted any records in posteplans, find them

Dim deletedChildRecordsPostePlans As
dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Deleted),
dsPlansEtCheminsPostes.PostePlansDataTable)

'We do not need to verify the reservoirsPostes part of this because we can
never change them

'If we had deleted any poste plans, find em

Dim newChildRecords As dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Added),
dsPlansEtCheminsPostes.PostePlansDataTable)

'If we had modified any child records, get them

Dim modifiedChildRecords As dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Modified),
dsPlansEtCheminsPostes.PostePlansDataTable)

Dim modifiedChildRecordsReservoirs As
dsPlansEtCheminsPostes.ReservoirsPostesDataTable = _

CType(DsPlansEtCheminsPostes.ReservoirsPostes.GetC hanges(Data.DataRowState.Modified),
dsPlansEtCheminsPostes.ReservoirsPostesDataTable)

'Note we do not have any possibility of adding or deleting
reservoirspostes records in this application.

'So we don't have to check for new or deleted records, we will only check
for modified records.

Try

If deletedChildRecordsPostePlans IsNot Nothing Then

Me.PostePlansTableAdapter.Update(deletedChildRecor dsPostePlans)

End If

Me.PostesTableAdapter.Update(DsPlansEtCheminsPoste s.Postes)

If newChildRecords IsNot Nothing Then

Me.PostePlansTableAdapter.Update(newChildRecords)

End If

If modifiedChildRecords IsNot Nothing Then

Me.PostePlansTableAdapter.Update(modifiedChildReco rds)

End If

If modifiedChildRecordsReservoirs IsNot Nothing Then

Me.ReservoirsPostesTableAdapter.Update(modifiedChi ldRecordsReservoirs)

End If

DsPlansEtCheminsPostes.AcceptChanges()

Me.Cursor = Cursors.Default

MsgBox(My.Resources.msgSaveOK)

Catch ex As Exception

Me.Cursor = Cursors.Default

EM.HandleException(ex, False, My.Resources.msgNoSave,
My.Resources.msgActionNotPerformed, My.Resources.msgTryAgain)

Finally

Me.Cursor = Cursors.Default

If deletedChildRecordsPostePlans IsNot Nothing Then

deletedChildRecordsPostePlans.Dispose()

End If

If newChildRecords IsNot Nothing Then

newChildRecords.Dispose()

End If

If modifiedChildRecords IsNot Nothing Then

modifiedChildRecords.Dispose()

End If

End Try

End Sub

Thanks for your help,
Bob

Jun 19 '06 #2
Bob
Thanks

"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:Ob**************@TK2MSFTNGP05.phx.gbl...
Bob,

It is so much code, that I cannot really see everything in this message
however the update sequence is in my idea.

Delete Child records
Do parent updates
Do Child added and modified updates.

I thought that is not the sequence you are using.

If you have "on delete cascade" in your database for these than you can
even forgot the first step.

Cor

"Bob" <bd*****@sgiims.com> schreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
While testing my my program I came up with a consistency exception. My
program consists of three datagridviews, One called dgvPostes which is
the parent grid and its two children,one called dgvPlans and the other
dgvTanks.
What happens is as follows. I will either create or edit a record in the
datagridview dgvPlans and call the Updatedb procedure (code below). The
first save works OK. Then when that is done, on the same record I will
try to edit it and do another UpdateDB. That updatedDB execution will
catch a concurrency exception error. But there is no concurrent use of
the database. I am the only one who is using it and updating the records.
The code structure that I used below is straight out of the Microsoft
sample on their web site. I went back to the dataset designer and changed
the properties to exclude (uncheck) the optimistic concurrency checking
when creating the datatable definitions. Then I tried my code again and I
no longer got the Concurrency exception. From what I see, if you do NOT
check the optimistic concurrency checking there is NO concurrency
checking at all. On the other hand if you do check it, it doesn't seem to
work right since the changes that it caught as concurrency violations
were in fact ok.

This is the code snippet of my updatedb method. Can someone please tell
me if I should do something to it to avoid the concurrency exception on
the second edit-save. It occurs on the line
DsPlansEtCheminsPostes.AcceptChanges()

Private Sub UpdateDB()

Me.Validate()

Me.FKReservoirsPostesPostesBindingSource.EndEdit()

Me.FKPostePlansPostesBindingSource.EndEdit()

Me.PostesBindingSource.EndEdit()

'We can only update the database's PostesPlans table and the field that
is bound to the cheminPoste

'in table poste.

'if we had deleted any records in posteplans, find them

Dim deletedChildRecordsPostePlans As
dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Deleted),
dsPlansEtCheminsPostes.PostePlansDataTable)

'We do not need to verify the reservoirsPostes part of this because we
can never change them

'If we had deleted any poste plans, find em

Dim newChildRecords As dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Added),
dsPlansEtCheminsPostes.PostePlansDataTable)

'If we had modified any child records, get them

Dim modifiedChildRecords As dsPlansEtCheminsPostes.PostePlansDataTable =
_

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Modified),
dsPlansEtCheminsPostes.PostePlansDataTable)

Dim modifiedChildRecordsReservoirs As
dsPlansEtCheminsPostes.ReservoirsPostesDataTable = _

CType(DsPlansEtCheminsPostes.ReservoirsPostes.GetC hanges(Data.DataRowState.Modified),
dsPlansEtCheminsPostes.ReservoirsPostesDataTable)

'Note we do not have any possibility of adding or deleting
reservoirspostes records in this application.

'So we don't have to check for new or deleted records, we will only check
for modified records.

Try

If deletedChildRecordsPostePlans IsNot Nothing Then

Me.PostePlansTableAdapter.Update(deletedChildRecor dsPostePlans)

End If

Me.PostesTableAdapter.Update(DsPlansEtCheminsPoste s.Postes)

If newChildRecords IsNot Nothing Then

Me.PostePlansTableAdapter.Update(newChildRecords)

End If

If modifiedChildRecords IsNot Nothing Then

Me.PostePlansTableAdapter.Update(modifiedChildReco rds)

End If

If modifiedChildRecordsReservoirs IsNot Nothing Then

Me.ReservoirsPostesTableAdapter.Update(modifiedChi ldRecordsReservoirs)

End If

DsPlansEtCheminsPostes.AcceptChanges()

Me.Cursor = Cursors.Default

MsgBox(My.Resources.msgSaveOK)

Catch ex As Exception

Me.Cursor = Cursors.Default

EM.HandleException(ex, False, My.Resources.msgNoSave,
My.Resources.msgActionNotPerformed, My.Resources.msgTryAgain)

Finally

Me.Cursor = Cursors.Default

If deletedChildRecordsPostePlans IsNot Nothing Then

deletedChildRecordsPostePlans.Dispose()

End If

If newChildRecords IsNot Nothing Then

newChildRecords.Dispose()

End If

If modifiedChildRecords IsNot Nothing Then

modifiedChildRecords.Dispose()

End If

End Try

End Sub

Thanks for your help,
Bob


Jun 19 '06 #3
Bob
Just looked at my code again. Thats exactly the sequnce that I'm using, so
why the concurrency problem?
Regards,
Bob
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:Ob**************@TK2MSFTNGP05.phx.gbl...
Bob,

It is so much code, that I cannot really see everything in this message
however the update sequence is in my idea.

Delete Child records
Do parent updates
Do Child added and modified updates.

I thought that is not the sequence you are using.

If you have "on delete cascade" in your database for these than you can
even forgot the first step.

Cor

"Bob" <bd*****@sgiims.com> schreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
While testing my my program I came up with a consistency exception. My
program consists of three datagridviews, One called dgvPostes which is
the parent grid and its two children,one called dgvPlans and the other
dgvTanks.
What happens is as follows. I will either create or edit a record in the
datagridview dgvPlans and call the Updatedb procedure (code below). The
first save works OK. Then when that is done, on the same record I will
try to edit it and do another UpdateDB. That updatedDB execution will
catch a concurrency exception error. But there is no concurrent use of
the database. I am the only one who is using it and updating the records.
The code structure that I used below is straight out of the Microsoft
sample on their web site. I went back to the dataset designer and changed
the properties to exclude (uncheck) the optimistic concurrency checking
when creating the datatable definitions. Then I tried my code again and I
no longer got the Concurrency exception. From what I see, if you do NOT
check the optimistic concurrency checking there is NO concurrency
checking at all. On the other hand if you do check it, it doesn't seem to
work right since the changes that it caught as concurrency violations
were in fact ok.

This is the code snippet of my updatedb method. Can someone please tell
me if I should do something to it to avoid the concurrency exception on
the second edit-save. It occurs on the line
DsPlansEtCheminsPostes.AcceptChanges()

Private Sub UpdateDB()

Me.Validate()

Me.FKReservoirsPostesPostesBindingSource.EndEdit()

Me.FKPostePlansPostesBindingSource.EndEdit()

Me.PostesBindingSource.EndEdit()

'We can only update the database's PostesPlans table and the field that
is bound to the cheminPoste

'in table poste.

'if we had deleted any records in posteplans, find them

Dim deletedChildRecordsPostePlans As
dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Deleted),
dsPlansEtCheminsPostes.PostePlansDataTable)

'We do not need to verify the reservoirsPostes part of this because we
can never change them

'If we had deleted any poste plans, find em

Dim newChildRecords As dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Added),
dsPlansEtCheminsPostes.PostePlansDataTable)

'If we had modified any child records, get them

Dim modifiedChildRecords As dsPlansEtCheminsPostes.PostePlansDataTable =
_

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Modified),
dsPlansEtCheminsPostes.PostePlansDataTable)

Dim modifiedChildRecordsReservoirs As
dsPlansEtCheminsPostes.ReservoirsPostesDataTable = _

CType(DsPlansEtCheminsPostes.ReservoirsPostes.GetC hanges(Data.DataRowState.Modified),
dsPlansEtCheminsPostes.ReservoirsPostesDataTable)

'Note we do not have any possibility of adding or deleting
reservoirspostes records in this application.

'So we don't have to check for new or deleted records, we will only check
for modified records.

Try

If deletedChildRecordsPostePlans IsNot Nothing Then

Me.PostePlansTableAdapter.Update(deletedChildRecor dsPostePlans)

End If

Me.PostesTableAdapter.Update(DsPlansEtCheminsPoste s.Postes)

If newChildRecords IsNot Nothing Then

Me.PostePlansTableAdapter.Update(newChildRecords)

End If

If modifiedChildRecords IsNot Nothing Then

Me.PostePlansTableAdapter.Update(modifiedChildReco rds)

End If

If modifiedChildRecordsReservoirs IsNot Nothing Then

Me.ReservoirsPostesTableAdapter.Update(modifiedChi ldRecordsReservoirs)

End If

DsPlansEtCheminsPostes.AcceptChanges()

Me.Cursor = Cursors.Default

MsgBox(My.Resources.msgSaveOK)

Catch ex As Exception

Me.Cursor = Cursors.Default

EM.HandleException(ex, False, My.Resources.msgNoSave,
My.Resources.msgActionNotPerformed, My.Resources.msgTryAgain)

Finally

Me.Cursor = Cursors.Default

If deletedChildRecordsPostePlans IsNot Nothing Then

deletedChildRecordsPostePlans.Dispose()

End If

If newChildRecords IsNot Nothing Then

newChildRecords.Dispose()

End If

If modifiedChildRecords IsNot Nothing Then

modifiedChildRecords.Dispose()

End If

End Try

End Sub

Thanks for your help,
Bob


Jun 22 '06 #4
Bob,

And you are sure that the rowstate of the deleted child records that should
go with the deleted parents is set (Or your database has on delete cascade
on the key of that?)

Cor
..
"Bob" <bd*****@sgiims.com> schreef in bericht
news:Op**************@TK2MSFTNGP05.phx.gbl...
Just looked at my code again. Thats exactly the sequnce that I'm using, so
why the concurrency problem?
Regards,
Bob
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:Ob**************@TK2MSFTNGP05.phx.gbl...
Bob,

It is so much code, that I cannot really see everything in this message
however the update sequence is in my idea.

Delete Child records
Do parent updates
Do Child added and modified updates.

I thought that is not the sequence you are using.

If you have "on delete cascade" in your database for these than you can
even forgot the first step.

Cor

"Bob" <bd*****@sgiims.com> schreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
While testing my my program I came up with a consistency exception. My
program consists of three datagridviews, One called dgvPostes which is
the parent grid and its two children,one called dgvPlans and the other
dgvTanks.
What happens is as follows. I will either create or edit a record in the
datagridview dgvPlans and call the Updatedb procedure (code below). The
first save works OK. Then when that is done, on the same record I will
try to edit it and do another UpdateDB. That updatedDB execution will
catch a concurrency exception error. But there is no concurrent use of
the database. I am the only one who is using it and updating the
records. The code structure that I used below is straight out of the
Microsoft sample on their web site. I went back to the dataset designer
and changed the properties to exclude (uncheck) the optimistic
concurrency checking when creating the datatable definitions. Then I
tried my code again and I no longer got the Concurrency exception. From
what I see, if you do NOT check the optimistic concurrency checking
there is NO concurrency checking at all. On the other hand if you do
check it, it doesn't seem to work right since the changes that it caught
as concurrency violations were in fact ok.

This is the code snippet of my updatedb method. Can someone please tell
me if I should do something to it to avoid the concurrency exception on
the second edit-save. It occurs on the line
DsPlansEtCheminsPostes.AcceptChanges()

Private Sub UpdateDB()

Me.Validate()

Me.FKReservoirsPostesPostesBindingSource.EndEdit()

Me.FKPostePlansPostesBindingSource.EndEdit()

Me.PostesBindingSource.EndEdit()

'We can only update the database's PostesPlans table and the field that
is bound to the cheminPoste

'in table poste.

'if we had deleted any records in posteplans, find them

Dim deletedChildRecordsPostePlans As
dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Deleted),
dsPlansEtCheminsPostes.PostePlansDataTable)

'We do not need to verify the reservoirsPostes part of this because we
can never change them

'If we had deleted any poste plans, find em

Dim newChildRecords As dsPlansEtCheminsPostes.PostePlansDataTable = _

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Added),
dsPlansEtCheminsPostes.PostePlansDataTable)

'If we had modified any child records, get them

Dim modifiedChildRecords As dsPlansEtCheminsPostes.PostePlansDataTable =
_

CType(DsPlansEtCheminsPostes.PostePlans.GetChanges (Data.DataRowState.Modified),
dsPlansEtCheminsPostes.PostePlansDataTable)

Dim modifiedChildRecordsReservoirs As
dsPlansEtCheminsPostes.ReservoirsPostesDataTable = _

CType(DsPlansEtCheminsPostes.ReservoirsPostes.GetC hanges(Data.DataRowState.Modified),
dsPlansEtCheminsPostes.ReservoirsPostesDataTable)

'Note we do not have any possibility of adding or deleting
reservoirspostes records in this application.

'So we don't have to check for new or deleted records, we will only
check for modified records.

Try

If deletedChildRecordsPostePlans IsNot Nothing Then

Me.PostePlansTableAdapter.Update(deletedChildRecor dsPostePlans)

End If

Me.PostesTableAdapter.Update(DsPlansEtCheminsPoste s.Postes)

If newChildRecords IsNot Nothing Then

Me.PostePlansTableAdapter.Update(newChildRecords)

End If

If modifiedChildRecords IsNot Nothing Then

Me.PostePlansTableAdapter.Update(modifiedChildReco rds)

End If

If modifiedChildRecordsReservoirs IsNot Nothing Then

Me.ReservoirsPostesTableAdapter.Update(modifiedChi ldRecordsReservoirs)

End If

DsPlansEtCheminsPostes.AcceptChanges()

Me.Cursor = Cursors.Default

MsgBox(My.Resources.msgSaveOK)

Catch ex As Exception

Me.Cursor = Cursors.Default

EM.HandleException(ex, False, My.Resources.msgNoSave,
My.Resources.msgActionNotPerformed, My.Resources.msgTryAgain)

Finally

Me.Cursor = Cursors.Default

If deletedChildRecordsPostePlans IsNot Nothing Then

deletedChildRecordsPostePlans.Dispose()

End If

If newChildRecords IsNot Nothing Then

newChildRecords.Dispose()

End If

If modifiedChildRecords IsNot Nothing Then

modifiedChildRecords.Dispose()

End If

End Try

End Sub

Thanks for your help,
Bob



Jun 23 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
by: aurora | last post by:
Hello! Just gone though an article via Slashdot titled "The Free Lunch Is Over: A Fundamental Turn Toward Concurrency in Software" http://www.gotw.ca/publications/concurrency-ddj.htm]. It argues...
2
by: Robin Tucker | last post by:
With respect to my (now not so recent) thread on Concurrency, I would like to run my idea past you gurus to see if its a runner. First, a brief recap: I have a single user system (one user, one...
3
by: Karl | last post by:
Hi .NET experts, I was a 2 tier database programmer using delphi. In Delphi, if user A is writting a record, this record is locked from user B for writting. If user A insert a new record, when...
2
by: John | last post by:
In 'Data Adapter Configuration Wizard' for OleDbDataAdapter, there's a checkbox called 'Use optimistic concurrency' that allows to turn on/off the option. I don't use the wizard, I create...
7
by: William E Voorhees | last post by:
I'm updating an Access database in a windows multi-user environment. I'm using disconnected data I read data from an Access Data table to a data object I update the data object from a...
3
by: John | last post by:
Hi I have a vs 2003 winform data app. All the data access code has been generated using the data adapter wizard and then pasted into the app. The problem I have is that I am getting a data...
1
by: =?Utf-8?B?Qi4gQ2hlcm5pY2s=?= | last post by:
(If I'm overlooking anything, please let me know.) First, my only concern is updating single records in a Detailsview using an ObjectDataSource. The target table has a timestamp field. Assume ...
5
by: John | last post by:
Hi I have developed the following logic to handle db concurrency violations. I just wonder if someone can tell me if it is correct or if I need a different approach.Would love to know how pros...
1
by: Henri.Chinasque | last post by:
Hi all, I've been considering that my objects should subscribe to an event via a weak reference, however I've found several warnings that this approach comes with concurrency considerations,...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
3
SueHopson
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.