Here is the error:
I have a group that has 26 opc items in it that writes based on a trigger. This works fine. I then added an action item with an expression that returns “Test”. Result data type is string. Store result to DB field is checked and field name is EventID. The field in SQL was created automatically and type is varchar(255).
When the group is triggered I get the above error and nothing is written.
Here is the error in the log
[quote]SqlCommand.Prepare method requires all variable length parameters to have an explicitly set non-zero Size.
at System.Data.SqlClient.SqlParameter.Prepare(SqlCommand cmd)
at FactorySQL.Database.BufferedExecution.BufferedExecutor.StoreSet(CommandExecutionSet CommandSet)