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

[Orest Halustchak]

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, ...'.

Thanks,
Orest.

-----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
SQLCommand.
Typical query:
  Select table1.column1,table2.column1 from table1,table2 where table1.key =
table2.key

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

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

Bruno
--
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
http://lists.osgeo.org/mailman/listinfo/fdo-users