>I want express gratitude to Olaf Schmidt, that he is a great professional
>and available with everybody specially with ignorant people such me!!!!!
Olaf is, in a word, a genius!
>Set ds = m_db.Execute("SELECT * FROM tabella WHERE data_ora BETWEEN " &
>ieri_inizio & " and " & ieri_fine & " ORDER BY data_ora")
Try adding single quotation marks around the 2 date variables:
"SELECT * FROM tabella WHERE data_ora BETWEEN '" &
ieri_inizio & "' and '" & ieri_fine & "' ORDER BY data_ora"
In Access SQL you would enclose the date variables with #.
dhRichClient = End of 20MB ADO desktop installations!!
-Toby
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
