Hi Justinthanks for helping me,
But can i ask u ,have u ever worked with Visual C++ 2005.It does every thing automatically,u just click on the button it will generats all classes, for example View class, document class Set class and so on,Set class is actually connection class,which connect application with database, and shows all columns of the table which we added in this application,thatwhy i dont need to write any sql code for adding all table,how long i know,if i am wrong pls correct me.
thanks once more Jusitn
sheikh
Von: "justin" <justin@emproshunts.com>
Gesendet: 02.11.08 02:02:21
An: pgsql-general@postgresql.org
Betreff: Re: [GENERAL] Error in Adding All Tables
you mean you are trying some kind of table joining correct???
example
Select * from mytable, othertable where ctid = ctid ???
Please post the SQL statement you are using to communicate with thedatabase.
The select insert update commands. If i could see what you are doingi would have solved your problem 3 emails ago.
just post the C++ code that has the problem
salman Sheikh wrote:
Hii just want to add table through MFC application,in Visual C++ itgenerates all classes automatically,if i add table one by one,it showsno problem.i can comunicate with my database.But if i add 2 or moretables togather,then it shows this error, i dont know why?
sheikh
Von: "justin" <justi n@emproshunts.com>
Gesendet: 02.11.08 01:48:04
An: pgsql-general-owner@postgresql.org
Betreff: Re: [GENERAL] Error in Adding All Tables
I have no idea what you are trying to do?? please send theSQLcommands you are using.
For me to help you
Need to know what you are trying to accomplish and need to see the code!
salman Sheikh wrote:
hiDo u ha ve any suggestion regarding this problem?
can u add all tables once in postgresql?
In MS access i can add table once without any problem.
sheikh
Von: "justin" <justin@emproshunts.com>< /A>
Gesendet: 02.11.08 01:23:15
An: salman Sheikh
CC: pgsql-general@postgresql.org,pgsql-odbc@postgresql.org
Betreff: Re: [GENERAL] Error in Adding All Tables
@WEB.DE>salman Sheikh wrote:
Hi freinds,
i wanted to add my all tables once in MFC application,i have a databank,which has 11 tables and iwant toa dd themall togather.
After Adding all tables, it shows me alwaysthiserrors bydebugging.
ERROR: column reference "ctid" is ambiguous;
Error while executing the query
i need help from u ppl. I am using VisualC++ 2005andpostgresql 8.3.
thanks
She ikh
Psssst!Schonvom neuenWEB.DE MultiMessenger geh&oum l;rt?
Der kann`s mit allen: http://www.produkte.web.de/messenger/?did=3123
Without looking at the sql statement you are using its kinda hardtoknowwhat the problem is
but ambiguous column means the Postgresql can't figure o ut whatyouwantto do as the column shows up twice in a command.
n5Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten!
Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114
er WEB.DESmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
http://smartsurfer.web.de/?mc=100071&distributionid=000000000066
n 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten!
Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114