Concurrency Troubles using Access as Database '?' Appear in SQL

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C4DC3C.8D141AB0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,

I am using access as the main DB for an application.

Whenever I try to update the DB by my Dataset I get Exception below.

--------------
An unhandled exception of type 'System.Data.DBConcurrencyException'
occurred in system.data.dll

Additional information: Concurrency violation: the DeleteCommand
affected 0 records.
--------------

What worries me is the "?" in the SQL below of the Update Command? Is
this normal?
I just cannot get my head around the "?"

All the code below was generated by Visual Studio.

Do I have to modify this or am I doing something Wrong?

Thanks in Advance.

'OleDbUpdateCommand1

'

Me.OleDbUpdateCommand1.CommandText = "UPDATE Reminders SET ReminderDate
= ?, ReminderTime = ?, Route = ? WHERE (EventID" & _

" = ?) AND (ReminderDate = ? OR ? IS NULL AND ReminderDate IS NULL) AND
(Reminder" & _

"Time = ? OR ? IS NULL AND ReminderTime IS NULL) AND (Route = ? OR ? IS
NULL AND " & _

"Route IS NULL)"

Me.OleDbUpdateCommand1.Connection = Me.OleDbConnection

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("ReminderDate",
System.Data.OleDb.OleDbType.DBDate, 0, "ReminderDate"))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("ReminderTime",
System.Data.OleDb.OleDbType.DBDate, 0, "ReminderTime"))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Route",
System.Data.OleDb.OleDbType.VarWChar, 50, "Route"))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_EventID",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "EventID", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_ReminderDate",
System.Data.OleDb.OleDbType.DBDate, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ReminderDate", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_ReminderDate1",
System.Data.OleDb.OleDbType.DBDate, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ReminderDate", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_ReminderTime",
System.Data.OleDb.OleDbType.DBDate, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ReminderTime", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_ReminderTime1",
System.Data.OleDb.OleDbType.DBDate, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ReminderTime", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Route",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Route", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Route1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Route", System.Data.DataRowVersion.Original, Nothing))

'

------=_NextPart_000_0000_01C4DC3C.8D141AB0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN=20
class=3D486520223-06122004>Hi,</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>I am =
using access as=20
the main DB for an application.</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>Whenever I try to=20
update the DB by my Dataset I get Exception below.</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV><SPAN=20
class=3D486520223-06122004>--------------</DIV>
<DIV>An =
unhandled=20
exception of type 'System.Data.DBConcurrencyException' occurred in=20
system.data.dll</DIV>
<DIV> </DIV>
<DIV>Additional=20
information: Concurrency violation: the DeleteCommand affected 0=20
records.</DIV>
<DIV><SPAN=20
class=3D486520223-06122004>--------------</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>What =
worries me is=20
the "?" in the SQL below of the Update Command?  Is this=20
normal?</DIV>
<DIV>I just =
cannot get my=20
head around the "?"</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>All =
the code below=20
was generated by Visual Studio.</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>Do I =
have to modify=20
this or am I doing something Wrong?</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>Thanks =
in=20
Advance.</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV> </DIV>
<DIV>
'OleDbUpdateCommand1<FONT=20
size=3D2>
'
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.CommandText =3D "UPDATE Reminders SET =
ReminderDate =3D=20
?, ReminderTime =3D ?, Route =3D ? WHERE (EventID" & _
" =3D ?) AND (ReminderDate =3D ? OR ? IS NULL AND ReminderDate IS =
NULL) AND=20
(Reminder" & _
"Time =3D ? OR ? IS NULL AND ReminderTime IS NULL) AND (Route =3D ? =
OR ? IS NULL=20
AND " & _
"Route IS NULL)"
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Connection =3D Me.OleDbConnection
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New =
System.Data.OleDb.OleDbParameter("ReminderDate",=20
System.Data.OleDb.OleDbType.DBDate, 0, "ReminderDate"))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New =
System.Data.OleDb.OleDbParameter("ReminderTime",=20
System.Data.OleDb.OleDbType.DBDate, 0, "ReminderTime"))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New =
System.Data.OleDb.OleDbParameter("Route",=20
System.Data.OleDb.OleDbType.VarWChar, 50, "Route"))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_EventID",=20
System.Data.OleDb.OleDbType.Integer, 0, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "EventID",=20
System.Data.DataRowVersion.Original, Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_ReminderDate",=20
System.Data.OleDb.OleDbType.DBDate, 0, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderDate",=20
System.Data.DataRowVersion.Original, Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_ReminderDate1",=20
System.Data.OleDb.OleDbType.DBDate, 0, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderDate",=20
System.Data.DataRowVersion.Original, Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_ReminderTime",=20
System.Data.OleDb.OleDbType.DBDate, 0, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderTime",=20
System.Data.DataRowVersion.Original, Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_ReminderTime1",=20
System.Data.OleDb.OleDbType.DBDate, 0, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderTime",=20
System.Data.DataRowVersion.Original, Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_Route",=20
System.Data.OleDb.OleDbType.VarWChar, 50, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "Route", =
System.Data.DataRowVersion.Original,=20
Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_Route1",=20
System.Data.OleDb.OleDbType.VarWChar, 50, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "Route", =
System.Data.DataRowVersion.Original,=20
Nothing))
'</DIV></BODY></HTML>

