SQLite truble

[tranfuga25s]

I've got problems with this 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;
}

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;
}

To copy to clipboard, switch view to plain text mode 

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

[jacek]

Try:

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

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

To copy to clipboard, switch view to plain text mode 

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?

[tranfuga25s]

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?

[gfunk]

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

[croland]

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

[aMan]

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

no..
just write

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

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

To copy to clipboard, switch view to plain text mode 

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

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

regards..
aman..