On Thu, Jun 21, 2012 at 10:37 AM, Dennis Volodomanov <i...@psunrise.com> wrote: > On 22/06/2012 12:30 AM, Pavel Ivanov wrote: >> >> Maybe SQLiteStudio, sqlite3 shell and your app don't use the same database >> file? I don't think there's any sane reason for SQLiteStudio to convert 0 to >> 64. Pavel On Thu, Jun 21, 2012 at 10:22 AM, Dennis Volodomanov >> <i...@psunrise.com> wrote: > > > No, it's the same DB - I've got the path double-checked and it's all local > and both SQLiteStudio and sqlite3 shell are copied into the same folder as > well. Just to clear things up, I did re-try the statement in SS and this > time it returns the expected "integer|0", so I must've done something wrong > on the first run, sorry for the confusion.
OK. And now when you execute the original statements (SELECT COUNT(...) and SELECT ... WHERE ColC = 0) in SQLiteStudio and sqlite3 shell you still get the same results? 1 in the first statement and no rows in the second one? Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users