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 platform? How are you executing the SELECT and DELETE statements -- the command-line executable? > I have something like this: Please copy/paste *exactly* what you ran, not "something like". We would like to see the output from the select -- make it select rowid instead of * (we don't need to see your data, just some actual output as part of the evidence chain). Include another statement (the same select) that shows that the row is still there. > 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. Also please show us what the CREATE TABLE statement looks like. Aside: should be nothing to do with your problem, but if you were to store your dates in YMD order (e.g. '2009-07-19') indexes and ORDER BY would be much more useful. HTH, John _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
