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 wrote: > > > 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, try executing > those commands instead in the sqlite3 command-line program. See if > you get the same results. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/SQLite-Delete-doesn%27t-work-tp24555652p24557115.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
