Re: facing problem in accessing postgresql with c language normally

From: hatem gamal elzanaty

> i'm new to postgresql programming in c language the
> following code give the following error beneath and
> no reason for
> that error :
> in consice the code i brought from the net and try to
> change it to test what happen
>
> psql_test.c
>
> /* append sql statement and insert record into employee table */
> void insert_employee_rec(PGconn *conn, char* fname, char* lname)
> {
> // Append the SQL statment
> char* sSQL;
> sprintf(sSQL, "insert into employee values ('%s', '%s');", fname
,
> lname );
>
> // Execute with sql statement
> PGresult *res = PQexec(conn, sSQL);
>
> if (PQresultStatus(res) != PGRES_COMMAND_OK)
> {
> printf("insert employee record failed");
> PQclear(res);
> close_conn(conn);
> }
> else
> {
> printf("insert employee record - OK\n");
> }
> //create_employee_table clear result
> PQclear(res);
> }

It looks like you need to spend some time learning how to write code in
C. You did not allocate any space for sSQL. Try changing that
declaration to

char sSQL[512];

Bob McConnell