tq loquin,
but raw value still not change to voltage value after refreshed.i give the code below.what wrong?
Code:
DELETE FROM mts400_results_l
WHERE mts400_results_l.nodeid = new.nodeid;
INSERT INTO mts400_results_l(result_time, epoch, nodeid, parent, voltage, humid, humtemp, prtemp, press, taosch0, taosch1, accel_x, accel_y)
VALUES (new.result_time, new.epoch, new.nodeid, new.parent, new.voltage, new.humid, new.humtemp, new.prtemp, new.press, new.taosch0, new.taosch1, new.accel_x, new.accel_y);
SELECT mts400_results_l.voltage* 625/1024 AS voltage
Code:
SELECT mts400_results_l.voltage* 625/1024 AS voltage
that customised code not work?compilling not have any problem but nothing change in data.still same.tq very much for who can helping me...