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.Dialect
Assembly: NHibernate (in NHibernate.dll) Version: 3.2.0.4000 (3.2.0.4000)

Syntax

C#
public override bool ForUpdateOfColumns { get; }
Visual Basic
Public Overrides ReadOnly Property ForUpdateOfColumns As Boolean
	Get
Visual C++
public:
virtual property bool ForUpdateOfColumns {
	bool get () override;
}

See Also