to create database on the disk but the I/O to disk cannot keep up with the
input.
Hemant Shah
E-mail: hj...@yahoo.com
--- On Wed, 12/1/10, Black, Michael (IS) wrote:
> From: Black, Michael (IS)
> Subject: Re: [sqlite] Select fails even though data is in the table.
> To: "General
o look for duplicate rows.
> >
> > The problem occurs for some rows only (about 3 to 5 an
> hour).
> >
> >
> > Hemant Shah
> > E-mail: hj...@yahoo.com
> >
> >
> > --- On Wed, 12/1/10, Jim Morris
> wrote:
> >
> >> Fro
/* Main */
if (InsertIntoDatabase(TimeStamp, Source, SeqNum, MD5Sum) == 1)
{
if (GetMessageFromDB(MD5Sum, &FromDb) == 1)
{
/* print message */
}
else
{
/* print error message */
}
}
Hemant Shah
E-mail: hj...@yahoo.com
--- On Wed, 12/1/10, Black, Micha
s for some rows only (about 3 to 5 an hour).
Hemant Shah
E-mail: hj...@yahoo.com
--- On Wed, 12/1/10, Jim Morris wrote:
> From: Jim Morris
> Subject: Re: [sqlite] Select fails even though data is in the table.
> To: sqlite-users@sqlite.org
> Date: Wednesday, December 1, 2010,
gt; --- On Wed, 12/1/10, Jim Morris wrote:
>
>> From: Jim Morris
>> Subject: Re: [sqlite] Select fails even though data is in the table.
>> To: sqlite-users@sqlite.org
>> Date: Wednesday, December 1, 2010, 10:15 AM
>> If you have another thread running
>> that deletes
--- On Wed, 12/1/10, Jim Morris wrote:
> From: Jim Morris
> Subject: Re: [sqlite] Select fails even though data is in the table.
> To: sqlite-users@sqlite.org
> Date: Wednesday, December 1, 2010, 10:15 AM
> If you have another thread running
> that deletes or modifies the t
If you bind the wrong thing the wrong way the return code doesn't matter.
Any particular reason you can't just show us the whole code section?
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
From: sqlite-
Select fails even though data is in the table.
> To: "General Discussion of SQLite Database"
> Date: Wednesday, December 1, 2010, 10:10 AM
> The problem is probably in the bind
> calls that you are not showing.
> If you care to share them we may be able to help.
>
>
If you have another thread running that deletes or modifies the table,
then move the commit to after the select for duplicate to ensure
transactional integrity.
On 12/1/2010 8:10 AM, Black, Michael (IS) wrote:
> The problem is probably in the bind calls that you are not showing.
> If you care to
The problem is probably in the bind calls that you are not showing.
If you care to share them we may be able to help.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org on
ubject: Re: [sqlite] Select fails even though data is in the table.
> To: sqlite-users@sqlite.org
> Date: Wednesday, December 1, 2010, 9:38 AM
> Why are you looking for a duplicate
> with col4 instead of the unique key,
> col2, col3 that caused the collision?
>
> On 12/1/2010
Why are you looking for a duplicate with col4 instead of the unique key,
col2, col3 that caused the collision?
On 12/1/2010 7:29 AM, Hemant Shah wrote:
> Folks,
>
> My C program creates a in-memory database. It creates a table and a unique
> index on two columns. If the insert fails due to uniqu
12 matches
Mail list logo
