I’m trying to make a script system.db.runquery. This is my code:
table = system.db.runQuery("SELECT * FROM adm_supplier","dscada_main")
for row in table:
if(value == row["ID_SUPPLIER"]):
The output is this:
The output is correct because I have one line that is ‘test’ while others no.
I want that when the value is present in a row I return ‘ok’, otherwise ‘no’.
It now returns all four lines, but I want you back only a line saying ‘ok’ if it exists, otherwise ‘no’
How can I fix?