------=_NextPart_000_0000_01C4DC3C.8D141AB0--

Daren
Mon Dec 06 17:19:51 CST 2004

This is a multi-part message in MIME format.

------=_NextPart_000_000A_01C4DC3E.020B8910
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Further More, It may be possible that the ? are fine, as I created a new
Application with only the basics and the error only occurs when I DELETE
rows and then try to Update the DB.

Thx In Advance

_____

From: Daren Hawes [mailto:Newsgroups@webdesignmagic.com.au]
Posted At: Tuesday, 7 December 2004 9:10 AM
Posted To: microsoft.public.dotnet.framework.adonet
Conversation: Concurrency Troubles using Access as Database '?' Appear
in SQL
Subject: Concurrency Troubles using Access as Database '?' Appear in SQL

Hi,

I am using access as the main DB for an application.

Whenever I try to update the DB by my Dataset I get Exception below.

--------------
An unhandled exception of type 'System.Data.DBConcurrencyException'
occurred in system.data.dll

Additional information: Concurrency violation: the DeleteCommand
affected 0 records.
--------------

What worries me is the "?" in the SQL below of the Update Command? Is
this normal?
I just cannot get my head around the "?"

All the code below was generated by Visual Studio.

Do I have to modify this or am I doing something Wrong?

Thanks in Advance.

'OleDbUpdateCommand1

'

Me.OleDbUpdateCommand1.CommandText = "UPDATE Reminders SET ReminderDate
= ?, ReminderTime = ?, Route = ? WHERE (EventID" & _

" = ?) AND (ReminderDate = ? OR ? IS NULL AND ReminderDate IS NULL) AND
(Reminder" & _

"Time = ? OR ? IS NULL AND ReminderTime IS NULL) AND (Route = ? OR ? IS
NULL AND " & _

"Route IS NULL)"

Me.OleDbUpdateCommand1.Connection = Me.OleDbConnection

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("ReminderDate",
System.Data.OleDb.OleDbType.DBDate, 0, "ReminderDate"))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("ReminderTime",
System.Data.OleDb.OleDbType.DBDate, 0, "ReminderTime"))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Route",
System.Data.OleDb.OleDbType.VarWChar, 50, "Route"))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_EventID",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "EventID", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_ReminderDate",
System.Data.OleDb.OleDbType.DBDate, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ReminderDate", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_ReminderDate1",
System.Data.OleDb.OleDbType.DBDate, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ReminderDate", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_ReminderTime",
System.Data.OleDb.OleDbType.DBDate, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ReminderTime", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_ReminderTime1",
System.Data.OleDb.OleDbType.DBDate, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "ReminderTime", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Route",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Route", System.Data.DataRowVersion.Original, Nothing))

Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Route1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Route", System.Data.DataRowVersion.Original, Nothing))

'

