Re: [gnome-db] SQLite provider and GdaTimestamp (4.2.2)
Vivien Malerba <[email protected]>
| Newsgroups | gmane.comp.gnome.db |
|---|---|
| Message-ID | <[email protected]> |
On 29 November 2010 19:50, Piotr Pokora <[email protected]> wrote: > Hi! > >> I guess the commit in >> >> http://git.gnome.org/browse/libgda/commit/?id=a8336ee7576ac5ce74281ab9573798380049f97c >> should fix this. > > Yes. Thanks! Ok, great! > >> However I strongly encourage you to use variables in your SQL >> statements (for example ##thedate::timestamp) instead of rendering SQL > > Does it mean, prepared statement with variables is also a fix (in my case) ? No, it's just that I had not discovered the bug because I rarely render SQL with values in my programs, and this code is mostly used when rendering values in SQL statements. Your program should now work correctly with the correction above. Regards, Vivien