concurrency violation when perform ds.update twice?

[nev]

I place values in my datatable programatically. then i do...

bs.endedit()
adp.update(ds.dtt)

after that

i perform a find to that record to add some more values

bs.position = bs.find("col", key)
'code to add values to that row
bs.endedit()
adp.update(ds.dtt) '<---- Concurrency violation

please teach me how to do this correctly. take note that i am unable to add those values all at once due to certain requirements. that's why i need to enter partial data first then find that record to add the other values.

[Shashi Sadasivan]

hi nev,
i had come across this issue a few months ago, and the amount of code behind my form was humungus.
Anyways....
what was ahppening is that i updated the table. But then at some other point, due to some other functionality, it was updating the same row in the database without using the same dataset used initially.
So which meant that when i ran my update, it had old values.
and threw a concurrency exception

Its something like if you retrieve a dataset, but then before updating it, if someone else changes that row, then the dataset cannot validate the row against the database, and it finds that a concurrency has occoured.

it sounds a bit spagetti, but what you need to do is to re-fill the dataset before changing it the second time.

[nev]

yep! that's what i accidentally did :-)

[Shashi Sadasivan]

Glad I hit the nail there :)