Michael,
Thanks for the reply. I know, it's usually the user :)
On 21/06/2012 11:31 PM, Black, Michael (IS) wrote:
You don't show where you inserted your data.
Are you postiive ColC is an integer and you didn't insert it as a string?
You don't show a dump of your table which would be handy.
What does "bomb" mean? Your program gets a seg fault or such?
What are you programming in, on what OS?
I can tell you now if there isn't a simple answer you need to make a
complete example so somebody else can reproduce the problem and see
what you're doing wrong (in all likelihood it's probably you).
I'm using SQLite in C++ code (Windows, MSVC2008, amalgamation). The data
is inserted using sqlite3_bind_int64()/sqlite3_bind_int(). What I mean
by "bomb out" is that it executes this pair of statements tens of
thousands of times (count, then get one row) and works (e.g. "count"
returns more than one and "select" returns one row) and then, once in a
while, count returns more than one, but select doesn't get anything.
Dennis
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
