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
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
It's just a basic select statement I do not see any other parms.
Thanks
Michael Mileusnich
On Sun, Jul 18, 2010 at 5:05 PM, Michael Bayer mike...@zzzcomputing.comwrote:
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,
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
Hi
I am using oracle/mysql and sqlalchemy for a project I am working on.
I have a query executed like this
SELECT table_entity_id, table_entity_type, table_avail_state,
table_monit_state, table_transient_state, table_transient__1,
table_owner, table_timestamp, table_description FROM (SELECT