Quote Originally Posted by ChrisW67 View Post
The column type must be "INTEGER" in full to get he magic meaning.
http://www.sqlite.org/faq.html#q1
Alright, I need to stop blindly trusting google and third party sites then, I was following documentation from this site:

http://www.tutorialspoint.com/sqlite...sert_query.htm

Quote Originally Posted by ChrisW67 View Post
Is the object "query" constructed using the connection "NETTO_CONNECTION" or is it trying to use the default connection?
Changed:

Qt Code:
  1. QSqlQuery query(this->db);
To copy to clipboard, switch view to plain text mode 

To:

Qt Code:
  1. QSqlQuery query(this->db.database("NETTO_CONNECTION"));
To copy to clipboard, switch view to plain text mode 

And the table structure now reads:

Qt Code:
  1. CREATE TABLE inventory ( id INTEGER PRIMARY KEY NOT NULL UNIQUE, name CHAR(120) NOT NULL, description TEXT, category INTEGER, employee INTEGER, location INTEGER );
To copy to clipboard, switch view to plain text mode 

Still no dice, the same output from QSqlQuery via qDebug(): "Parameter count mismatch"

(I did tell QSqlQuery to use NETTO_CONNECTION on an earlier attempt, but as I got increasingly more frustrated with the problem I reshuffeled the code blindly in a desperate attempt to locate the problem ... but the INTEGER value was new to me, thanks for the heads up on that one!)