SQL Anywhere does support FOR UPDATE OF syntax. However,
in SQL Anywhere one cannot specify both FOR UPDATE OF syntax
and FOR UPDATE BY LOCK in the same statement. To achieve INTENT
locking when using FOR UPDATE OF syntax one must use a table hint
in the query's FROM clause, ie.
SELECT * FROM FOO WITH( UPDLOCK ) FOR UPDATE OF ( column-list ).
In this dialect, we avoid this issue by supporting only
FOR UPDATE BY LOCK.
Namespace: NHibernate.DialectAssembly: NHibernate (in NHibernate.dll) Version: 3.2.0.4000 (3.2.0.4000)