Kbase P49458: Delphi/ODBC: "Couldn't perform the edit because another user has changed the record"
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Delphi / BDE
Progress 9.x
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
"Couldn't perform the edit because another user has changed the record"
SQL-92 table includes a column of TIMESTAMP datatype
Trying to use Delphi's "Edit" method to update a query object
There are no other users connected to the database
CAUSE:
This is a known issue being investigated by Development
FIX:
Development is aware of this issue. Currently you either have to
- use UPDATE statement instead of Delphi's Edit method or
- cast your TIMESTAMP columns to VARCHAR