Subject | DSQL: Deleting Current Row Fetched from Executing Select Statement Using Cursor |
---|---|
Author | Jiya Peng |
Post date | 2006-01-11T14:43:45Z |
Hi,
I need to be able to delete the current row that is fetched from
executing a Select statement(using isc_dsql_fetch, one row at a time).
I encounted "Cursor not updatable with error code=-510" error.
I used "isc_dsql_set_cursor_name" to declare the cursor, and
defined a sql select string like: Select ... From ... For Update ...,
also a sql delete string like: Delete From ...Where Current of S
(where S is pointed by the cursor).
Can someone show me a correct way to complete this task?
Thanks!!
Jiya
[Non-text portions of this message have been removed]
I need to be able to delete the current row that is fetched from
executing a Select statement(using isc_dsql_fetch, one row at a time).
I encounted "Cursor not updatable with error code=-510" error.
I used "isc_dsql_set_cursor_name" to declare the cursor, and
defined a sql select string like: Select ... From ... For Update ...,
also a sql delete string like: Delete From ...Where Current of S
(where S is pointed by the cursor).
Can someone show me a correct way to complete this task?
Thanks!!
Jiya
[Non-text portions of this message have been removed]