Thread: Query Fails

Query Fails

From
Sheikh Salman Ahmed
Date:

Hallo Fellows
 
I am a new User of postgresql.I have installed it on window XP.I feel it little complicated on Window.I have already connected it with visual c++ 2005,but when i wanted to insert some data in my databank,then it fails and shows sytax error or  doesn't recognise my table, but connection to data it shows.
i am using this code to insert data.
 
res = PQexec (conn, "INSERT INTO public.Person values (121,'xxx','yyy')");
 
It will be grateful,if u ppl can help me. 

 
Sheikh Salman Ahmed
Diplomand in Nano Struktur Technologie
Duisburg-Essen Universität
Mobile : 0049-179-9463738
Home :0049-203-3945028




Get news, entertainment and everything you care about at Live.com. Check it out!

Re: Query Fails

From
Richard Huxton
Date:
Sheikh Salman Ahmed wrote:
> Hallo Fellows
>
> I am a new User of postgresql.I have installed it on window XP.I feel it little complicated on Window.I have already
connectedit with visual c++ 2005,but when i wanted to insert some data in my databank,then it fails and shows sytax
erroror  doesn't recognise my table, but connection to data it shows. 
> i am using this code to insert data.
>
> res = PQexec (conn, "INSERT INTO public.Person values (121,'xxx','yyy')");

You probably need to provide the error message for anyone to be sure.

However, at a guess you created your table as "Person" which means it's
case-sensitive. You're now trying to access it without quotes which
means it gets case-folded to "person". Search the list archives for
plenty of discussion.

Summary:
CREATE TABLE FOO
SELECT * FROM foo  -- works
SELECT * FROM Foo  -- works

CREATE TABLE "FOO"
SELECT * FROM foo -- fails
SELECT * FROM FOO -- fails
SELECT * FROM "FOO" -- works

--
   Richard Huxton
   Archonet Ltd