# Duplicate field name

**URL:** <https://forums.toadworld.com/t/duplicate-field-name/33027>\
**Category:** Toad for Oracle - Beta\
**Created:** [March 30, 2015, 5:43am UTC](https://forums.toadworld.com/t/duplicate-field-name/33027 "2015-03-30T05:43:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![phyllis.helton\_1150](https://avatars.discourse-cdn.com/v4/letter/p/ac8455/32.png) [@phyllis.helton\_1150](https://forums.toadworld.com/u/phyllis.helton_1150)\
**Post date:** [March 30, 2015, 5:43am UTC](https://forums.toadworld.com/t/duplicate-field-name/33027/1 "2015-03-30T05:43:24Z")

</div>

I’ve noticed this for a while, but keep forgetting to report it.

I have a named SQL that contains a bunch of SQL and PL/SQL statements I use for monitoring some of our daily processes. I have noticed that sometimes after I’ve had it open for a while and try to run one of the queries, I get an error message

[Error] Execution (4: 6): Qry: Duplicate field name ‘JOB\_ID’

If I try to run a different SQL on that tab, I get the duplicate field name error for a different field but what is interesting is I don’t even have a field name in my query that looks anything like the one reported.

[Error] Execution (180: 6): Qry: Duplicate field name ‘Quest$$Toad$$Rec$$No$$\_\_\_’

Copying the entire tab’s contents to another tab, all the SQL runs just fine.

Blessings,

Phyllis

–  
**Phyllis Helton**

Data Magician  
Digital Strategies, Cru | Data Sciences & Analytics  
Office ☎ 407-515-4452

[phyllis.helton@cru.org](mailto:phyllis.helton@cru.org)  
 ![](http://emailassets.cru.org/cdn-crumail/cru.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 31, 2015, 5:54am UTC](https://forums.toadworld.com/t/duplicate-field-name/33027/2 "2015-03-31T05:54:06Z")

</div>

Quest$$Toad$$Rec$$No$$\_\_\_ is an internal hidden field that we use for Row #. I don’t know why it is getting duplicated, unless maybe there was some prior error that prevented the field from being destroyed when the previous query was closed.
