Re: Error in Adding All Tables

Exactly NO not a clue. Do a crtl+F which brings up the Search box in
Visual Studio search for Select. it will be in one of automatically
created .cpp files.

Class builder is suppose to create fully qualified queries but in some
cases it does not

mshelpfile
<http://msdn.microsoft.com/en-us/library/s9ds2ktb%28VS.80%29.aspx>

the command will look something like
DatabaseConnectionObject.ExecuteSql= "Select column1, column2, column3
column4 from Mytable Left Join Othertable on ctid = ctid ".

it needs to look like this
DatabaseConnectionObject.ExecuteSql = "Select column1, column2,
column3 column4 from Mytable Left Join Othertable on OtherTable.ctid =
MyTable.ctid "

One method that is used by a number people is make sure columns in
tables never share the same name. one way is use the first 3 letters of
a table followed by an underscore then name of the column example (
oth_citd and myt_ctid) This way one never has to worry typing fully
qualified names.

This is a method i use when setting up tables.
I strongly suggest learning SQL syntax. If you can wrap your mind
around C++ and its quirks you can very quickly learn SQL
Also you will need to learn
http://www.postgresql.org/docs/current/static/plpgsql.html
its very easy to pick up also and write complicated stored procedures to
manipulated data

Also take note what qualifies as SQL command in Access sometimes will
not work in Postgresql

Another thought is not use ODBC at all and use
libpq <http://www.postgresql.org/docs/8.3/interactive/libpq.html> there
more work involved.

salman Sheikh wrote:
>
>
> 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" <justin(at)emproshunts(dot)com>
> *Gesendet:* 02.11.08 02:34:44
> *An:* pgsql-general(at)postgresql(dot)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" <justin(at)emproshunts(dot)com>
> *Gesendet:* 02.11.08 02:02:21
> *An:* pgsql-general(at)postgresql(dot)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" <justin(at)emproshunts(dot)com>
> *Gesendet:* 02.11.08 01:48:04
> *An:* pgsql-general-owner(at)postgresql(dot)org
> *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" <justin(at)emproshunts(dot)com></A>
> *Gesendet:* 02.11.08 01:23:15
> *An:* salman Sheikh
> *CC:* pgsql-general(at)postgresql(dot)org,pgsql-odbc(at)postgresql(dot)org
> *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*