Re: [Gambas-user] SQLTE3 >date function

2010-09-22 Thread Benoît Minisini
> 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, t

Re: [Gambas-user] SQLTE3 >date function

2010-09-22 Thread Bill-Lancaster
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 -- View this message in context: http://old.nabble.com/SQLTE3-%3Edate-function-tp29751718p29776

Re: [Gambas-user] SQLTE3 >date function

2010-09-20 Thread Bill-Lancaster
Dear Benoît, Please see attached - Ive not done this before, hope it works Bill Lancaster http://old.nabble.com/file/p29760629/demo demo http://old.nabble.com/file/p29760629/FMain.class FMain.class -- View this message in context: http://old.nabble.com/SQLTE3-%3Edate-function-tp29751718p2976

Re: [Gambas-user] SQLTE3 >date function

2010-09-19 Thread Benoît Minisini
> I want to extract records between 2 dates from a date type field > (TransDate) but using:- > > hResult = FMain.$hConn.Find("transactions", "TransDate >= '2009-07-01') > produces the same result as > hResult = FMain.$hConn.Find("transactions", "TransDate > '2009-07-01'). > > Also sometimes recor

[Gambas-user] SQLTE3 >date function

2010-09-19 Thread Bill-Lancaster
I want to extract records between 2 dates from a date type field (TransDate) but using:- hResult = FMain.$hConn.Find("transactions", "TransDate >= '2009-07-01') produces the same result as hResult = FMain.$hConn.Find("transactions", "TransDate > '2009-07-01'). Also sometimes records 1 day older