On 10/8/08, Fabio Stranieri <[EMAIL PROTECTED]> wrote: > 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!!!
Rule #1, when seeking help on a mailing list -- don't just say that you got an error; actually state the error. Help others help you. Rule #2. Try and provide both specific as well as generic info on your case. Not everyone in this list uses whatever program you are trying to use, but they can advise you on the SQLite aspect of it. That said, seems your query is really of the form SELECT * FROM table WHERE date_column BETWEEN some_date AND some_other_date; There is no function called Format(column, ...). The function is strftime. You can get a lot by looking at the relevant page on the wiki <http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions> > > > -- > > Fabio Stranieri > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
