212 Couldn't perform the edit because another user changed the record.
Problem: Getting error "Couldn't perform the edit because another user changed the record."
When saving data to a Oracle 8 database.
Date: 19 July 1999
Versions: P8
Environment: Oracle 8. BDE 5.01 and ODBC 3.5 with Microsoft ODBC Driver for Oracle and Oracle 8.0.4.
Explanation by: < Rene.HoppeATbln9.siemens.de >
In the Oracle table there was two double-fields with a precision higher than allowed in Paradox. This is no problem for Paradox unless there are values in these fields with a higher precision.
The values of these fields where modified in Oracle which results in values like "0.606060606060606060..." (I believe this is called a recurring decimal). Oracle can handle up to 127 digits to the right of the decimial point, but Paradox can't. A value like "0.6060606060606060..." is converted to "0.606060606060" while doing a fetch. This is the "changed by another user". And that is the reason why I was not able to change a record with such a value in Paradox. The solution was to alter the table in Oracle to store datatypes which don't have to be converted by Paradox: "alter table prjvar modify (curofferrate number(30,14));" (you have to empty the field before reducing precision).