Re: [sqlite] Another Date Question

2009-04-29 Thread Steven . Farmer
If you just convert that floating number back to a date using the CDate Function. It properly converts it back. Open the vb project and do not run it but just open the Immediate window and type the following lines and you will see it do the conversion. ? cdate(39895.56086) 3/23/2009 1:27:38

Re: [sqlite] Sqlite, vb6 and date time field

2009-04-08 Thread Steven . Farmer
Can you provide maybe 10 samples of the dates on the database. Some databases have a different date format and you might have to format the date or convert it to a string and back into a date again. sqlite-users-boun...@sqlite.org wrote on 04/08/2009 06:20:09 AM: > Hi > > I received a

Re: [sqlite] SQLite + CrystalReport + Visual Basic . NET

2009-04-07 Thread Steven . Farmer
Yes there is an ODBC driver to use with SQLite.dll Check out this web page. http://www.ch-werner.de/sqliteodbc sqlite-users-boun...@sqlite.org wrote on 04/07/2009 02:13:28 AM: > Hello, > > Is it possible to use CystalReport + SQLite with Visual Basic 2005. NET?? > > Thanks, > > Ernany >