# Transaction group update a value into a row of the table data base

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-update-a-value-into-a-row-of-the-table-data-base/47953>\
**Category:** Ignition\
**Created:** [June 18, 2021, 3:22pm UTC](https://forum.inductiveautomation.com/t/transaction-group-update-a-value-into-a-row-of-the-table-data-base/47953 "2021-06-18T15:22:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![phuong.nguyen.sw](https://avatars.discourse-cdn.com/v4/letter/p/9de053/32.png) [@phuong.nguyen.sw](https://forum.inductiveautomation.com/u/phuong.nguyen.sw)\
**Post date:** [June 18, 2021, 3:22pm UTC](https://forum.inductiveautomation.com/t/transaction-group-update-a-value-into-a-row-of-the-table-data-base/47953/1 "2021-06-18T15:22:25Z")

</div>

I create a transaction standard group that I would like to update the Level data into a row of the table very 5 minutes, but I keep got “error during group execution” message, I am not sure what could be wrong. Please would someone could help me.  
Thanks

 ![K64 Level Trans error](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/6/766eb765f8d3cb26470e904912503237676f85c8.jpeg) ![K64 Level Trans](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/7/e7a7f473f6db98111d4ec74a7017f0c5de2b2537.jpeg) ![ParkLevels Table](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/f/dfa06e0fe4445fc2fce5c787456bdbf63c39cec2.jpeg)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [June 18, 2021, 3:38pm UTC](https://forum.inductiveautomation.com/t/transaction-group-update-a-value-into-a-row-of-the-table-data-base/47953/2 "2021-06-18T15:38:07Z")

</div>

If you double-click on the error, it should give you the entire error message.

---

<div class="post-metadata">

**Author:** ![phuong.nguyen.sw](https://avatars.discourse-cdn.com/v4/letter/p/9de053/32.png) [@phuong.nguyen.sw](https://forum.inductiveautomation.com/u/phuong.nguyen.sw)\
**Post date:** [June 18, 2021, 3:44pm UTC](https://forum.inductiveautomation.com/t/transaction-group-update-a-value-into-a-row-of-the-table-data-base/47953/3 "2021-06-18T15:44:50Z")

</div>

Thank you,  
Here is an error message.

 ![Error MSG](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/5/457e65dc419cf5a45e39f534aed5ecf2e8d97dd8.jpeg)

---

<div class="post-metadata">

**Author:** ![phuong.nguyen.sw](https://avatars.discourse-cdn.com/v4/letter/p/9de053/32.png) [@phuong.nguyen.sw](https://forum.inductiveautomation.com/u/phuong.nguyen.sw)\
**Post date:** [June 18, 2021, 3:50pm UTC](https://forum.inductiveautomation.com/t/transaction-group-update-a-value-into-a-row-of-the-table-data-base/47953/4 "2021-06-18T15:50:22Z")

</div>

I did try to delete RecordNo which insert value “163” into Key value now it works.  
Thanks a lot for the info.

---

<div class="post-metadata">

**Author:** ![phuong.nguyen.sw](https://avatars.discourse-cdn.com/v4/letter/p/9de053/32.png) [@phuong.nguyen.sw](https://forum.inductiveautomation.com/u/phuong.nguyen.sw)\
**Post date:** [June 18, 2021, 4:08pm UTC](https://forum.inductiveautomation.com/t/transaction-group-update-a-value-into-a-row-of-the-table-data-base/47953/5 "2021-06-18T16:08:18Z")

</div>

UPDATE, it is working good, I just changed setting in Table Action, Update/select option, Where: RecordNo = 163 which is the key value  
Thanks