# Problem with displaying data of a table containing column named RECNO

**URL:** <https://forums.toadworld.com/t/problem-with-displaying-data-of-a-table-containing-column-named-recno/8904>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [October 27, 2009, 8:03am UTC](https://forums.toadworld.com/t/problem-with-displaying-data-of-a-table-containing-column-named-recno/8904 "2009-10-27T08:03:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [October 27, 2009, 8:03am UTC](https://forums.toadworld.com/t/problem-with-displaying-data-of-a-table-containing-column-named-recno/8904/1 "2009-10-27T08:03:49Z")

</div>

Hi

I’ve just installed new 10 version of Toad and annoying problem came up. In my database many tables have a column named RECNO. when I try to see data in a grid, error ‘Duplicate field name RECNO’ appears. Did you come across with a problem of this kind? It’s easy to reproduce. Just create table with one column RECNO NUMBER(10). I’ve checked it on two computers and the problem still exits. Toad 9.7 works fine though.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [October 27, 2009, 8:38am UTC](https://forums.toadworld.com/t/problem-with-displaying-data-of-a-table-containing-column-named-recno/8904/2 "2009-10-27T08:38:52Z")

</div>

This will be fixed in the coming patch.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [October 27, 2009, 8:39am UTC](https://forums.toadworld.com/t/problem-with-displaying-data-of-a-table-containing-column-named-recno/8904/3 "2009-10-27T08:39:00Z")

</div>

Hi,

This is fixed in the patch build soon to be released.
