Subject DSQL: Deleting Current Row Fetched from Executing Select Statement Using Cursor
Author Jiya Peng
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]