Error "A component name 'columname' from table already exists" when executing query. (4311289)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error "A component name 'columname' from table already exists" when executing query.
Description

Select * from table works fine. However, selecting from specific columns results in the following error:

"A component name field10 from table already exists"

This error repeats for multiple columns i.e. field10, field17, field18 etc. then eventually shows results.
Resolution

RESOLUTION #1:

Add an alias to each column queried i.e

select field1 aliasname1,
field2 aliasname2,
.
.
.
from tablename

RESOLUTION #2:

Upgrade to latest version of Toad, which can be downloaded here.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title