unable to insert into mysql table

[mohanakrishnan]

hi
im unable to insert a record into the table but im able to execute the select
query..i checked ,the db connection is true..

QSqlDatabase db1=QSqlDatabase::database("ganesh");
if(db1.open())
{
  qDebug()<<"connection ok";
QSqlQuery query;
        query.exec("insert into waitrequest(bednumber)values('123')");
}

QSqlDatabase db1=QSqlDatabase::database("ganesh");
if(db1.open())
{
  qDebug()<<"connection ok";
QSqlQuery query;
        query.exec("insert into waitrequest(bednumber)values('123')");
}

To copy to clipboard, switch view to plain text mode 

but it shows message like below...
QSqlQuery:: exec: database not open
but if i use select query i get the result!!.
any help is highly respected!!
thanks...

[JD2000]

I think that the line should read

query.exec("insert into waitrequest(bednumber)" "values('123')");

[Lesiok]

In line

QSqlDatabase db1=QSqlDatabase::database("ganesh");

QSqlDatabase db1=QSqlDatabase::database("ganesh");

To copy to clipboard, switch view to plain text mode 

You are getting database connection named "ganesh". And in line

QSqlQuery query;

QSqlQuery query;

To copy to clipboard, switch view to plain text mode 

You are using default database connection. Change this line to :

QSqlQuery query(db1);

QSqlQuery query(db1);

To copy to clipboard, switch view to plain text mode 

[mohanakrishnan]

hi lesiok
thanks for ur help ,i ll try wat u said ,and come back
thanks...

[mohanakrishnan]

Hi Lesiok
thanks for ur help,it worked correctly,i was trying this for 3 hrs....
thanks a lot...