QT5 and SQLLite: Parameter count mismatch upon Insert

[skruffynerherder]

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

Is the object "query" constructed using the connection "NETTO_CONNECTION" or is it trying to use the default connection?

Changed:

QSqlQuery query(this->db);

QSqlQuery query(this->db);

To copy to clipboard, switch view to plain text mode 

To:

QSqlQuery query(this->db.database("NETTO_CONNECTION"));

QSqlQuery query(this->db.database("NETTO_CONNECTION"));

To copy to clipboard, switch view to plain text mode 

And the table structure now reads:

CREATE TABLE inventory ( id	INTEGER	PRIMARY KEY	NOT NULL    UNIQUE, name	CHAR(120)	NOT NULL, description	TEXT, category	INTEGER, employee	INTEGER, location	INTEGER );

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!)