I am writing an App in delphi4 using SQL links for SQL Server but, I'm getting a weird error.
I am looping through a table and based on certain field values I am trying to edit other fields. However when I try to post the changes I keep getting the error " Can't perform the edit another user has changed the record". There are no other users or application using the applications so I don't understand this. When I try to edit the table throught Database desktop I also got the same error. Now the weird part, I have another application that uses the same table, and that application edits the table with no errors, I can also edit the table in access. I think this is some sort of Record Lock problem but I can't figure why. Anyone know why this is happening