Transaction groups, block group, item data type dataset

Ignition
1

Hi to All,

I am sorry if this question already exists, I couldn’t find it.
I have a memory tag which data type is dataset (two columns and xx rows). I wont to use transaction groups as I will insert data from dataset tag in SQL database (table with 2 columns).
Is it possible?
I have tried a lot of different configurations and I didn’t succeed.

Thanks!

2

You cannot do this. Datasets cannot be stored to history nor included in a transaction group. If you must record a dataset, you will have to write a custom script to insert its contents to the DB row by row.

3

Ok. Thank you very much on your answer.
I am not surprised, but possibility to set data type to Data Set made me think that is possible.

Thanks!

4

But with block group I do not have to insert row by row in DB I can insert an Array, for example of strings?

5

Did you figured it out? I having the same question. I wish there was a system.db function to do a block transfer.

6

You can construct multi-row insert statements in scripts if your DB supports such syntax. The key is making sure the final list of arguments matches the number of substitution points in your SQL.

7

Will give that a try. I am using mysql as my database.