I have a SQL tag query that looks at a table constructed by a transaction group.
The following is my query in which is saved to the tag as a dataset
SELECT top 2 DateTime from Cast_Time order by DateTime desc
The script doesn’t seem to launch. is it because ignition isn’t looking directly at the values in the dataset? If so what datatype would be best to save two datetime values from sql into.
I want to be able to write this value onto a memory tag so that for all the clients can have the correct time being displayed