ADO Application HELP!!!

[ArifBilgin]

Hello to everybody, I have been working on a very messy mrp project (actually a project group as borland cbuilder says) and finally finished the whole project except a bug called "row cannot be located for updating...." I get this message randomly withing the program.There are lots and lots of adotables everywhere and from time to time this msg pops up and lock the table that i am editing or inserting a recors until i roll back the changes. I have been googling this issue since august and just couldnt get any results. It might be caused by an mssql bug or maybe the TADOTable itself has bug in it i have no clue.DB is MsSQL.I have borland c++builder 6 enterprise edition with update 4.I would really appreciate whoever helps me to resolve this matter and move on..

 

[ArifBilgin]

Row cannot be located for updating. Some values may have
been changed"

this is the err msg i keep getting randomly.weird!I feel like i have a curse

 

[2ffat]

What this error indicates is that some row (record) was supposed to be updated but something else already changed it. I've seen this with non-BCB programs during multi-user events. This really isn't a bug as much as a safe-guard against changing records (rows) that someone else has already changed.

Look at using Transactions in this case.



James P. Cottingham
-----------------------------------------
^{I'm number 1,229!
I'm number 1,229!}

 

[ArifBilgin]

it is impossible that some other user tries to change the record.Coz i am trying it with one table in one single client software.I know it is sth about indices or primary key, Coz when i update or append a record by using ADOQuery everything is fine, but when i use standart methods of TADOTable(in this case Append) i get the error. I read some stuff in microsoft's website concerning this as a bug.Anyway All i can do i guess is never use TADOTable in my programs. maybe to view records that is all.I have never experienced such stupid error msgs in my life (not even with bde).Access Vialotions coming out of ide , and sort of error that i have never heard before.thank anyway

 

[2ffat]

Somewhere I've been advised to use the ADODataSet since it can mimic the other ADO components. I don't remember where or why. I do a little research when I get a chance.



James P. Cottingham
-----------------------------------------
^{I'm number 1,229!
I'm number 1,229!}

 

[Ginka]

I've seen this error too.

I supose you are using a DBGrid to show some queries.

And the error pop ups when you are editing and you change to another record.

Is it correct?

 

[ArifBilgin]

yes exactly i think what is the solution?