[fdo-users] FDO MySQL Defect : Can't retreive tablename in joined query

Orest Halustchak orest.halustchak at autodesk.com
Wed Jan 2 08:50:08 EST 2008

Hi Bruno,

You could try using column aliases:
        Select table1.column1 as result1, table2.column1 as result2 from table1, table2 where table1.key = table2.key

You could go ahead a create a ticket for this one as well and we can consider an approach around GetColumnName. A GetTableName approach may not always make sense in all cases. E.g. 'select table1.column1 + table2.column2 from table1, table2, ...'.


-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Bruno Scott
Sent: Wednesday, January 02, 2008 4:27 AM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] FDO MySQL Defect : Can't retreive tablename in joined query

I use FdoISQLCommand to execute joined query in fdo provider that support
Typical query:
  Select table1.column1,table2.column1 from table1,table2 where table1.key =

In FdoMySQL the query execute properly but when a retreive the result using
i only get the column name without the tablename
So there are no ways to distinguish between table1.column1 and
because GetColumnName only return column1.

either GetColumnName should return tableName.columnName
or a new function GetTableName should be implemented

View this message in context: http://www.nabble.com/FDO-MySQL-Defect-%3A-Can%27t-retreive-tablename-in-joined-query-tp14575395s18162p14575395.html
Sent from the fdo-users mailing list archive at Nabble.com.

fdo-users mailing list
fdo-users at lists.osgeo.org

More information about the fdo-users mailing list