[sqlite] Unique Constraint Failed

table that is maintained or if any of the code that is used for this has been changed in the last couple of years. 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

[sqlite] Unique Constraint Failed

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

[sqlite] Unique Constraint Failed

. I have tested this same to a 1.4TB file, but have updated my copy of SQLite source since that test. Thanks, 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

[sqlite] Create Index after Data Populated

Hi, I have a database that is populated with data (and more being added) and I have realized that I need an extra index to speed up access. How long should it take to update the Index. There are about 1billion rows in the database Thanks, Andrew Stewart Software Designer

Re: [sqlite] 1TB limit on encrypted database

work. Andrew Stewart Software Designer Argus Control Systems Ltd. Tel: (604) 536-9100 ext. 108 astew...@arguscontrols.com #101 - 18445 53rd Avenue | Surrey BC | CANADA | V3S 7A4 (604) 538-3531 | (800) 667-2090 | Fax (604) 538-4728 www.arguscontrols.com -Original Message- From: sqlite

Re: [sqlite] 1TB limit on encrypted database

Thanks. This has worked. Andrew Stewart Argus Control Systems Ltd. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, November 14, 2017 12:34 PM To: SQLite mailing list <sqlite-us

Re: [sqlite] 1TB limit on encrypted database

Richard, If I am trying to change the max_page_count use the SEE.EXE program, how do I get the value to be updated in the database. Every time I try changing this and then exit see.exe, the value has not changed. Do I need the updated encryption extension first? Andrew Stewart Argus

[sqlite] 1TB limit on encrypted database

Hi, I appear to have reached an issue with a 1TB limit on an encrypted database. The page_size is 1024. The max_page_count is 1073741823. I don't appear to be able to change either of these numbers. Any assistance would be appreciated. Andrew Stewart Argus Control Systems

Re: [sqlite] Unresolved External sqlite3_user_add

...@mailinglists.sqlite.org] On Behalf Of Dan Kennedy Sent: Tuesday, February 21, 2017 10:13 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Unresolved External sqlite3_user_add On 02/22/2017 12:47 AM, Andrew Stewart wrote: > Hi, > I am trying to add the authenti

[sqlite] Unresolved External sqlite3_user_add

it during the link. I added "pragma message()" lines to the sqlite3.c code to see that it was going into this block and it was. Have tried everything else that I can think of and still no luck. Any help would be appreciated. Thanks, Andrew Stewart Software Designe

Re: [sqlite] Issue with Malformed table

Simon, Forgot to ask 1 thing. What is a quick way to copy an entire table from database1 to database2? Thanks, Andrew -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Andrew Stewart Sent: Wednesday, November 16, 2016 7:16

Re: [sqlite] Issue with Malformed table

ubject: Re: [sqlite] Issue with Malformed table On 16 Nov 2016, at 2:52pm, Andrew Stewart <astew...@arguscontrols.com> wrote: >I have a table that is giving me errors. I can recover the > data from another source, but need a way to clear the table. This process is

[sqlite] Issue with Malformed table

. I think I know what is causing the original errors and I have fixed it, but I want to come up with a way to fix tables so I am testing this. Thanks, Andrew Stewart Software Designer Argus Control Systems Ltd. Tel: (604) 536-9100 ext. 108 astew...@arguscontrols.com<mailto:as

Re: [sqlite] Drop Temporary table is returning Locked

Of Andrew Stewart Sent: Friday, July 29, 2016 12:16 PM To: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Subject: [sqlite] Drop Temporary table is returning Locked Hi, I am having issues when I need to translate a database that already exists (adding a field). I

[sqlite] Drop Temporary table is returning Locked

= 2048 PRAGMA cache_size = 10 PRAGMA temp_store = MEMORY SQLite version 3.9.2 is what I am using. Any assistance would be appreciated. Andrew Stewart Software Designer Argus Control Systems Ltd. Tel: (604) 536-9100 ext. 108 astew...@arguscontrols.com<mailto:as

[sqlite] The database disk image is malformed

On 7 Jan 2016, at 3:09pm, Andrew Stewart wrote: > I have run the Quick Check. The results are below. This database is written > to once a minute. One minute it was working and the next it was not. What > would cause it to suddenly have errors? Hardware fault. Loss of power.

[sqlite] The database disk image is malformed

ell 38: 2nd reference to page 77571738> Regards, Andrew Stewart -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Andrew Stewart Sent: Tuesday, January 05, 2016 8:12 AM To: 'SQLite mailin

[sqlite] The database disk image is malformed

does have the compression attribute turned on. The database time/date is still getting adjusted. Andrew Stewart Software Designer Argus Control Systems Ltd. Tel: (604) 536-9100 ext. 108 astewart at arguscontrols.com<mailto:astewart at arguscontrols.com> #101 - 18445 53rd Avenue | Sur

[sqlite] Making data unique

On Behalf Of > Andrew Stewart > Sent: Monday, 7 December, 2015 08:01 > To: 'SQLite mailing list' > Subject: [sqlite] Making data unique > > Hi, > I have a table that consists of 3 elements: > ID - integer > Date/time - integer > Data - integer >

[sqlite] Making data unique

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-

[sqlite] Making data unique

ique. 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

[sqlite] 10 minute Avg

-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R Smith Sent: Thursday, November 19, 2015 7:40 AM To: sqlite-users at mailinglists.sqlite.org Subject: Re: [sqlite] 10 minute Avg On 2015/11/19 4:49 PM, Andrew Stewart wrote: > Hi, >

[sqlite] 10 minute Avg

/11/18 9:23 PM, Andrew Stewart wrote: > Ryan, > Like the code. Was wondering what adjustment I would make to get if I > had 2 (or more) firmwareIDs that I wanted to get the average for. Say get 10 > minute average for fwParameterID 1074 & fwParameterID 1073. I am having &g

[sqlite] 10 minute Avg

anging > just the first line inside the CTE. Just inject those values via > your code. > > Let us know if there's anything unclear or not working as expected, > Cheers! > Ryan > > > > On 2015/11/18 6:15 PM, Andrew Stewart wrote: >> Hi, >>

[sqlite] 10 minute Avg

) and not have it fixed to position in a string. Thanks, Andrew S -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Andrew Stewart Sent: Wednesday, November 18, 2015 8:45 AM To: 'SQLite mailing list

[sqlite] 10 minute Avg

Sent: Wednesday, November 18, 2015 8:41 AM To: SQLite mailing list Subject: Re: [sqlite] 10 minute Avg On 11/18/15, Andrew Stewart wrote: > Hi, > I am trying to generate 10 minute average data for a > day from a data set. Table is created by the following: > &g

[sqlite] 10 minute Avg

Hi, I am trying to generate 10 minute average data for a day from a data set. Table is created by the following: CREATE TABLE dataStreamRecord (fwParameterID INTEGER NOT NULL, dateTime DATETIME NOT NULL, data INTEGER NOT NULL); Sample Data fwParameterID,dateTime,data