I'm currently working with sqlalchemy (Version 1.3.18) to access a Microsoft Server SQL Database (Version: 14.00.3223). I use pyodbc (Version 4.0.30)
When I try to update a single object and try to update and commit the object, I run into a StaleDataError: StaleDataError: UPDATE statement on table 'Measurement' expected to update 1 row(s); 5051 were matched. The update statement looks perfectly fine: 2020-06-26 15:50:59,872 INFO sqlalchemy.engine.base.Engine UPDATE tbm.[Measurement] SET [IsCompleted]=? WHERE tbm.[Measurement].[ID] = ? 2020-06-26 15:50:59,872 INFO sqlalchemy.engine.base.Engine (True, 6248) Any Idea what's wrong with this. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/d607c30c-2bc5-4680-9e7f-842da8f28792n%40googlegroups.com.