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!!! -- Fabio Stranieri _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
