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:

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, they can

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:

[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 than

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 records 1 day older