HI, All
Never tried, but if to update the db remotely, i think it's easy to prepare the DB dump text file, and execute after downloading.
But how to execute it in B4J and B4A ?
Never tried, but if to update the db remotely, i think it's easy to prepare the DB dump text file, and execute after downloading.
BEGIN TRANSACTION;
CREATE TABLE [ref_sensors] ([id] INTEGER PRIMARY KEY, [subid] INTEGER, [type_ids] TEXT);
INSERT INTO ref_sensors VALUES(1,101,'101, 102');
INSERT INTO ref_sensors VALUES(2,201,201);
CREATE TABLE [sensor_commands] ([id] INTEGER PRIMARY KEY, [state_id] INTEGER, [name] TEXT, [command] TEXT);
CREATE TABLE [sensor_data] ([id] INTEGER PRIMARY KEY, [state_id] INTEGER, [val] TEXT, [time] TEXT, [stamp] TEXT);
CREATE TABLE [sensors] ([id] INTEGER PRIMARY KEY, [port] TEXT, [sensor_id] INTEGER, [type_id] INTEGER, [period] TEXT, [visible_interval] REAL, [line_color] TEXT, [point_color] TEXT, [line_size] INTEGER, [point_size] INTEGER, [active] TEXT, [linked] INTEGER, [time] TEXT, [miny] REAL, [maxy] REAL, [fixed_y] INTEGER);
COMMIT;
But how to execute it in B4J and B4A ?
Last edited: