error "concurency violation"

[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

[vbnetdev]

Re: error "concurenc y violation"

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

"Toufik" <touiss@hotmail .com> wrote in message
news:%237lhOonP GHA.140@TK2MSFT NGP12.phx.gbl.. .[color=blue]
> 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
>
>[/color]

[Cor Ligthert [MVP]]

Re: error &quot;concurenc y violation&quot;

Toufik,

Is this Access with Autoincrementke y?

Or give otherwise some more details.

Cor

[Toufik]

Re: error &quot;concurenc y violation&quot;

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]" <notmyfirstname @planet.nl> wrote in message
news:uohhlnpPGH A.3804@TK2MSFTN GP15.phx.gbl...[color=blue]
> Toufik,
>
> Is this Access with Autoincrementke y?
>
> Or give otherwise some more details.
>
> Cor
>
>[/color]

[vbnetdev]

Re: error &quot;concurenc y violation&quot;

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

"Toufik" <touiss@hotmail .com> wrote in message
news:%23iUxQVuP GHA.2828@TK2MSF TNGP12.phx.gbl. ..[color=blue]
> 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]" <notmyfirstname @planet.nl> wrote in message
> news:uohhlnpPGH A.3804@TK2MSFTN GP15.phx.gbl...[color=green]
>> Toufik,
>>
>> Is this Access with Autoincrementke y?
>>
>> Or give otherwise some more details.
>>
>> Cor
>>
>>[/color]
>
>[/color]