On 28 May 2013, at 1:06pm, Dave Wellman <dwell...@ward-analytics.com> wrote:
> Using the sqlite3 shell program: > > If I ran a simple "SELECT * FROM table;" then all expected rows were > returned - hence the rows were in the table. > > Looking at the output from the query the QUERYID column contains a value of > 1 for all rows (as expected). > > However, if I ran "SELECT QUERYID,COUNT(*) FROM table GROUP BY 1;" I get two > rows in my answer set. They both 'look' like they contain a value of 1, but > obviously they are different to the dbms. In addition to Dave and kyan's suggestions, you might like to try SELECT rowid,* FROM table which should let you identify which rows have which problems. As far as I know, there's no easy way to extract the 'raw' data for a row using the SQLite API. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
