I'm using the ACUXDBC driver to update a single field in an UPDATE statement. My statement is thus:
UPDATE Orders SET RECORD_DATE = '2015-02-27' WHERE TRANSACTION_NUMBER = 906944200
When I run the above statement I get the following error.
ERROR [HY000] [TOD][ODBC][GENESIS]VISION: Cannot update 'Orders',Record not found
The only problem is the record *does* exist because when I do a SELECT as in:
SELECT RECORD_DATE FROM Orders WHERE TRANSACTION_NUMBER = 906944200
It finds and returns the correct value for the row in question.
So I know the record exists, and I know it can be found, but for some reason the XDBC driver is telling me that it cannot be when I try to do an UPDATE. I have tried updating a different field in the same row and it works fine. This statement runs without any problems.
UPDATE Orders SET mkting_unit = 1 WHERE TRANSACTION_NUMBER = 906944200