Archives of the TeradataForum

Message Posted: Wed, 11 Aug 2010 @ 13:49:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Are you saying that you issue something like

     SELECT * From Table1, Table2

where both tables contain a column with the same name?

I would like to be sure of the exact problem before I look into it.

SQL Assistant 13.10 uses a newer version of the Microsoft Access dlls but 13.0 still used the same version as 7.2 and 12.0, so it is odd that anything would have changed there.

We do however now work through the Microsoft .Net Framework so the exact logic when creating the tables will have changed slightly. That may be enough to cause it to throw an error rather than to use some kind of built in error handling. (SQL Assistant never created columns with names like 'field8' so the Access dlls must have been doing that automatically.)

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>