Yes, i'm working with VS 2008 with QT framework working on a
application with i don't know couple hundred thousand lines of code.
Been using VS sense 1997 how about you???
One of your big problems is your using the Automatic Class builder.
Its sucks and is what is causing your problem as it creates code that
don't work.
Case in point the SQL code is wrong.
In this case the Select statement being created is trying to join two
tables together that have the same column name
Select * from mytable, othertable where ctid = ctid
this command will create the error you have
now to avoid the error it should look like this
Select * from mytable, othertable where mytable.ctid = othertable.ctid
Now Postgresql knows what you want it to do. Before the Postgresql has
two columns with the same name and does not understand how to join the
two tables
Find the the code where the Select statement is change the Joining
argument
salman Sheikh wrote:
Hi Justin
thanks 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@xxxxxxxxxxxxxxx>
Gesendet: 02.11.08 02:02:21
An: pgsql-general@xxxxxxxxxxxxxx
Betreff: Re: 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:
Hi
i 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@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 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:
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><
/A>
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 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
|
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.
|
|
|
|
