Database creation error in Qt

Question

I am using this code to create a database. But I am getting "false" in debug. I tried a lot but its not working. What is the error in this?

 QSqlQuery query;
qDebug() << query.exec("CREATE TABLE glucose (id INTEGER PRIMARY KEY AUTOINCREMENT, value INTEGER, date TEXT, time TEXT, duration TEXT, note TEXT");

   qDebug() << query.prepare("INSERT INTO glucose(id, value, date, time, duration, note)""VALUES(?, ?, ?, ?, ?, ?)");

   query.bindValue(1,edit_glucose->text().toInt());

   query.bindValue(2,datetime->date());

  query.bindValue(3,datetime->time());

  query.bindValue(4,"a");

   query.bindValue(5,edit_note->toPlainText());
   qDebug() << query.exec();

Haim Evgi · Accepted Answer · 2011-02-07 09:03:49Z

5

you forget to close your CREATE TABLE query with ")"

answered Feb 7, 2011 at 9:03

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

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

Comments

Reto ODT · Accepted Answer · 2011-02-07 11:18:56Z

2

QSqlQuery has the method lastError(), returns error information :)

answered Feb 7, 2011 at 11:18

Reto ODT

3612 silver badges3 bronze badges

1 Comment

amrit_neo Over a year ago

yes I have used that : qDebug()<< query.lastError(); But its showing error : binary '<<' no operator found which can takes a left hand operand of type Qdebug(there is no acceptable conversion).

Nick Dandoulakis · Accepted Answer · 2011-02-07 09:03:30Z

1

You are passing in the INSERT query the id field. You must remove it.

The query should be:

Debug() << query.prepare("INSERT INTO glucose(value, date, time, duration, note) 
                                      VALUES(?, ?, ?, ?, ?)");

answered Feb 7, 2011 at 9:03

Nick Dandoulakis

43.3k17 gold badges106 silver badges139 bronze badges

Collectives™ on Stack Overflow

Database creation error in Qt

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related