Re: [sqlite] Insertion and Updation using sqlite3_prepare()

On Feb 8, 2009, at 2:55 AM, Tom Longbotham wrote: > Hello, > > I have just worked through a similar situation. SQLITE would work > correctly for selects but would return SQLITE_DONE when selecting > but the > record would not get updated when doing an update. To confuse > matters more > I

Re: [sqlite] Delete, sometimes doesn't seem to work ...

On 8/02/2009 8:33 AM, Simon wrote: > Difficult to say for sure, but it's possible the Indx of 0 were > inserted with another type (ie, the string "0" and of course, 0 != > "0") If the column is declared as integer (as the OP said) you need to try harder than '0' ... not trimmimg leading/trailing

Re: [sqlite] Delete, sometimes doesn't seem to work ...

thanks Simon and Igor Simon wrote: > Difficult to say for sure, but it's possible the Indx of 0 were > inserted with another type (ie, the string "0" and of course, 0 != > "0") > I guess that might have happened. Igor, I can't try it anymore, because I already deleted the records, I'll try to r

Re: [sqlite] Delete, sometimes doesn't seem to work ...

"Stef Mientki" wrote in message news:498dfd12.7080...@ru.nl > The following statement doesn't seem to work (rows are not removed) > DELETE FROM [_1_aap] WHERE Indx=0 > > But selecting another value than zero, does work (rows are indeed > removed) DELETE FROM [_1_aap] WHERE Indx=1 What does this s

Re: [sqlite] Delete, sometimes doesn't seem to work ...

Difficult to say for sure, but it's possible the Indx of 0 were inserted with another type (ie, the string "0" and of course, 0 != "0") Simon On Sat, Feb 7, 2009 at 4:28 PM, Stef Mientki wrote: > hello, > > I'm a very happy user of sqlite for about 2 years. > And as I'm happy for a long time, >

[sqlite] Delete, sometimes doesn't seem to work ...

hello, I'm a very happy user of sqlite for about 2 years. And as I'm happy for a long time, I forgot all tiny details and funny things. Besides that, I changed from Delphi to Python, and now I'm in trouble :-( So I might have version problems, but that's not the case here, as I've the same probl

Re: [sqlite] Insertion and Updation using sqlite3_prepare()

Hello, I have just worked through a similar situation. SQLITE would work correctly for selects but would return SQLITE_DONE when selecting but the record would not get updated when doing an update. To confuse matters more I could update the record with no problems when using Firefox SQLITE ma

Re: [sqlite] Saving and loading SQLite pages from a buffer

On Wed, 4 Feb 2009 17:55:38 -0500, "D. Richard Hipp" wrote in General Discussion of SQLite Database : >The hot backup API has not yet been released. Look for version 3.6.11. > >If you open your database using the special name ":memory:" then it is >held entirely in memory with no duplication o

Re: [sqlite] Saving and loading SQLite pages from a buffer

On Feb 7, 2009, at 4:56 PM, Alexey Pechnikov wrote: > Hello! > > В сообщении от Thursday 05 February 2009 02:48:25 D. Richard Hipp > написал(а): >> The SQLite core will call the locking methods, but they can be no- >> ops. The read method can be a no-op too, I suppose, if you are only >> using

Re: [sqlite] Saving and loading SQLite pages from a buffer

Hello! В сообщении от Thursday 05 February 2009 02:48:25 D. Richard Hipp написал(а): > The SQLite core will call the locking methods, but they can be no- > ops.  The read method can be a no-op too, I suppose, if you are only   > using the VFS to make a backup.   Oh, and the writes will all be page