sai_3289
25th February 2013, 15:53
Hi,
METHOD1()
{
if(db.open())
{
QSqlDatabase db=QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("/mnt/jffs2/Offlinedb.sqlite");
QSqlQuery query("select * from networkmode");
while (query.next()) {
QString country = query.value(0).toString();
QMessageBox::critical(0,"Success",country,QMessageBox::Ok);
}
}
else
{
QMessageBox::critical(0,"Error","Database Connection Problem",QMessageBox::Ok);
}
}
-------------------------
method2()
{
QSqlDatabase db=QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("/mnt/jffs2/Offlinedb.sqlite");
QSqlQuery query;
if(db.open())
{
bool ch=query.exec("select * from networkmode");
qDebug()<<"REQUIRED CH______REGQISSSSSs"<<ch;
if(ch)
QMessageBox::critical(0,"Success","Database Conected",QMessageBox::Ok);
else
QMessageBox::critical(0,"Error",query.lastError().text(),QMessageBox::Ok);
}
else
{
QMessageBox::critical(0,"Error","Database Connection Problem",QMessageBox::Ok);
}
}
->The METHOD1 is executing with no issues but when i follow method2 procedure i am getting the error as "out of memory Unable to execute statement" from line13......Y is to so behaving odd ????
->i am calling those methods in constructor.
METHOD1()
{
if(db.open())
{
QSqlDatabase db=QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("/mnt/jffs2/Offlinedb.sqlite");
QSqlQuery query("select * from networkmode");
while (query.next()) {
QString country = query.value(0).toString();
QMessageBox::critical(0,"Success",country,QMessageBox::Ok);
}
}
else
{
QMessageBox::critical(0,"Error","Database Connection Problem",QMessageBox::Ok);
}
}
-------------------------
method2()
{
QSqlDatabase db=QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("/mnt/jffs2/Offlinedb.sqlite");
QSqlQuery query;
if(db.open())
{
bool ch=query.exec("select * from networkmode");
qDebug()<<"REQUIRED CH______REGQISSSSSs"<<ch;
if(ch)
QMessageBox::critical(0,"Success","Database Conected",QMessageBox::Ok);
else
QMessageBox::critical(0,"Error",query.lastError().text(),QMessageBox::Ok);
}
else
{
QMessageBox::critical(0,"Error","Database Connection Problem",QMessageBox::Ok);
}
}
->The METHOD1 is executing with no issues but when i follow method2 procedure i am getting the error as "out of memory Unable to execute statement" from line13......Y is to so behaving odd ????
->i am calling those methods in constructor.