Writing SQlite Database in Qt

Question

I wrote a SQLite database for client server program. but during debug when it comes to line which I star in code it crash and stop debuging. Could you please help me ?thanks

Here is the code:

bool create = !QFile::exists("Message.dat");

if (!myserver.createConnection())
   return 1;

if (create)    ***"Here return false"****

   myserver.insertMessage();

void insertMessage(QString IPAddrress, QDate date, QString message)
{
    QSqlQuery query;
    query.addBindValue(IPAddrress);
    query.addBindValue(date);
    query.addBindValue(message);
    query.exec();
}

void MainWindow::insertMessage()
{
  QSqlQuery query;

  query.prepare("INSERT INTO messages(IPAddress, date, message)"
                        " values(?,?,?)");
 }

This question is unanswerable with the code provided... but, it looks like you think the two query objects are somehow the same object (because you prepare it in one function, and bind values in another). They are not, they are two separate objects. Also, try explicitly giving the database to the query, just to be sure it really uses the same database. And check return value of every method, which may return an error. — hyde
– hyde, Commented Dec 26, 2015 at 17:43

themantalope · Accepted Answer · 2015-12-29 00:43:00Z

1

Please take a look at this line:

bool create = !QFile::exists("Message.dat");

The way your syntax is written, it says create is true if "Message.dat" does not exist, because you have a ! in front of the exists function. This will return false if "Message.dat" does exist. Try removing the ! operator.

edited Dec 29, 2015 at 0:43

answered Dec 26, 2015 at 14:37

themantalope

1,05012 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

Writing SQlite Database in Qt

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related