Block Transaction Group

Ignition
1

Hello community,
I'm struggling with Block Transaction Group and I need help!

I've created a Block Transaction group with 3 variables, storing into the DB table also the row id, in order to have something similar to key-value database.

This is the transaction group

image
image1031×429 105 KB

And this is the resulting table created with 3 rows each second, with row_id 0, 1 and 2:

image

Now, if I delete the variable in the middle of transaction group (row_id = 1)

image
image1396×409 50.2 KB

The transaction group associates the previous row_id = 1 to a different variable:

image
image904×522 121 KB

As you can see, before the row_id = 1 was associated to the Integer datatype
number, now is associated to the double datatype number.

The problem now is that if I query the table with the row_index = 1 I obtain the wrong result.

Is it possible in some way to keep the row_id always to the same variable??

Thanks everybody for the support.

Regards

2

No.

Consider adding your own unique value ID to store with each row.

1 Like
3

Hi @pturmel, Thanks for your answer. How can I add my value ID to each variable?

4

Add another block item with three constant values and a different target column name.

5

Hi @pturmel, is there a faster solution since I will have up to 5000 variables?

Thanks!

6

You should be scripting your data storage, then. Not using a transaction group. Transaction groups purpose in life is to allow drag-n-drop configuration for those who do not wish to write scripts.