Thank you again for the prompt response. On Mon, Jul 19, 2010 at 8:46 AM, Michael Bayer <[email protected]>wrote:
> > 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 > <[email protected]>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 <[email protected]> >> 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 [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]<sqlalchemy%[email protected]> >>> . >>> 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 [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<sqlalchemy%[email protected]> >> . >> 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]<sqlalchemy%[email protected]> > . > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
