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')");
}

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...:confused::crying:

[JD2000]

I think that the line should read

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

[Lesiok]

In line

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

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

QSqlQuery query;

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

QSqlQuery query(db1);

[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...
:D:D