Re: [HACKERS] V8.3.0: PQprepare()/PQexecPrepared() and DECLARE CURSOR

2007-12-18 Thread Andrew Dunstan
Sebastien FLAESCH wrote: Thank you Andrew, I agree the example is a bit confusing, anyway it's my fault... problem fixed. However, could you please confirm that I can use the same name for a prepared statement and a server cursor? Your example would have failed earlier otherwise. Ple

Re: [HACKERS] V8.3.0: PQprepare()/PQexecPrepared() and DECLARE CURSOR

2007-12-18 Thread Sebastien FLAESCH
Thank you Andrew, I agree the example is a bit confusing, anyway it's my fault... problem fixed. However, could you please confirm that I can use the same name for a prepared statement and a server cursor? This seems to work: test1=> declare s1 cursor with hold for select * from dbit2; test1=

Re: [HACKERS] V8.3.0: PQprepare()/PQexecPrepared() and DECLARE CURSOR

2007-12-18 Thread Sebastien FLAESCH
Sorry I should have double checked, it's my fault. I do not CLOSE the cursor before the third PQexecPrepare()... Never mind. Seb Sebastien FLAESCH wrote: Hi All, I am new to this mailing list and want to participate to the 8.3.0 beta program. (Sorry to be late BTW) My name is Sebastien FLA

Re: [HACKERS] V8.3.0: PQprepare()/PQexecPrepared() and DECLARE CURSOR

2007-12-18 Thread Andrew Dunstan
Sebastien FLAESCH wrote: Hi All, I am new to this mailing list and want to participate to the 8.3.0 beta program. (Sorry to be late BTW) My name is Sebastien FLAESCH and I am in charge of the database interfaces at Four J's Development Tools. Our product is a Informix 4gl compatible comp

[HACKERS] V8.3.0: PQprepare()/PQexecPrepared() and DECLARE CURSOR

2007-12-18 Thread Sebastien FLAESCH
Hi All, I am new to this mailing list and want to participate to the 8.3.0 beta program. (Sorry to be late BTW) My name is Sebastien FLAESCH and I am in charge of the database interfaces at Four J's Development Tools. Our product is a Informix 4gl compatible compiler / runtime system. I wrote