a rookie here. would like to get your inputs on my current situation:
I currently have a tag dataset that is identical to a table on the SQL [1Row x 30 Columns].
tag dataset is updated with the modifications made on its properties and I want to update the SQL table after pressing a button on the ignition.
I would like to know if there is a better way of updating the SQL table than using the below query?
UPDATE mytable SET column1 = 'new value 1', column2 = 'new value 2', column3 = 'new value 3', ..., column16 = 'new value 16' WHERE id = 1;
Doing this makes me think that it is better to use a UDT tag than a tag dataset.