Ok so we are in the process of upgrading from a very old version FSQL and FPMI to ignition 8.1, most of my transaction groups work fine, but for some reason the one block group does not. I have attached it here. One of two things happens when i attempt to run this transaction block group, either it does work but it constantly adds new rows upon new rows, or it comes up with the error message: can not start group invalid use of the fetch command. I went back to version 3 to check to make sure everything was as it should be and it seems identical so i am not sure what this error indicated because i do not think i used the fetch command in my SQL.
What this group does is it connects a DB, in this case progmode1, to several block OPC items, and when one of the items changes it triggers the block group. And like i said in one setting when i have it set to insert new records it does just that and keeps adding to the database, and when i have it set to use the where clause and use custom, which is what is used in FSQL, it comes up with the error: can not start group invalid use of fetch. and when i use the update first it does not always complete and when i use the other command of update only changed it sometimes comes up with the fetch error.
So should i just move to 8.3 or is there a simple easy fix that i am over looking?
prodtrack_2025-10-28_0632.zip (4.9 KB)