Michael wrote:
>Let's say we have a table with two entries:
>
>name nr
>----------
>foo 1
>bar 2
>and a C program doing the following:
>
>..
>i=1;
>exec sql declare C cursor for select name from table where nr=:i;
>i=2;
>exec sql open C;
>..
>
>Which row will be selected?
Since it is usually allowed to do one declare and then many
open, fetch, fetch ...
open, fetch ....
it has to be i=2 (bar)
Andreas