Re: [sqlite] what sort of programming errors would cause these strange results

I haven't gotten my daily digest yet from the SQLITE-USERS group, and don't know if there have been responses to my request for help sent yesterday, but I wanted to report that I have found the cause of the errors in the library I'm using. The library is treating SQLite PK columns of INT

Re: [sqlite] What sort of programming errors would cause these strange results?

un...@sqlite.org] On Behalf Of Tim Romano [tim.rom...@yahoo.com] Sent: Tuesday, November 03, 2009 5:21 AM To: sqlite-users@sqlite.org Subject: [sqlite] What sort of programming errors would cause these strange results? I have a SQLite database working quite nicely. The three main tables have 4

[sqlite] What sort of programming errors would cause these strange results?

I have a SQLite database working quite nicely. The three main tables have 4 million rows and 275,000 rows respectively, and query response times are excellent: I have used several GUI front ends to query the data, and they jibe with each other, both with regard to the (accurate) results they