HI justin
actually i am newbie in this field,thatwhy i dont have much knowledge
it. Now i understand the problem,but i am using MFC classes,as i told
u it generates automatically, do u have any idea where should i change
the code?
i am very thankful to you man
sheikh
------------------------------------------------------------------------
*Von:* "justin" <[EMAIL PROTECTED]>
*Gesendet:* 02.11.08 02:34:44
*An:* pgsql-general@postgresql.org
*Betreff:* Re: [GENERAL] Error in Adding All Tables
Yes, i'm working with VS 2008 with QT framework working on
aapplication 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 you r problem as it creates code
thatdon't work.
Case in point the SQL code is wrong.
In this case the Select statement being created is trying to join
twotables 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
hastwo columns with the same name and does not understand how to join
thetwo tables
Find the the code where the Select statement is change the
Joiningargument
salman Sheikh wrote:
Hi Justin
thanks for helping me,
But can i ask u ,have u ever worked with Visual C++ 2005.It
doesevery thing automatically,u just click on the button it will
generatsall classes, for example View class, document class Set
class and soon,Set class is actually connection class,which
connect applicationwith database, and shows all columns of the
table which we added inthis application,thatwhy i dont need to
write any sql code for addingall table,how long i know,if i am
wrong pls correct me.
thanks once more Jusitn
sheikh
------------------------------------------------------------------------
*Von:* "justin" <[EMAIL PROTECTED]>
*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
withthedatabase. The select insert update commands. If i
could see what you are
doingiwould 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 VisualC++
itgenerates all classes automatically,if i add table one by
one,itshowsno problem.i can comunicate with my database.But if
i add 2 ormoretables togather,then it shows this error, i dont
know why?
sheikh
------------------------------------------------------------------------
*Von:* "justin" <[EMAIL PROTECTED]>
*Gesendet:* 02.11.08 01:48:04
*An:* [EMAIL PROTECTED]
*Betreff:* Re: [GENERAL] Error in Adding All Tables
I have no idea what you are trying to do?? pleasesend
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 anyproblem.
sheikh
------------------------------------------------------------------------
*Von:* "justin" <[EMAIL PROTECTED]></A>
*Gesendet:* 02.11.08 01:23:15
*An:* salman Sheikh
*CC:* pgsql-general@postgresql.org,[EMAIL PROTECTED]
*Betreff:* Re: [GENERAL] Error in AddingAll 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 11tables and iwant toa
dd themall togather.
After Adding all tables, it showsme alwaysthiserrors
bydebugging.
ERROR: column reference "ctid" is ambiguous;
Error while executing the query
i need help from u ppl. I am usingVisualC++
2005andpostgresql 8.3.
thanks
She ikh
Psssst!SchonvomneuenWEB.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
kindahardtoknowwhat the problem is
but ambiguous column means the Postgresql can't figure o
utwhatyouwantto do as the column shows up twice in a command.
n5Schritten zur eigenenHomepage. Jetzt Domain sichern und
gestalten! Nur 3,99 EUR/Monat!
*http://www.maildomain.web.de/?mc=021114*
<htt%0A%20p://www.maildomain.web.de/?mc=021114>
erWEB.DESmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu
sparen!
*http://smartsurfer.web.de/?mc=100071&distributionid=000000000066*
<http://smartsurfer.web.de/?mc=100071&distributionid=000000000066>
n 5Schritten zur eigenen Homepa ge. Jetzt Domain sichern und
gestalten! Nur 3,99 EUR/Monat!
*http://www.maildomain.web.de/?mc=021114*
n 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und
gestalten! Nur 3,99 EUR/Monat!
*http://www.maildomain.web.de/?mc=021114*