1242 Data type mismatch on key replacement Explanation: An attempt was made to replace a key field in the database with an invalid data type. Indexing on a logical field may also cause this error. Action: Test the index keys and the replacement values in the debugger.