Thank You for the help everyone.
The problem was in my query. I have a trigger that updates the a
"last_modified" field anytime there is an update on a given record. My query
has a where clause that says ... last_modified < current_timestamp. So if
there were any updates that occur during the
On 2/27/2013 1:10 PM, mike.akers wrote:
Well, after I made the change I am still seeing the same issue. I added some
print statements that will maybe help.
What does your select statement look like? What does your update
statement look like? Any chance you can show a complete sample that
Oh, nice catch.
Well, after I made the change I am still seeing the same issue. I added some
print statements that will maybe help.
It sounds like you might think it is because I am not closing my statement
is the reason I am getting this issue? I was thinking if it were only that
then no matter
On 2/26/2013 9:27 AM, mike.akers wrote:
Yes I believe so. For my UPDATES, currently (things have moved around quite a
bit for me trying to solve this)
sqlite3_exec(this->hDBC_, "BEGIN EXCLUSIVE TRANSACTION;", NULL, NULL, 0);
sqlite3_prepare_v2(this->hDBC_, updateStatement, -1, >hStmt_, 0);
COT_EVENT_TABLE = "CREATE TABLE MAIN_TABLE( pk char(41) primary key,\
item1 real,
\
item2
char(64), \
Yes I believe so. For my UPDATES, currently (things have moved around quite a
bit for me trying to solve this)
sqlite3_exec(this->hDBC_, "BEGIN EXCLUSIVE TRANSACTION;", NULL, NULL, 0);
sqlite3_prepare_v2(this->hDBC_, updateStatement, -1, >hStmt_, 0);
sqlite3_bind_blob(this->hStmt_, 1, blob,
> Example, If I insert 10 records and loop a query I receive
> 10, 10, 10, 10, results
> But, if I change one of the records during the loop I get
> 10, 10, update record, 9, 10,
This sounds gibberish. Could you please post your database schema and
exact queries you issue in the exact
Are you finalizing the UPDATE statement?
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of mike.akers
Sent: Monday, February 25, 2013 4:48 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Memory DB - Query does not return all
I am using an in-memory database with a singleton containing a single
connection. I have multiple threads (3) using this same connection, but I
have ensured that only 1 thread uses the connection at a time.
If I do an UPDATE on a record then immediately preform a SELECT, the query
will return all
9 matches
Mail list logo