I found the problem in the delete statement. It worked. Thanks!

On 1/12/06, Dimitry Sibiryakov <SD@...> wrote:
>
> 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.
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> ------------------------------
> YAHOO! GROUPS LINKS
>
>
> - Visit your group "firebird-support<http://groups.yahoo.com/group/firebird-support>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com<firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>


[Non-text portions of this message have been removed]