I am trying to get user loaded text from PMI inserted into a db. I need it to write to the db on a change in a sensor value ( on/off ). I have created the table and have written the attached script:
if event.source.value == '1':
fpmi.db.runUpdateQuery("INSERT INTO Shower_Data (description, date_lot, t_stamp)
VALUES (event.source.parent.getComponent('Inflator Desc Sensor 1').text,
event.source.parent.getComponent('Date_Lot Sensor 1').text,
I am trying to assign this to a number label on a property change action.
Carl – How bad have I messed this up?