Couldn't perform the edit because another user changed the record
Hi,
I made some changes to one report and when I tried to save it, it gives me
this error: "Couldn't perform the edit because another user changed the
record". Our application is a server-client app so more than 1 person can
edit the report at the same time. How can this be fixed and what should we
do to prevent this from happening again? Thanks.
I made some changes to one report and when I tried to save it, it gives me
this error: "Couldn't perform the edit because another user changed the
record". Our application is a server-client app so more than 1 person can
edit the report at the same time. How can this be fixed and what should we
do to prevent this from happening again? Thanks.
This discussion has been closed.
Comments
Which database/connectivity are you currently using? If I understand
correctly, this error is frequently encountered with the combination of SQL
Server, BDE and the use of TimeStamp fields. This is due to the fact that
the BDE is forced to round the MSSQL timestamp data before converting it to
a Windows DateTime. One workaround is to change the UpdateMode of your
TQuery or perhaps consider using a different connectivity such as ADO.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com