“old data” is a relative term. The table I am creating in PMI is for an engineer who wants to select 10 parameters from an available 100 and literally watch the values on the screen as the machine cycles. I have given him the option of exporting the info to Excel if he chooses. Most of the time he will see what he needs to see within the first few minutes and then move on. He may do this numerous times within the same day. Because of this last point, I need to make sure that the next time he goes to view his data, all of the older data is purged from the table; or at least, not visible for the new selected group. I do have to leave 1 row of data so the table does not error out.
WHERE sv3_machine_data_ndx > 30”)
I tried the above code, but received an error. I have attached a screen shot of the error.
I don’t mind rethinking the whole thing if I have to, but because I cannot nail down the time frame between logging incidents, I cannot build the clear table into SQL.