Mega Code Archive

 
Categories / Delphi / ADO Database
 

Editing record generates bde error 10259 [$2813]

Question: How come when I edit a record with more that 15 digits after the decimal place I get BDE error 10259 ($2813) "Couldn't perform the edit because another user changed the record."? Answer: The BDE has a limit of 15 decimal digits after the decimal place. What is happening to cause this error is that the BDE refetches the row the before you edit it to make sure it still exists. To do so, it uses the data it originally fetched. It only fetches up to 15 digits, so the data the BDE has and data on the server don't match. The server returns that the fetch returned no records which causes the BDE to generate its error.