Problem with system.db.runquery , index out of range

Ignition
1

I had an error for retrieving data from one table … more than Row[48] script giving below error. it seems max index is 49 more than 49, the script gave an error .
Is there any workaround??

Traceback (most recent call last):
  File "<input>", line 15, in <module>
IndexError: Column index 49 out of range.

Script :

query= "select top 1 *  from  MSK  where process_id in ('process1','process2','process3','process4') order by id desc"
table = system.db.runQuery(query,'dbname')"
for row in table:
   NewValue=row[0], row[49]
print NewValue
2

Your error is for the column index, not a row index.

3

Yes, error in my script .Thanks Phil