I'm trying to replace db access from my vb6 program to sqlite. But this query no work
"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" where ieri = Date - 1 ieri_inizio = ieri & " 00:00:00" ieri_fine = ieri & " 23:59:59" can we help me? -- Fabio _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
