Unable to work with database

[Atomic_Sheep]

I edited the code a litte:

qDebug() << "Database sequence " << iDatabaseSequence << "Database name = " << sDatabaseName << "File associated = " << sDatabaseFileName;

qDebug() << "Database sequence " << iDatabaseSequence << "Database name = " << sDatabaseName << "File associated = " << sDatabaseFileName;

To copy to clipboard, switch view to plain text mode 

Now it prints out:

Database sequence 0 Database name = "main" File associated = "D:\path to .db file where the .exe is data.db"

[ChrisW67]

Your query as posted is not valid SQL and should be returning an error.

If the query was corrected in the obvious way and returns no rows, i.e. the while() loop is never entered, that would be because there are no rows in that table with 'EMPTY' in column4. This is correct behaviour.

[Atomic_Sheep]

Turns out, everything is working fine, I think my database is corrupt (or I stuffed up access to sqlite conversion), if I search for WHERE column4 = 'SOMETHING', it works, and indeed, if I just pull all the data that it can without the where statement, it only pulls the the SOMETHINGs, so not quite sure where the database got corrupted but at least it pretty much solved.