Help with an Action Item SQL Query

Yeah, in those screen shots it looks like you’re trying to write the action items back to opc items, which aren’t really opc items, 'cause they don’t actually map to opc… which isn’t going to work.

If you want to map an action item to a database column, just type the column name in the box (“LogEnd” and “LogStart”, without quotes). Then delete the unnecessary opc items.

It sounds like you kind of tried this, but ran into a different problem… my guess is that you have your table set to not allow nulls, and when you started the group it tried to write a null on the first execution, before it had all of the values. That’s actually fine for a table set up like that, the subsequent executions should be fine.

So, I’d give it another shot, and see if it works at all. If you keep getting errors, we can look further into those.

Regards,