Select statement error !!!!

Поиск
Список
Период
Сортировка
От Vutharkar Goutham
Тема Select statement error !!!!
Дата
Msg-id Sea1-F17prhMOgRGkQ600000446@hotmail.com
обсуждение исходный текст
Ответы Re: Select statement error !!!!  (Oliver Elphick <olly@lfix.co.uk>)
Re: Select statement error !!!!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
Hello,

I am doing a simple program with PostgreSql wherein i am giving a select
statement as an argument to PQexec like this


char query[1024];
strcpy(query,"Select * from Udp_Table");

res = PQexec(conn,query);

if(!res || PQresultStatus(res)! = PGRES_COMMAND_OK)
{
    fprintf(stderr,"Select Failed.\n");
    PQclear(res);
    exit(1);
}
now if i try to execute the above statement it is giving me always teh
select failed message. I dont know where the problem is? But when i try to
store some other query in array like update statement or insert statement or
any other statement it is working and giving the results i want to see. But
i dont know what is wrong with the select statement i think it should work
isn't it? Can anybody out there please help me to solve this problem.

Thank You,

Goutham.V
  MSIT.

_________________________________________________________________
Get personal loans. It's hassle-free.
http://server1.msn.co.in/msnleads/citibankpersonalloan/citibankploanjuly03.asp?type=txt
It's approved instantly.


В списке pgsql-docs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: About SET SEARCH_PATH
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: Select statement error !!!!