Hi Simon,
I am having a problem receiving the emails and therefore cannot
do this as a reply to the message. I am seeing your responses on the forum
site.
Below is the DDL for creating the table. It should not be
possible for 2 elements to have the same time/ID unless I am redoing the data.
This data comes live from a greenhouse control system.
CREATE TABLE dataStreamRecord (
fwParameterID INTEGER NOT NULL,
dateTime INTEGER NOT NULL,
data INTEGER NOT NULL,
UNIQUE (
fwParameterID,
dateTime
)
);
Andrew Stewart
Software Designer
ARGUS CONTROLS
18445 53rd Avenue | Surrey, BC | V3S 7A4 | Canada
t +1.604.538.3531 ext. 108 | +1.800.667.2090 | f +1.604.538.4728
www.arguscontrols.com<http://www.arguscontrols.com/>
Notice: This electronic transmission contains confidential information,
intended only for the person(s) named above. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or any other use of this email is strictly prohibited. If you have received
this transmission by error, please notify us immediately by return email and
destroy the original transmission immediately and all copies thereof.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
