I am playing with FactorySQL to get a good feel of how it would work for our usage and came up with an error. I am trying to read a recipe from a DB to the Kepware simulation OPC. THe database is created with a column called Recipe_Name. This column is a string and I have stored a string of HX123 in the data table. Kepware has an item device called Recipe_Name which is also called out as a string. There is also 3 other columns and Kepware items. When I run the group and trigger the DB to OPC, I get an error stating "Unexpected error excuting group. Conversion from string “HX123” to type ‘Integer’ is not valid. If I change the data in the DB to 111 then it works. I also went into Kepware and was able to manualy put in HX123, but for some reason when FactorySQL brings it over, it is trying to convert to an integer.
We do not have our license yet, so this is just testing and running as a demo.