On Wed, 2003-09-24 at 11:27, Vutharkar Goutham wrote: > 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");
> now if i try to execute the above statement it is giving me always teh > select failed message. In that statement you have a mixed case name for the table. If it has a mixed case name in the database too, the name needs to be enclosed in double quotes. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "And we know that all things work together for good to them that love God, to them who are the called according to his purpose." Romans 8:28 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
