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

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

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

[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