Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to implement a SELECT FOR UPDATE cursor

41 views
Skip to first unread message

sebflaesch

unread,
Jul 13, 2010, 10:41:49 AM7/13/10
to s...@4js.com
Hi all,

Sybase 15.5 on Linux x86 32b, using Sybase ODBC client.

I try to perform a SELECT FOR UPDATE by using a statement handle with
following attribute set:

r = SQLSetStmtAttr(st->stmtHandle, SQL_ATTR_CONCURRENCY,
(SQLPOINTER) SQL_CONCUR_LOCK,
SQL_IS_UINTEGER);

Normally this should set a lock on the fetched rows, actually this
code is working fine with the SQL Server Native Client and with
EasySoft driver for SQL Server...

But with Sybase it has no effect... what am I missing?

I could not find any advice in the manuals regarding SELECT FOR
UPDATE...

Thanks for reading and sorry if this question is stupid, I am new to
Sybase ASE and maybe locking / concurrency management is different as
I expect...
Seb

0 new messages