Re: Re[2]: [sqlite] Problems Insert with Date and Time values

2007-12-14 Thread Giuliano
Thank you again for all you work.. Giuliano - Original Message - From: "Ion Silvestru" <[EMAIL PROTECTED]> To: "Giuliano" <sqlite-users@sqlite.org> Sent: Friday, December 14, 2007 10:08 AM Subject: Re[2]: [sqlite] Problems Insert with Date and Time

Re: [sqlite] Problems Insert with Date and Time values

2007-12-14 Thread Giuliano
Thanks a lot! any suggestion for a query then that read and compare dates, for ex.: SELECT somefiled FROM sometable WHERE datefield1 BETWEEN ' '? AND ' '? How can I query then the string values as date? Thanks again Giuliano - Original Message - From: "Ion Silvestru&quo

[sqlite] Problems Insert with Date and Time values

2007-12-13 Thread Giuliano
Hello, is it possible (how?) to insert into 2 different fields (date) the following values: 09:30:00(only a time value...) 14/07/07 (only year value, 14th of december 2007) sorry, I am not be able at all to do that. Many thanks in advance for helping, Giuliano

[sqlite] Cannot build VC++ VS2005 SQLite3vb

2007-12-09 Thread Giuliano
symbol sqlite3_apis sqlite3.def : error LNK2001: unresolved external symbol sqlite3_auto_extension .. for about 48 times... I think is something missing in my configuration, maybe the .def file. help...please.. Giuliano

Re: [sqlite] Wrapper ADO like for VB6

2007-09-26 Thread Giuliano
, September 26, 2007 2:47 PM Subject: RE: [sqlite] Wrapper ADO like for VB6 I am using dhSQLite, which you can download from here: http://www.thecommon.net/2.html I have tried several wrappers for VB(A) (about 4 or 5) and this is the best one. Good support as well. RBS -Original Messa

[sqlite] Wrapper ADO like for VB6

2007-09-26 Thread Giuliano
in advance, Giuliano