# Transaction Group Read Only Problem

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-read-only-problem/3323>\
**Category:** Ignition\
**Created:** [September 23, 2011, 12:29pm UTC](https://forum.inductiveautomation.com/t/transaction-group-read-only-problem/3323 "2011-09-23T12:29:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\
**Post date:** [September 23, 2011, 12:29pm UTC](https://forum.inductiveautomation.com/t/transaction-group-read-only-problem/3323/1 "2011-09-23T12:29:32Z")

</div>

Hey guys,

I think I found a problem with the transaction block group. I have one block item that is really just a trigger and another that has the data that I want to write to the database. I set the trigger group to “Read Only” but it still tries to write that column to the database and throws up an error that the column name already exists. You can see in the picture below that the column name “Product Number” is grayed out but it is still trying to write this group item to the product number column and giving the error below.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/169ea75776d51ece65f3d507ecb08db042e920b9.png)  

The only way I can get the transaction group to work properly is if I actually write that column to the database, not a big deal but FYI for someone to look at. Thanks!

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [September 23, 2011, 3:57pm UTC](https://forum.inductiveautomation.com/t/transaction-group-read-only-problem/3323/2 "2011-09-23T15:57:07Z")

</div>

Hmm, yeah, we’ll have to look at that.

And, I suppose you’re using it for the “async trigger” (on change) option, because otherwise you can’t really use block items for triggers. You would use an accessory opc item instead. Is that right?

Regards,

---

<div class="post-metadata">

**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\
**Post date:** [September 23, 2011, 4:09pm UTC](https://forum.inductiveautomation.com/t/transaction-group-read-only-problem/3323/3 "2011-09-23T16:09:01Z")

</div>

That’s correct, I’m looking for any change in the transaction count block item as a trigger. It works great as long as I pick database column for target type.

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [September 23, 2011, 4:38pm UTC](https://forum.inductiveautomation.com/t/transaction-group-read-only-problem/3323/4 "2011-09-23T16:38:51Z")

</div>

Ok, I’ve tracked it down. Sadly, not in time for the fix to make it into 7.2.9, but it will be in 7.3. In the mean time, you’ll just have to let it write to the column.

Regards,

---

<div class="post-metadata">

**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\
**Post date:** [September 23, 2011, 5:36pm UTC](https://forum.inductiveautomation.com/t/transaction-group-read-only-problem/3323/5 "2011-09-23T17:36:04Z")

</div>

No problem, I’m fine with that. Just thought you’d like to know 😛 Thanks for looking into it!