Advertisement
Guest User

Untitled

a guest
Dec 11th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. QSqlDatabase sdb = QSqlDatabase::addDatabase("QSQLITE");
  2. qDebug() << sdb.isValid();
  3. sdb.setDatabaseName("/home/farex/dev/task_reminders/task.db");
  4. QString name = ui->calendarWidget->selectedDate().toString("dd.MM.yyyy") + " "+ ui->timeEdit->text();
  5. sdb.open();
  6. if(sdb.isOpen()){
  7. _query.prepare("INSERT INTO table_task (name, data, time, text) VALUES (:name, :data, time, text)");
  8. _query.bindValue(":name", name );
  9. _query.bindValue(":data", ui->calendarWidget->selectedDate().toString("dd.MM.yyyy"));
  10. _query.bindValue(":time", ui->timeEdit->time());
  11. _query.bindValue(":text", ui->textEdit->toPlainText());
  12. _query.exec();
  13. // qDebug() << _query.lastError();
  14. sdb.close();
  15. }
  16. else{
  17. QMessageBox mess;
  18. mess.setText("");
  19. mess.exec();
  20. qDebug() << QSqlDatabase::drivers();
  21. }
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement