Transaction groups and UDTs

[dkylep]

Thanks for the input @scicco, you have me contemplating both of those options. I found another thread discussing dynamically creating transactions groups. I've been thinking my way through using a script to modify an XML template and using system.groups.loadFromFile. But, I haven't sold myself on this yet. Keeping track of when to add (possibly remove) transactions groups seems too complicated.

Dynamically-Driven Transaction Groups In SQL Bridge?

No update. It’s still something we want to do, but it would be part of a more fundamental rewrite of SQLBridge/transaction groups, which is a significant undertaking; certainly don’t expect it in the next few months.

I think I'm leaning toward using the tag event script. My thought is to have a new 'update' tag that is on the PLC. If it is simply a bit that switches between a 1 and a 0 I could have tag event script run when the value changes from either 0 to 1 and/or 1 to 0. I'll just have to write the SQL statements myself which shouldn't be too big of deal.