I have a table in SQL that I would like to download into an array of tags in my PLC (via OPC server, of course). The table contains employee information and all I need is the employee name and corresponding employeeID. I have tags set up in the OPC server to handle up to 60 employees. So the query can contain up to 60 records of 2 fields each and then FSQL will transfer the results to the OPC tags.
I’ve tried using a stored procedure group object but that doesn’t seem to work unless I provide 120 output parameters.
I’m looking at the block group object but I can’t quite figure out how to make it work.
So, all in all, I’m looking for the best way to collect a variable, but limited, quantity of records and transfer them to my PLC.