Issue Details (XML | Word | Printable)

Key: CORE-1213
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Alexander Tyutik
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

CURRENT OF support views

Created: 17/Apr/07 03:54 PM   Updated: 17/Mar/09 05:06 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 2.1 Beta 1

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
I propose to add CURRENT OF support for views in PSQL.

For example:

...
FOR SELECT ... FROM MY_VIEW INTO ... AS CURSOR VIEW_CURSOR DO
BEGIN
  ...
  DELETE FROM MY_VIEW WHERE CURRENT OF VIEW_CURSOR;
  ...
END

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Tyutik added a comment - 18/Apr/07 10:07 AM
But cursors works with views in other servers without problems. For example i tried WHERE CURRENT OF with view on MS SQL 2000 and it works.

Philippe Makowski added a comment - 17/Mar/09 03:45 AM
sorry wrong assign