Re: [sqlite] DELETE only deletes some records, not others

Corey Nelson wrote: > sqlite> DELETE FROM GBP_CHF_BID WHERE price LIKE "12.%"; > sqlite> SELECT * FROM GBP_CHF_BID WHERE price LIKE "12.%"; > 129435210|12.0169 [more results snipped] I'd suspect a corrupted database. Run PRAGMA integrity_check; , see what it says. --

[sqlite] Python _sqlite3.pyd as Native Pythpn (was: catching sqlite errors...what to know)

You might want to grab the _sqlite3.py module from the pypy distribution. This is a "native python" implementation of the _sqlite3.pyd extension. It will at least let you know exactly how the python dbapi is implemented using the native SQLite C API. It might help in tracking down the

Re: [sqlite] catching sqlite errors...what to know

On Sun, 8 Jul 2012 13:22:42 -0400, C M wrote: >I thought SQlite never did anything in a half way state anyway? I >thought that if something failed to be written it was rolled back? >(Pardon if I'm mangling the terminology or misunderstanding it badly). Unless you use

Re: [sqlite] DELETE only deletes some records, not others

Quoth Corey Nelson , on 2012-07-08 00:15:36 -0600: > sqlite> SELECT * FROM GBP_CHF_BID WHERE price LIKE "12.%"; Aside from the more immediately relevant aspects the other posters already mentioned, remember that double quotation marks in SQL are normally used for

Re: [sqlite] DELETE only deletes some records, not others

On 8 Jul 2012, at 7:15am, Corey Nelson wrote: > sqlite> SELECT * FROM GBP_CHF_BID WHERE price LIKE "12.%"; If price is a numeric field, then instead of the above, use > SELECT * FROM GBP_CHF_BID WHERE price >= 12 AND price < 13; Simon.

Re: [sqlite] DELETE only deletes some records, not others

I've never really used sqlite, but here's a lucky guess based on other databases I have used. Is 'price' column a Numeric field with decimal places? If so, I think that's your problem. For some reason when using LIKE on Select statement it automatically casts price to a String, and so the like

[sqlite] DELETE only deletes some records, not others

Some bad data found it's way into my database and I'm trying to delete it. But my DELETE command is only deleting some of the records while leaving most as is. See below. The sqlite database file is here . Am I doing something wrong?

Re: [sqlite] catching sqlite errors...what to know

Thanks for the help, just getting back now. > Your message indicates you are using Python. You should be using > transactions and context managers. This ensures that things either > complete or don't, not some half way state. I thought SQlite never did anything in a half way state anyway? I

Re: [sqlite] catching sqlite errors...what to know

On Sun, Jul 1, 2012 at 12:12 PM, Simon Slavin wrote: Thanks for the help. Sorry to not get back sooner. >> 1) locked database (due to using SQLite Database Browser to change a >> database but not Saving it) >> 2) sqlite3.OperationalError: SQL logic error or missing

Re: [sqlite] sqlite 3.7.13 download link

There is a bogus page at http://www.sqlite.org/download.html/ That points to the wrong link. The added / causes the problem Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems

Re: [sqlite] sqlite 3.7.13 download link

Ok, I see, the problem is I sometimes reach pages from web search. So the query [sqlite download] shows in the google www.sqlite.org/download.html/ (with slash), it's identical to the one without slash, but every link at this

Re: [sqlite] sqlite 3.7.13 download link

> Is everything ok with amalgamation link for sqlite 3.7.13? > When I click on the link nothing happens, different browsers, local > networks, the same result. > Just in case for the TCP/IP request on 80 port > www.sqlite.org/download.html/sqlite-amalgamation-3071300.zip Link should be:

[sqlite] sqlite 3.7.13 download link

Hi, Is everything ok with amalgamation link for sqlite 3.7.13? When I click on the link nothing happens, different browsers, local networks, the same result. Just in case for the TCP/IP request on 80 port www.sqlite.org /download.html/sqlite-amalgamation-3071300.zip The header is HTTP/1.0 200

Re: [sqlite] Linux "managed only" issue(?)

On 07/07/2012 22:33, Joe Mistachkin wrote: Dave Edwards wrote: > >Anyone know of any bugs with Mono 2.6 or debian 6 that could cause this >as it might be there rather than here I should be looking? > I seem to recall that System.Data.SQLite does not work correctly on Mono less than about 2.8;