Transaction group issue – Block group using previous / buffered data

[pturmel]

This is a known issue:

Writing Variable Number Of Rows to PLC Array

I am trying to use a block group to write a variable number of rows from a SQL database to my PLC array using the SQL Bridge Module. The problem is that if the results is less than the last query, then it will fill the array with the new data and entries from the old data. Is there a way to clear the block data after it writes to the PLC?

There doesn't seem to be a bug number in the post. You may want to contact support to see where this stands. (You will certainly have to upgrade Ignition for any fix, once available.) The workaround would be to replicate your transaction group functionality with a script.