Re: [sqlalchemy] Re: Updating a table with a trigger silently fails (SQL Server)

2015-05-04 Thread Henry Rissanen
Hello, I just noticed the very same problem with PYODBC and SQL Server 2012. In my case it only failed silently some times and failing was somehow related to trigger execution time which in my case varies a bit. I was able to first get it to work with waiting for 1 second before commit. But the

[sqlalchemy] Re: Updating a table with a trigger silently fails (SQL Server)

2009-10-11 Thread Nicol van der Merwe
On Sun, Oct 11, 2009 at 4:35 PM, Michael Bayer wrote: > > > On Oct 11, 2009, at 9:32 AM, Nicol van der Merwe wrote: > > > Hi All > > > > I am using sqlsoup and pyodbc to update a couple of rows in the > > database. On a number of tables in the database I have triggers that > > basically checks kee

[sqlalchemy] Re: Updating a table with a trigger silently fails (SQL Server)

2009-10-11 Thread Michael Bayer
On Oct 11, 2009, at 9:32 AM, Nicol van der Merwe wrote: > Hi All > > I am using sqlsoup and pyodbc to update a couple of rows in the > database. On a number of tables in the database I have triggers that > basically checks keeps a log of changes on certain columns in the > table (inserts c