Inserting Multiple Rows In A SQLITE Database Using qt

Question

Hello I am trying to insert multiple rows (two in this case) into a SQLITE database using qt 5.4. I have been following the documentation but the program has been crashing and I can not explain why.

query_Invoice.prepare("INSERT INTO Invoice VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
QVariantList Invoice_Number, Date_Time, Total_Purchased, Qty, Description, Product_CODE, Unit_Price, Total_Price, Goods_Total, VAT_Invoice, Company_ID;
Invoice_Number << 1 << 2;
Date_Time << 1776-07-04 << 1776-07-05;
Total_Purchased << 2 << 3;
Qty << 50 << 60;
Description << "Paint" << "Drill" << QVariant(QVariant::String);
Product_CODE << "EEFF2" << "EEF23" << QVariant(QVariant::String);
Unit_Price << 12 << 13;
Total_Price << 53 << 66;
Goods_Total << 70 << 80;
VAT_Invoice << 55 << 66;
Company_ID << 1 << 2;
query_Invoice.addBindValue(Invoice_Number);
query_Invoice.addBindValue(DateTime);
query_Invoice.addBindValue(Total_Purchased);
query_Invoice.addBindValue(Qty);
query_Invoice.addBindValue(Description);
query_Invoice.addBindValue(Product_CODE);
query_Invoice.addBindValue(Unit_Price);
query_Invoice.addBindValue(Total_Price);
query_Invoice.addBindValue(Goods_Total);
query_Invoice.addBindValue(VAT_Invoice);
query_Invoice.addBindValue(Company_ID);
query_Invoice.execBatch();
qDebug() << query_Invoice.executedQuery();
qDebug() << query_Invoice.lastError();

yes, i have connected to the database and have created the table with the corresponding fields — Root0x
– Root0x, Commented Mar 3, 2015 at 17:31

davepmiller · Accepted Answer · 2015-03-03 18:02:45Z

3

Start by trying to successfully insert one row. You'll need to specify which columns in the table that the values correspond to.

query_Invoice.prepare( "INSERT INTO Invoice ( column_name1, column_name2, column_name3 ) VALUES ( ?,?,? )" );

Also, addBindValue( DateTime ) should be addBindValue( Date_Time ).

And,

query_Invoice.prepare("INSERT INTO Invoice VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); <---- Closing paren after last '?'

edited Mar 3, 2015 at 18:02

answered Mar 3, 2015 at 17:31

davepmiller

2,7353 gold badges37 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Root0x Over a year ago

I am abel to insert 1 single row into the database

davepmiller Over a year ago

Did you try adding the column names?

davepmiller Over a year ago

Added another suggestion. DateTime to Date_Time in addBindValue()

Root0x Over a year ago

Changed DateTime to Date_Time and it is working, thank you very much for the help.

Collectives™ on Stack Overflow

Inserting Multiple Rows In A SQLITE Database Using qt

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related