Re: ECPG. Badly stuck

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:

[root(at)localhost ~]# ecpg ecpg_test.pgc
[root(at)localhost ~]# gcc -o jas ecpg_test.c -lecpg -L/usr/lib/pgsql

Regards,
Jas
On 7/23/06, John Smith <john(at)roundel(dot)net> 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:* pgsql-general-owner(at)postgresql(dot)org [mailto:
> pgsql-general-owner(at)postgresql(dot)org] *On Behalf Of *Jasbinder Bali
> *Sent:* 22 July 2006 18:47
> *To:* pgsql-general(at)postgresql(dot)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
>