Firebird Documentation IndexFirebird 2.0 Language Ref. UpdatePSQL statements → WHERE CURRENT OF invalid for view cursors
Firebird Home Firebird Home Prev: UDFs callable as void functionsFirebird Documentation IndexUp: PSQL statementsNext: Context variables

WHERE CURRENT OF invalid for view cursors

Changed in: 2.0

Description: In versions 2.0.x, positioned updates and deletes using WHERE CURRENT OF are no longer possible for view cursors, due to some problems that could make such cursors unreliable. This restriction will be lifted again in Firebird 2.1, which has an improved validation logic for views.

Prev: UDFs callable as void functionsFirebird Documentation IndexUp: PSQL statementsNext: Context variables
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdatePSQL statements → WHERE CURRENT OF invalid for view cursors