Thread: AW: Re: [INTERFACES] USE OF CURSORS IN ECPG

AW: Re: [INTERFACES] USE OF CURSORS IN ECPG

From
Zeugswetter Andreas SB
Date:
> PS: You might consider applying the patch for (update where > not_found) -> 100

No, this is not allowed. sqlcode is supposed to be 0 in above case.
You need to explicitly check for the number of rows updated in your
program if needed.

Andreas


Re: AW: Re: [INTERFACES] USE OF CURSORS IN ECPG

From
Christof Petig
Date:
Zeugswetter Andreas SB wrote:

> > PS: You might consider applying the patch for (update where > not_found) -> 100
>
> No, this is not allowed. sqlcode is supposed to be 0 in above case.
> You need to explicitly check for the number of rows updated in your
> program if needed.
>
> Andreas

According to my reading of the SQL standard this is the only compliant behaviour. Do
you know better?

Christof