error "concurency violation"

3 Mar 2006 4:21 AM

Toufik

Hi,
I've the folowing error "Concurency violation, The update command affected 0
records", when I execute the save command "DA.Update(DS, "tblName")"
DA is a dataadapter linked to a commandBuilder.

How can I debug the error, know what is the error... what is the exact
update command

thanks

3 Mar 2006 4:55 AM

vbnetdev

Verify your database field names, lengths and types are the same as in your
dataset. You can view the dataset in code view to check these things.

Also check your primary key updating code. If you failed to increment this
could also cause errors but it is hard ot know without seeing code.

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com

Show quoteHide quote

"Toufik" <tou***@hotmail.com> wrote in message
news:%237lhOonPGHA.140@TK2MSFTNGP12.phx.gbl...
> Hi,
> I've the folowing error "Concurency violation, The update command affected
> 0
> records", when I execute the save command "DA.Update(DS, "tblName")"
> DA is a dataadapter linked to a commandBuilder.
>
> How can I debug the error, know what is the error... what is the exact
> update command
>
>
>
> thanks
>
>

3 Mar 2006 8:11 AM

Cor Ligthert [MVP]

Toufik,

Is this Access with Autoincrementkey?

Or give otherwise some more details.

Cor

3 Mar 2006 5:10 PM

Toufik

Thanks friends,
it's an ms-access2000 DB, but without autoincrement.

The error is occuring when I change a value (not a new row), I'm in MONOPOST
environment.

Any Hint?

Show quoteHide quote

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:uohhlnpPGHA.3804@TK2MSFTNGP15.phx.gbl...
> Toufik,
>
> Is this Access with Autoincrementkey?
>
> Or give otherwise some more details.
>
> Cor
>
>

3 Mar 2006 5:17 PM

vbnetdev

Yeah lets see your update code. Also complete error message. (ex.message).

Their is a problem with the value you are inserting into the row.

Do you have a primary key in the table?

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com

Show quoteHide quote

"Toufik" <tou***@hotmail.com> wrote in message
news:%23iUxQVuPGHA.2828@TK2MSFTNGP12.phx.gbl...
> Thanks friends,
> it's an ms-access2000 DB, but without autoincrement.
>
> The error is occuring when I change a value (not a new row), I'm in
> MONOPOST
> environment.
>
> Any Hint?
>
> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
> news:uohhlnpPGHA.3804@TK2MSFTNGP15.phx.gbl...
>> Toufik,
>>
>> Is this Access with Autoincrementkey?
>>
>> Or give otherwise some more details.
>>
>> Cor
>>
>>
>
>