1 reply to this topic

[thatsme]

Hi, i've posted the same problem in C forum, but no one answers me. Perhaps in database forum i will get help. I've written a C code for working with pgsql database. I used <sqlca.h> library. In the top of my code i declare cursor for one of the tables in database:
EXEC SQL DECLARE curs1 CURSOR FOR
SELECT Id, Patirtis
FROM lira8851.Instruktoriai
ORDER BY Id;
Then i use function to print that table and i always get error with SQLCODE -220. The function always fails to print step2 mesage so there might be something wrong with opening the cursor. Here's the code of function:

void printInsructorsList()

{[INDENT]     EXEC SQL WHENEVER SQLERROR GOTO error1;

    EXEC SQL WHENEVER NOT FOUND GOTO error2;


    printf("step1\n");

    printf("Instruktoriu sarasas:");

    EXEC SQL OPEN curs1;

    while (1)

    {

[LEFT][INDENT]     printf("step2\n");

        EXEC SQL FETCH curs1 INTO :instructor_id, :experience;

    printf("step3\n");

        printf("ID: %s; Patirtis: %d;\n", instructor_id, experience);

[/INDENT]}

    EXEC SQL CLOSE curs1;


    return;


    error1:[INDENT]     printf("code: %d\n", SQLCODE);

        printf("Ivyko klaida darbo su duomenu baze metu\n");

        return;

[/INDENT]error2:[INDENT]     printf("code: %d\n", SQLCODE);

        printf("Nerasta duomenu\n");

        return;

[/INDENT][/LEFT]

[/INDENT]}

any help?

Edited by Orjan, 10 December 2010 - 10:17 AM.

[WingedPanther]

I suspect most of us are not familiar with the library in question.