Re: [sqlite] SQLite Delete doesn't work

I figured it out. The select didn't return anything, there was an error in my code. I designed my database with the idT as autoincrementing and when inserting a row i didn't have to insert the id. After that i changed it to a normal field, but forgot to change the insert comand:-) Simon Slavin-2

Re: [sqlite] SQLite Delete doesn't work

On 19 Jul 2009, at 11:20am, Diana Chinces wrote: > I have something like this: > SELECT * FROM Ture WHERE idT = 1 AND data = '19/07/2009' > returns one row. > DELETE FROM Ture WHERE idT = 1 AND data = '19/07/2009' > does not delete the row. If you are doing this inside a program you've written,

Re: [sqlite] SQLite Delete doesn't work

On 19/07/2009 8:20 PM, Diana Chinces wrote: > Hi. > I am having some kind of issues with the delete command when my WHERE expr > is formed from several expression. On the surface, what you say you did should have worked. Hence a whole bag of questions: What version of SQLite? Running on what pla

[sqlite] SQLite Delete doesn't work

Hi. I am having some kind of issues with the delete command when my WHERE expr is formed from several expression. I have something like this: SELECT * FROM Ture WHERE idT = 1 AND data = '19/07/2009' returns one row. DELETE FROM Ture WHERE idT = 1 AND data = '19/07/2009' does not delete the row. -