On Jul 19, 2010, at 12:35 AM, Michael Mileusnich wrote: > It's just a basic select statement I do not see any other parms.
SQL Server doesn't support "FOR UPDATE" unless in conjunction with "DECLARE CURSOR" which is not typical DBAPI usage so this feature is not supported by SQLAlchemy with MS-SQL server. Stackoverflow confirms people can't really use FOR UPDATE with SQL server in any practical way: http://stackoverflow.com/questions/1483725/select-for-update-with-sql-server > > Thanks > Michael Mileusnich > > On Sun, Jul 18, 2010 at 5:05 PM, Michael Bayer <mike...@zzzcomputing.com> > wrote: > What does your SQL output say? Do you see "FOR UPDATE" in the log? > > Sent from my iPhone > > > On Jul 17, 2010, at 8:47 PM, Michael Mileusnich <justmike2...@gmail.com> > wrote: > > Hello, > > I am running Python 2.6 SQL Alchemy 0.5.8 against MS SQL Server Express 2008 > with pyODBC. When I issue something like: > > sess.query(job).with_lockmode("update") > > It does not seem to be locking according to the query I am getting back from > my profiler. Is this the correct usage? > > Thanks > Mike > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.