We have a fairly widely used table in MSSQL that we just added several columns to, all REAL. I am writing the data to these columns every 5 seconds with query tags, and am having a funny time with one of them.
One of my columns reverts to NULL between writes. If I disable the query, the entire column reverts to NULL. If I change the column name or create a new column, I don’t have the problem.
As far as I know and intended, I only write to this column from these tag queries. Anyone know why they might be doing this? I suspect it’s a lingering tag query setting in the gateway, but I’m not sure.