What I’m attempting to do is have ignition log a string based upon what value an integer is.
Say for Example I move a one into the integer FaultStatusCode, I want to log the string “Motor Current Low” into the SQL table instead of a one. If I move a two into FaultStatusCode, I want to log the string “Motor Current High” into the SQL table.
Here’s some pseudocode to help explain what I’m wanting to do:
IF FaultStatusCode=1 THEN
WRITE “Motor Current Low”
IF FaultStatusCode=2 THEN
WRITE “Motor Current High”
I’m going to have more than three options, but this should suffice to get the concept across. I’ve got a long way to go with ignition, but if I can handle this with the SCADA it will save me time associating strings with a status indicator in the PLC.