Content originally posted in LPCWare by nkarakotas on Wed Nov 07 13:09:05 MST 2012 Hello,
I have a pre-build script incrementing/updating firmware version that is used for firmware upgrades etc. I do remote upgrades and I populate a cost string as follows:
const char MYSQL_OTA_QUERY[] = "SELECT firm_url FROM `trg`.`ota` where hardware_name='"HARDWARE"'AND firmware_version * 1>"MAJOR_STR"."MINOR_STR" ORDER BY firmware_version * 1 DESC LIMIT 1;";
I use the above so I dont need to use RAM. I have noticed that when I change the value of MINOR_STR it doesnt update the string. If I run it a second time it successfully does it. This isnt true for the following defines I also have, these update: #defineMAJORxx #define MINORxx #define REVISIONxx
