SQLite truble

I've got problems with this code:

Code:

---

QSqlQuery *cola = new QSqlQuery("SELECT id, pregunta, respuesta, referencia, dificultad, tema FROM preguntas");
if( cola->exec() )
{
   while( cola->next() )
   {
      cout<<"-----------------------------------------------"<<endl;
      cout<<"Numero de pregunta: "<<cola->value(0).toInt()<<endl;
      cout<<"Tema:"               <<cola->value(5).toInt()<<endl;
      cout<<"Dificultad:"         <<cola->value(4).toInt()<<endl;
      cout<<"Texto: "             <<cola->value(1).toString()<<endl;
      cout<<"Respuesta:"          <<cola->value(2).toString()<<endl;
      cout<<"Referencia:"         <<cola->value(3).toString()<<endl;
   }
   delete(cola);
   return;
}

---

When run it, it's stops al the first .toString() output. If the last 3 outputs are not there the cycle work fine... Any Idea????...
Using Qt 3 with linux
Thanks

Try:

Code:

---

cout << "Texto: " << cola->value(1).toString().ascii() << endl;

---

BTW. Why do you create QSqlQuery with new, if you delete it immediately? Won't it be simplier if you would create it on the stack?

the ascii() function didnt work...

the pointer thats it's created and deleted it's because sqlite block the whole db in each query. I've already tryed with QSqlCursor but does't work too. Any another idea?
what do you mean with create it on stack? using only one query in the wole object?

I find a lot of java programmers use new instead of the stack. Force of habit :p

Try:
cout << "Texto: " << cola->value(1).toString().toAscii().data() << endl;

Quote:

---

Originally Posted by tranfuga25s

what do you mean with create it on stack? using only one query in the wole object?

---

no..
just write

Code:

---

QSqlQuery cola("SELECT id, pregunta, respuesta, referencia, dificultad, tema FROM preguntas");

---

and dots " . " instead of the arrows "->" when requesting a member of cola..

then you don't need the "delete cola"..

regards..
aman..