"Fabio Stranieri" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > The program is write in vb6. The original statement with access was: > > rsParam.Open "SELECT * FROM " & nome_tab & " WHERE [data_ora] BETWEEN #" & > Format(ieri_inizio, "yyyy/mm/dd hh:nn:ss") & "# and #" & Format(ieri_fine, > "yyyy/mm/dd hh:nn:ss") & "# ORDER BY [data_ora];", cnAdoCom, adOpenStatic, > adLockReadOnly > > the i have buyed a wrapper for vb6 and sqlite from here: > http://www.eztools-software.com/tools/sqliteplus/default.asp > > then the statement is become: > > Set ds = dbConfig.Exec ("SELECT * FROM " & nome_tab & " WHERE data_ora > BETWEEN " & Format(ieri_inizio, "yyyy/mm/dd hh:nn:ss") & " and " & > Format(ieri_fine, "yyyy/mm/dd hh:nn:ss") & " ORDER BY data_ora" > > but there is something that does not like to sqlite because it goes in > error. But i don't understand what!!!
Between your VB-Code and the sqlite-engine is your (COM-)wrapper and I cannot guarantee that the following works, because I don't know how the wrapper you bought was transferring the Access-Date-Format into the sqlite-DB whilst importing it. In my wrapper the implementation of the cConverter-class is changing these "ADO-Dates" to "normal" SQLite-Text-Dates, which have the form: ShortDate: 'yyyy-mm-dd' DateTime: 'yyyy-mm-dd hh:nn:ss' DateTime + milliseconds: 'yyyy-mm-dd hh:nn:ss.123' In your VB-Format-Function you should probably use a format-string like shown below: Dim D as Date D = Now Debug.Print Format(D, "'yyyy-mm-dd hh:nn:ss'") which in this example gives: '2008-10-09 02:49:09' ...so you could use these return-values for your String- Concats in your Select-Between-Statement for a quick test. If that does not work, then you should read in the docu of your wrapper-provider, in which other format the dates are stored in SQLite after importing from other Databases. Olaf Schmidt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
