Re: embedded SQL cursos declare fails

On Fri, Aug 24, 2001 at 02:07:48PM -0400, Bruce Momjian wrote:
> OK, I have applied the following patch.  Interestingly, the SGML code
> marked this block as outdated, but didn't remove it for some reason.

I'm afraid this patch is incorrect.

> -       <!--WARNING: FROM HERE ON THE TEXT IS OUTDATED!-->

Don't know why this is said.

> -       <varlistentry>
> -        <term>Open cursor statement</term>
> -        <listitem>
> -     <para>
> -      An open cursor statement looks like:
> -      <programlisting>
> - exec sql open <replaceable>cursor</replaceable>;
> -      </programlisting>
> -      and is ignore and not copied from the output.
> -     </para>

This is partly correct. The OPEN statement is not copied. Instead the
DECLARE statement is issued at the place of the OPEN statement since it
opens the cursor too.

> -      A commit statement looks like
> -      <programlisting>
> - exec sql commit;

Thsi certainly exists.

> -      and is translated on the output to
> -      <programlisting>
> - ECPGcommit(__LINE__);

But the translation is not correct anymore.

> - exec sql rollback;
> -      </programlisting>
> -      and is translated on the output to
> -      <programlisting>
> - ECPGrollback(__LINE__);

Same here.

These functions have been combined to
ECPGtrans(int lineno, const char *connection_name, const char *transaction)

Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!