<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-15"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
you mean you are trying some kind of table joining correct???<br>
<br>
example<br>
<br>
Select * from mytable, othertable where ctid = ctid ???<br>
<br>
Please post the SQL statement you are using to communicate with the
database. <br>
The select insert update commands. If i could see what you are doing
i would have solved your problem 3 emails ago. <br>
<br>
just post the C++ code that has the problem <br>
<br>
<br>
<br>
<br>
salman Sheikh wrote:
<blockquote cite="mid:1388753898(at)web(dot)de" type="cite">
<p><br>
Hi </p>
<p>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?</p>
<p>sheikh<br>
</p>
<table id="alt"
style="border-left: 2px solid blue; padding-left: 10px; font-size: 9pt; margin-left: 20px; font-family: Verdana;">
<tbody>
<tr>
<td>
<hr><b>Von:</b> "justin" <a class="moz-txt-link-rfc2396E" href="mailto:justin(at)emproshunts(dot)com"><justin(at)emproshunts(dot)com></a><br>
<b>Gesendet:</b> 02.11.08 01:48:04<br>
<b>An:</b> <a class="moz-txt-link-abbreviated" href="mailto:pgsql-general-owner(at)postgresql(dot)org">pgsql-general-owner(at)postgresql(dot)org</a><br>
<b>Betreff:</b> Re: [GENERAL] Error in Adding All Tables<br>
<br>
<p>I have no idea what you are trying to do?? please send the
SQLcommands you are using. <br>
<br>
For me to help you<br>
Need to know what you are trying to accomplish and need to see the code!<br>
<br>
<br>
salman Sheikh wrote:</p>
<blockquote>
<p><br>
hi</p>
<p>Do u ha ve any suggestion regarding this problem?</p>
<p>can u add all tables once in postgresql?</p>
<p>In MS access i can add table once without any problem.</p>
<p>sheikh<br>
</p>
<table id="alt"
style="border-left: 2px solid blue; padding-left: 10px; font-size: 9pt; margin-left: 20px; font-family: Verdana;">
<tbody>
<tr>
<td>
<hr><b>Von:</b> "justin" <a moz-do-not-send="true"
class="moz-txt-link-rfc2396E" href="mailto:justin(at)emproshunts(dot)com"><justin(at)emproshunts(dot)com></a><br>
<b>Gesendet:</b> 02.11.08 01:23:15<br>
<b>An:</b> salman Sheikh <span><br>
<b>CC:</b> <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:pgsql-general(at)postgresql(dot)org">pgsql-general(at)postgresql(dot)org</a>,<a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:pgsql-odbc(at)postgresql(dot)org">pgsql-odbc(at)postgresql(dot)org</a><br>
<b>Betreff:</b> Re: [GENERAL] Error in Adding All Tables<br>
<br>
</span>@WEB.DE>
<p>salman Sheikh wrote:</p>
<blockquote><br>
<br>
<table id="alt"
style="border-left: 2px solid blue; padding-left: 10px; font-size: 9pt; margin-left: 20px;">
<tbody>
<tr>
<td>
<p>Hi freinds, <br>
i wanted to add my all tables once in MFC application,</p>
<p>i have a databank,which has 11 tables and i
want toa dd themall togather.</p>
<p> After Adding all tables, it shows me always
thiserrors bydebugging.</p>
<p><br>
ERROR: column reference "ctid" is ambiguous; <br>
Error while executing the query <br>
</p>
<p>i need help from u ppl. I am using Visual
C++ 2005andpostgresql 8.3.<br>
</p>
<p>thanks <br>
Sheikh </p>
<br>
<br>
<table border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<td bgcolor="#000000"><img
moz-do-not-send="true" alt="" src="https://img.web.de/p.gif" border="0"
height="1" width="1"></td>
</tr>
<tr>
<td
style="font-size: 12px; font-family: verdana;">Psssst!Schonvom neuen
WEB.DE MultiMessenger geh&oum l;rt? <br>
Der kann`s mit allen: <a moz-do-not-send="true"
href="http://www.produkte.web.de/messenger/?did=3123"><b>http://www.produkte.web.de/messenger/?did=3123</b></a> </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<br>
</blockquote>
<br>
Without looking at the sql statement you are using its kinda hardtoknow
what the problem is<br>
<br>
but ambiguous column means the Postgresql can't figure o ut whatyouwant
to do as the column shows up twice in a command.<br>
<br>
<br>
</td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td bgcolor="#000000"><img moz-do-not-send="true" alt=""
src="https://img.web.de/p.gif" border="0" height="1" width="1"></td>
</tr>
<tr>
<td
style="font-size: 12px; line-height: 17px; font-family: verdana;">n
5Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten! <br>
Nur 3,99 EUR/Monat! <a moz-do-not-send="true"
href="http://www.maildomain.web.de/?mc=021114"><b>http://www.maildomain.web.de/?mc=021114</b></a> </td>
</tr>
</tbody>
</table>
</blockquote>
<br>
</td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td bgcolor="#000000"><img moz-do-not-send="true"
src="https://img.web.de/p.gif" alt="" border="0" height="1" width="1"></td>
</tr>
<tr>
<td style="font-size: 12px; line-height: 17px;">er WEB.DE
SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! <br>
<a moz-do-not-send="true"
href="http://smartsurfer.web.de/?mc=100071&distributionid=000000000066"><b>http://smartsurfer.web.de/?mc=100071&distributionid=000000000066</b></a> </td>
</tr>
</tbody>
</table>
</blockquote>
<br>
</body>
</html>