On 11 Jan 2006 at 9:43, Jiya Peng wrote:

>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?

I never used "where current" in DSQL but suspect that your SELECT
use joins or something else that makes it non-updatable.

--
SY, Dimitry Sibiryakov.