Please give me some advice on how to make a transaction work as I have visualized.
I have a database which is vertically oriented, with 4 columns that together form a unique combination
(Station, PartNumber,PartFamily, and ID)., in addition to the values associated with the unique combination
I have an array in my PLC, with the PLC array having ID, values.
I’d like to be able to trigger a transaction that matches the 3 tags of station, part number, part family, for all rows, then matches id for specific array elements; ie array.id=1, so give me the value where select part number=part number tag and part family=part family tag and station=station tag and id =id tag.
I’ve tried as a block and as a standard transaction, but the select on ID value is the part I can’t figure out.
Is this a possible thing or do I need to look at a different approach?
When trying as a standard transaction, I do update/select on the partfamily= part family tag, partnumber=part number tag, and station=station tag.
I think a block is the better way to do what I want, but I haven’t had luck with that either.
I’m using 8.1.5, but I can update if needed, this is a test box.
When I execute the transaction I can get the first matching row to work, but not the next ones, which gives me a write target does not exist message.