Re: Pb with ecpg and include file on PG 8.0.0 - Mailing list pgsql-bugs

Valerie Schneider DSI/DEV wrote:
> ...
> EXEC SQL INCLUDE DbTablesUtilPg.hh;
> ...
>
>    EXEC SQL PREPARE S FROM :sqlstmt;
>    EXEC SQL DECLARE C_FK_COL CURSOR FOR S;
>    EXEC SQL OPEN C_FK_COL;
>    EXEC SQL FETCH MAX_FK IN C_FK_COL  INTO :fk_id_L , :valid_L, :target_t_L;
>
> with MAX_FK a variable defined in the file
> /VALE/users/clipg/Server/Include/DbTablesUtilPg.hh :
> exec sql define  MAX_FK        100;

                                    ^

I think your problem is the semicolon.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073