Re: [GENERAL] ECPG. Badly stuck

[Jasbinder Bali]

Hi ,

Forget about cursors. Singleton queries are also not working.

Tried writing the follwoing code but doesn't give me any result.
Don't know if i have to do somethin else apart from what i've already done.



include <stdio.h>
EXEC SQL INCLUDE sqlca;

int main ()
{
        EXEC SQL BEGIN DECLARE SECTION;
                char movie_type[20];
                char *movie_title=NULL;
                char query_string[256];
        EXEC SQL END DECLARE SECTION;

        EXEC SQL CONNECT TO postgres;


        EXEC SQL INSERT INTO films VALUES (13,'',4,'2002-2-3','AA','01:01:01');

        EXEC SQL SELECT title  INTO :movie_type FROM films;

        printf("enter the type of movie %s",movie_type);

        EXEC SQL COMMIT;

}


Please let me know whats going wrong.

I'm compiling my code as follows:

[EMAIL PROTECTED] ~]# ecpg ecpg_test.pgc
[EMAIL PROTECTED] ~]# gcc  -o jas ecpg_test.c -lecpg -L/usr/lib/pgsql


Regards,
Jas

On 7/23/06, John Smith < [EMAIL PROTECTED]> wrote:

Simple:

 

EXEC SQL select foo from bar into :foo;

 

printf("foo is %s", foo);

 

 

If the select statement will return more than one row, then yes, you need to define a cursor to access it one row at a time.

 

John.

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jasbinder Bali
Sent: 22 July 2006 18:47
To: pgsql-general@postgresql.org
Subject: [GENERAL] ECPG. Badly stuck

Hi,

I had posted this question a few days back.

Sending the same question again.

 

I have a C program and have some ECPG code in it.

 

How do i display the data that i retrieve from the postgres database using a simple select statment or calling a stored procedure.

 

Is it mandatory to use cursor or there's  any other way to print the retrieved data..

 

Any kind of help would be highly appreciated.

Thanks,

~Jas