On 26 Feb 2004 at 14:00, frische_brise2003 wrote:

>where can I find a detailed example of using cursors
>in a FB 1.5 DB.

In documentation. But everything depends on what you call
"cursors"...

>After declaring and opening a cursor I have to fetch
>the values in a loop, right? How do I know, that the
>last row has been fetched?

Looks like you are using gpre... FETCH will return SQLCODE 100.

>What happens if I delete rows out of the table
>on which the select statement in cursor declaration
>is based, while stepping to the cursor?

It depends on transaction parameters. You may get the old values of
rows or not.

SY, Dimitry Sibiryakov.