# Can no longer access pydataset row by column name 8.0.13 rc1

**URL:** <https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804>\
**Category:** Ignition Early Access\
**Created:** [May 15, 2020, 9:50pm UTC](https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804 "2020-05-15T21:50:01Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [May 15, 2020, 9:50pm UTC](https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804/1 "2020-05-15T21:50:02Z")

</div>

Can no longer access columns by column name in a pydataset row.

`TypeError: com.inductiveautomation.ignition.common.script.builtin.DatasetUtilities$PyDataSet$PyRow indices must be integers`

```auto
	dbConnection = "Local"
	
	query = """
		SELECT a, b, c
                FROM sometable
		"""
	result = system.db.runPrepQuery(query,[], database = dbConnection)

	firstRow = result[0]
	print firstRow["a"]	

```

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [May 15, 2020, 9:56pm UTC](https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804/2 "2020-05-15T21:56:38Z")

</div>

Looking into it…

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [May 15, 2020, 10:23pm UTC](https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804/3 "2020-05-15T22:23:02Z")

</div>

Thanks, it’ll get fixed before release.

---

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [May 21, 2020, 6:17pm UTC](https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804/4 "2020-05-21T18:17:14Z")

</div>

When will this make it into the 8.0.14 nightly?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [May 21, 2020, 9:38pm UTC](https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804/5 "2020-05-21T21:38:48Z")

</div>

Soonish I think

---

<div class="post-metadata">

**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\
**Post date:** [May 24, 2020, 3:44pm UTC](https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804/6 "2020-05-24T15:44:50Z")

</div>

Ouch, glad I found this post, I guess I was using this in a lot of places. Errors everywhere!

---

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [May 25, 2020, 3:35am UTC](https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804/7 "2020-05-25T03:35:48Z")

</div>

I believe it will be fixed in 8.0.13 final release not 8.0.14.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 26, 2020, 4:40pm UTC](https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804/8 "2020-05-26T16:40:13Z")

</div>

8.0.13 final, PyDatasets will work as they have in all previous versions.  
~8.0.14 (or potentially later, release train goes choo choo) will have all the optimizations that originally caused this regression, plus test coverage that I should have put in in the first place to prevent regressions 🙂

---

<div class="post-metadata">

**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\
**Post date:** [May 29, 2020, 3:16pm UTC](https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804/9 "2020-05-29T15:16:36Z")

</div>

Any idea on 8.0.13 final dropping? I figure its any hour now 🙂

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 29, 2020, 3:18pm UTC](https://forum.inductiveautomation.com/t/can-no-longer-access-pydataset-row-by-column-name-8-0-13-rc1/34804/10 "2020-05-29T15:18:39Z")

</div>

I believe an RC2 is supposed to be out pretty soon. Final in another week or two, probably.