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

Bruno Scott bscott at geomapgis.com
Wed Jan 2 04:27:01 EST 2008


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.



More information about the fdo-users mailing list