[Gambas-user] SQLTE3 >date function

[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 contain any data. So when you compare a field to a date (without 
using the DATE function), how does it behave?

-- 
Benoît Minisini