Re: Error in Adding All Tables

[justin <justin@xxxxxxxxxxxxxxx>]

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 the database. 
The select insert update commands.   If i could see what you are doing i would have solved your problem 3 emails ago.

just post the C++ code that has the problem




salman Sheikh wrote:

 Hi

i just want to add table through MFC application,in Visual C++ it generates all classes automatically,if i add table one by one,it shows no problem.i can comunicate with my database.But if i add 2 or more tables togather,then it shows this error, i dont know why?

sheikh

---

Von: "justin" <justin@xxxxxxxxxxxxxxx>
Gesendet: 02.11.08 01:48:04
An: pgsql-general-owner@xxxxxxxxxxxxxx
Betreff: Re: Error in Adding All Tables

I have no idea what you are trying to do??   please send the SQLcommands 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:

 hi

Do 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@xxxxxxxxxxxxxxx>
Gesendet: 02.11.08 01:23:15
An: salman Sheikh
CC: pgsql-general@xxxxxxxxxxxxxx,pgsql-odbc@xxxxxxxxxxxxxx
Betreff: Re: 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 i want toa dd themall togather.

 After Adding all tables, it shows me always thiserrors bydebugging.

ERROR: column reference "ctid" is ambiguous;
Error while executing the query

i need help from u ppl. I am using Visual C++ 2005andpostgresql 8.3.

thanks
Sheikh

Psssst!Schonvom neuen WEB.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 hardtoknow what the problem is

but ambiguous column means the Postgresql can't figure o ut whatyouwant to do as the column shows up twice in a command.

n 5Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten!    
Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114  

er WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!   
http://smartsurfer.web.de/?mc=100071&distributionid=000000000066