I have a block group transferring data from a PLC to a database table. Each item is a column in the db and an array in the PLC (part of a UDT) 20 elements long. The table has related data in groups of twenty rows with a column PartIndex differentiating them (ranging from 0-19). Another column called LineIndex groups the blocks of 20 rows. I set up the block transfer to use PartIndex as the ‘custom index column’ and in table action I set a custom update/select clause to: LineIndex = 99. I would have expected this to transfer the 20 elements from the PLC to the db and fit them in in the 20 rows that have a LineIndex = 20. However, what it is actually doing is putting blocks of 20 elements into each ‘group’ of twenty rows (i.e. 20 rows that have a LineIndex of 1, 20 rows that have a LineIndex of 2, etc) for a total number of rows written of 320. What’s going on here and how do I correct it? Thanks for any help.
I’ve attached the xml export of what I’m doing.
BlockGroup.xml (5.12 KB)