Can no longer access pydataset row by column name 8.0.13 rc1

Ignition Early Access
1

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

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

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

Looking into it…

3

Thanks, it’ll get fixed before release.

4

When will this make it into the 8.0.14 nightly?

5

Soonish I think

6

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

7

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

8

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 :slight_smile:

4 Likes
9

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

10

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

2 Likes