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

2009-10-12 Thread Nicol van der Merwe
On Sun, Oct 11, 2009 at 4:35 PM, Michael Bayer mike...@zzzcomputing.comwrote: 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

[sqlalchemy] Execution of stored procedure on SQL Server 2008

2009-10-08 Thread Nicol van der Merwe
Greetings all I have spent almost two days trying to figure this out, so I hope somebody can help me. Platform info: Python 2.5.4 Operating system : Windows XP Database : SQL Server 2008 running on Windows server 2008. sqlAlchemy 0.5.6 using sqlSoup and pyODBC version 2.1.6 My problem is when

[sqlalchemy] Re: Execution of stored procedure on SQL Server 2008

2009-10-08 Thread Nicol van der Merwe
On Thu, Oct 8, 2009 at 5:20 PM, Michael Bayer mike...@zzzcomputing.comwrote: Nicol van der Merwe wrote: My problem is when I am trying to execute a stored procedure and use the commit and rollback features of sqlAlchemy. the issue is the usage of db.bind.execute(statement). This system