qsqlquery insert error

[fantom]

Hello all,

I am new in using qt and i would like some help. Currently i am trying to insert data to an sqlite db and i I get error, any ideas into what I might be doing wrong? The strings come from a Form's LineEdit fields. Please see below the code:

void Register::Register1()
{
	QSqlQuery query;
    query.prepare("INSERT INTO User (pk, name, psw) "
                   "VALUES ( :name, :psw)");
 
 query.bindValue( ":name", ui.RUserNameLineEdit->text() );
 query.bindValue( ":psw",ui.RPassword->text() );
 
 
if( !query.exec() )
 
qDebug() << "> Query exec() error." << query.lastError().type();
 
else
 
qDebug() << ">Query exec() success.";

void Register::Register1()
{
	QSqlQuery query;
    query.prepare("INSERT INTO User (pk, name, psw) "
                   "VALUES ( :name, :psw)");
 
 query.bindValue( ":name", ui.RUserNameLineEdit->text() );
 query.bindValue( ":psw",ui.RPassword->text() );
  

if( !query.exec() )

qDebug() << "> Query exec() error." << query.lastError().type();

else

qDebug() << ">Query exec() success.";

To copy to clipboard, switch view to plain text mode 

Thank you !

[unit]

You should bind pk value

If pk is autoincrement key, use

INSERT INTO User (pk, name, psw) VALUES (NULL, :name, :psw)

INSERT INTO User (pk, name, psw) VALUES (NULL, :name, :psw)

To copy to clipboard, switch view to plain text mode 

[fantom]

Hello unit,

Thank you for your response. Actually i removed totally the primary key but i still get the "Query exec () error. 2".

Do you have any idea? Shall i send you more info(code)?

---

Added after 22 minutes:

Hello unit,

Thank you for your response. Actually i removed totally the primary key but i still get the "Query exec () error. 2".

Do you have any idea? Shall i send you more info(code)?

[unit]

2 is SQL statement syntax error (from enum QSqlError::ErrorType).

Try:

QSqlQuery query;
query.prepare("INSERT INTO User (pk, name, psw) "
                       "VALUES (NULL, :name, :psw)");
query.bindValue( ":name", ui.RUserNameLineEdit->text() );
query.bindValue( ":psw",ui.RPassword->text() );

QSqlQuery query;
query.prepare("INSERT INTO User (pk, name, psw) "
                       "VALUES (NULL, :name, :psw)");
query.bindValue( ":name", ui.RUserNameLineEdit->text() );
query.bindValue( ":psw",ui.RPassword->text() );

To copy to clipboard, switch view to plain text mode 

and also you should use QSqlDatabase for QSqlQuery object

db = QSqlDatabase::addDatabase("QMYSQL", "_default_");
    db.setHostName("127.0.0.1");
    db.setDatabaseName("testpay");
    db.setUserName("mypay");
    db.setPassword("test123");
    if(db.open())
    {
     QSqlQuery query(db);
     }

db = QSqlDatabase::addDatabase("QMYSQL", "_default_");
    db.setHostName("127.0.0.1");
    db.setDatabaseName("testpay");
    db.setUserName("mypay");
    db.setPassword("test123");
    if(db.open())
    {
     QSqlQuery query(db);
     }

To copy to clipboard, switch view to plain text mode