------=_NextPart_000_000A_01C4DC3E.020B8910
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN=20
class=3D611531823-06122004>Further More, It may be possible that the ? =
are fine,=20
as I created a new Application with only the basics and the error only =
occurs=20
when I DELETE rows and then try to Update the DB.</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN=20
class=3D611531823-06122004> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN=20
class=3D611531823-06122004>Thx In Advance</DIV> 
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
From: Daren Hawes=20
[mailto:Newsgroups@webdesignmagic.com.au] Posted At: Tuesday, =
7=20
December 2004 9:10 AM Posted To:=20
microsoft.public.dotnet.framework.adonet Conversation: =
Concurrency=20
Troubles using Access as Database '?' Appear in SQL Subject:=20
Concurrency Troubles using Access as Database '?' Appear in=20
SQL </DIV>
<DIV><SPAN=20
class=3D486520223-06122004>Hi,</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>I am =
using access as=20
the main DB for an application.</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>Whenever I try to=20
update the DB by my Dataset I get Exception below.</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV><SPAN=20
class=3D486520223-06122004>--------------</DIV>
<DIV>An =
unhandled=20
exception of type 'System.Data.DBConcurrencyException' occurred in=20
system.data.dll</DIV>
<DIV> </DIV>
<DIV>Additional=20
information: Concurrency violation: the DeleteCommand affected 0=20
records.</DIV>
<DIV><SPAN=20
class=3D486520223-06122004>--------------</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>What =
worries me is=20
the "?" in the SQL below of the Update Command?  Is this=20
normal?</DIV>
<DIV>I just =
cannot get my=20
head around the "?"</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>All =
the code below=20
was generated by Visual Studio.</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>Do I =
have to modify=20
this or am I doing something Wrong?</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV>Thanks =
in=20
Advance.</DIV>
<DIV><SPAN=20
class=3D486520223-06122004> </DIV>
<DIV> </DIV>
<DIV>
'OleDbUpdateCommand1<FONT=20
size=3D2>
'
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.CommandText =3D "UPDATE Reminders SET =
ReminderDate =3D=20
?, ReminderTime =3D ?, Route =3D ? WHERE (EventID" & _
" =3D ?) AND (ReminderDate =3D ? OR ? IS NULL AND ReminderDate IS =
NULL) AND=20
(Reminder" & _
"Time =3D ? OR ? IS NULL AND ReminderTime IS NULL) AND (Route =3D ? =
OR ? IS NULL=20
AND " & _
"Route IS NULL)"
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Connection =3D Me.OleDbConnection
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New =
System.Data.OleDb.OleDbParameter("ReminderDate",=20
System.Data.OleDb.OleDbType.DBDate, 0, "ReminderDate"))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New =
System.Data.OleDb.OleDbParameter("ReminderTime",=20
System.Data.OleDb.OleDbType.DBDate, 0, "ReminderTime"))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New =
System.Data.OleDb.OleDbParameter("Route",=20
System.Data.OleDb.OleDbType.VarWChar, 50, "Route"))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_EventID",=20
System.Data.OleDb.OleDbType.Integer, 0, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "EventID",=20
System.Data.DataRowVersion.Original, Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_ReminderDate",=20
System.Data.OleDb.OleDbType.DBDate, 0, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderDate",=20
System.Data.DataRowVersion.Original, Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_ReminderDate1",=20
System.Data.OleDb.OleDbType.DBDate, 0, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderDate",=20
System.Data.DataRowVersion.Original, Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_ReminderTime",=20
System.Data.OleDb.OleDbType.DBDate, 0, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderTime",=20
System.Data.DataRowVersion.Original, Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_ReminderTime1",=20
System.Data.OleDb.OleDbType.DBDate, 0, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "ReminderTime",=20
System.Data.DataRowVersion.Original, Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_Route",=20
System.Data.OleDb.OleDbType.VarWChar, 50, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "Route", =
System.Data.DataRowVersion.Original,=20
Nothing))
Me<FONT=20
size=3D2>.OleDbUpdateCommand1.Parameters.Add(New=20
System.Data.OleDb.OleDbParameter("Original_Route1",=20
System.Data.OleDb.OleDbType.VarWChar, 50, =
System.Data.ParameterDirection.Input,=20
False, =
<FONT=20
color=3D#0000ff size=3D2>CType(0, Byte), CType(0, Byte), "Route", =
System.Data.DataRowVersion.Original,=20
Nothing))
'</DIV></BODY></HTML>

------=_NextPart_000_000A_01C4DC3E.020B8910--

Concurrency Troubles using Access as Database '?' Appear in SQL

Re: Concurrency Troubles using Access as Database '?' Appear in SQL by Daren