> I don't think the test programme arrived! > > Anyway, I have found that using the SQLitte3 DATE function solves the > problem, so:- > > AND DATE(TransDate) >= '2009-07-01' produces the correct result. > > Thanks
I'm thinking: contrary to other database systems, sqlite fields are not typed, they can contain any data. So when you compare a field to a date (without using the DATE function), how does it behave? -- Benoît Minisini ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user