# Block transaction group update (not insert)

**URL:** <https://forum.inductiveautomation.com/t/block-transaction-group-update-not-insert/12377>\
**Category:** Ignition\
**Created:** [November 17, 2016, 9:47pm UTC](https://forum.inductiveautomation.com/t/block-transaction-group-update-not-insert/12377 "2016-11-17T21:47:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![richardNZ15](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/richardnz15/32/33373_2.png) [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\
**Post date:** [November 17, 2016, 9:47pm UTC](https://forum.inductiveautomation.com/t/block-transaction-group-update-not-insert/12377/1 "2016-11-17T21:47:41Z")

</div>

Hi guys,

I have a table in SQL that i would like to update in Ignition. I would like to update a block of data (10 rows, multiple columns) every time.  
I set up a block group how i thought i would need to. With a block of tags linked to a column name in my table.

The problem i have is i think Ignition requires a block\_id in the table to figure out which rows it needs to update. But i don’t have/want a block\_id and row\_id in my table.  
I want to use the SerialNum as the key.

How can i do this in a block group? I noticed there is a custom update entry but i don’t really know the syntax for something like:

```auto
WHERE SerialNum = (PieceSerial tag)
```