I don't want to overwrite. An error or rejecting the Insert will work. Thanks, Andrew
-----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Adam Devita Sent: Monday, December 07, 2015 7:14 AM To: SQLite mailing list <sqlite-users at mailinglists.sqlite.org> Subject: Re: [sqlite] Making data unique When you are about to insert into the table and find that ID & Date/time are identical to another record, but the data is different, do you want to overwrite, or not? Do you want an error? Adam On Mon, Dec 7, 2015 at 10:01 AM, Andrew Stewart <AStewart at arguscontrols.com> wrote: > Hi, > I have a table that consists of 3 elements: > ID - integer > Date/time - integer > Data - integer > A single ID can exist multiple times. > A single Date/time can exist multiple times. > An ID & Date/time combination is unique. > > What is the best way to ensure uniqueness in this table. > > Thanks, > Andrew Stewart > Software Designer > > Argus Controls > #101 - 18445 53 AVE > Surrey, BC V3S 7A4 > > t: 1-888-667-2091 ext : 108 > t: 1-604-536-9100 ext : 108 > f: 604-538-4728 > w: www.arguscontrols.com<http://www.arguscontrols.com/> > e: astewart at arguscontrols.com<mailto:astewart at 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 at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- -------------- VerifEye Technologies Inc. 151 Whitehall Dr. Unit 2 Markham, ON L3R 9T1 _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users