QT SQL DATABASE LOGIN

GREYON

This part:```
else
{

    QSqlQuery qry;

qry.prepare("INSERT INTO payments (SURNAME,LASTNAME,GRADE,CLASS,AMOUNT,DATE)"
            "VALUES(:SURNAME, :LASTNAME, :GRADE, :CLASS, :AMOUNT,  :DATE)");

qry.bindValue(":SURNAME",name);
qry.bindValue(":GRADE",grade);
qry.bindValue(":CLASS",clas);
qry.bindValue(":AMOUNT",amount);
qry.bindValue(":LASTNAME",receiver);
qry.bindValue(":DATE",date);

if(qry.exec())
    {
   QMessageBox::information(this,"inserted","PAYMENTS RECORDED SUCCESSFULLY!");

  }
else

{

   QMessageBox::warning(this,"warning","PAYMENT NOT RECORDED!");

}
}
}
}
}

GREYON

The main aim is prevent the user from entering the same **SURNAME and LASTNAME twice, those line of code I wanted them to be executed if the data entered does not match ant any of the data already in the data base .but instead its not responding

SGaist

Hi,

That's the kind of constraints that should be done at the database level.
Your database structure might also be too simple in the sense that if can be pretty easy to get duplicated data with small typos.

JonB

@GREYON
You should say what goes wrong? Do you get a compilation error? A runtime error? A message? If so, tell us what the message is. Something doesn't do what you expect? If so what, and how do you know? That's what's required for people to look at your issue!

qry.prepare("INSERT INTO payments (SURNAME,LASTNAME,GRADE,CLASS,AMOUNT,DATE)"
            "VALUES(:SURNAME, :LASTNAME, :GRADE, :CLASS, :AMOUNT,  :DATE)");

Those two strings get joined. Look at them, and you will realize that will generate in the middle:

... CLASS,AMOUNT,DATE)VALUES(:SURNAME,

The VALUES touches the parenthesis to its left, which is different from the sample code at https://doc.qt.io/qt-5/qsqlquery.html#approaches-to-binding-values. I don't know if that will be enough to error.

In any case, when a query goes wrong (if that's what's happening), use https://doc.qt.io/qt-5/qsqlquery.html#lastError to print out the text of the error.

GREYON

@SGaist
Now what are you suggesting items of help?

JonB

@GREYON

In any case, when a query goes wrong (if that's what's happening), use https://doc.qt.io/qt-5/qsqlquery.html#lastError to print out the text of the error.

Have you done this yet?

GREYON

@JonB
Not yet,thanks let me go through it

SGaist

@GREYON said in QT SQL DATABASE LOGIN:

@SGaist
Now what are you suggesting items of help?

What experience do you have with relational database design ?

GREYON

@SGaist
Not as experience as such,we let about it ,it was part of our course now we have a project.

SGaist

Well, in that case you should start by learning a bit more about them before going further. At least take the time to go through Qt's SQL module documentation and examples.

GREYON

@SGaist
Yeah,I think so

GREYON

@GREYON
Thanks after going through Qsql documentation,the problem has been resolved

Christian Ehrlicher

@GREYON Then please mark this topic as solved, thx.

GREYON

@Christian-Ehrlicher
Okay , thanks for the information,but am new here,how can it mark as solved please?