On Wed, Apr 26, 2017 at 4:23 PM, José Olavo Cerávolo <[email protected]> wrote: > Hi Guys, > I sent a message but it guess it was misplaced.I am trying to read a SQLite > database, but I have problems with the data.I can connect to it, read the > tables, but the values are messed up.I can't get the Dates, it comes out as > .NULL or with weird numbers.I've looked at the documentation, but nothing is > working.I am using the SQLite ODBC for SQLite version 3. > Thanks in advance, > Jose.
Locate and run the SQLite3.exe to give us some more info: SQLite3 <path and SQLite filename> List the tables in the database with: .tables List the schema for the table of interest with: .schema <tablename> Then you can show us the SQL you're running from VFP and what results look like. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4t2AVRWA8bwyO+Ti9JPOU3qzNDfE7pH5n_FMXx90=m...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
