Re: ECPG patchset

Boszormenyi Zoltan írta:
> Out of scope cursor usage
>

New version of this, changes:
- DECLARE cursor FOR prepared_stmt is also handled properly
- ECPG_informix_set_var() calls are not emitted for global statements
- regression test "outofscope.pgc" is updated

I think it's now at the point where we can reconsider your argument
about making this feature generic and not an Informix-only feature:

> Yeah, right, and you also add this hack to all applications. No.

I don't think it's hackish at all now. Read the outofscope.pgc
regression test and its generated source.
- ECPG_informix_set_var() calls are only generated for variables
in function scope, not for globals.
- ECPG_informix_get_var() calls are generated only when
OPEN and FETCH are in a function different from the one
where DECLARE was.

In the common case the generated source would only contain
some *_set_var() calls but the function references wouldn't change.

Best regards,
Zoltán Böszörményi

--
Bible has answers for everything. Proof:
"But let your communication be, Yea, yea; Nay, nay: for whatsoever is more
than these cometh of evil." (Matthew 5:37) - basics of digital technology.
"May your kingdom come" - superficial description of plate tectonics

----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/