Search String Random in Sqlite and then show the Result on the Screen with button

Question

// Create Database. final Sqlitedatabase bankDados = openOrCreateDatabase("Table name", MODE_PRIVATE, null);

    // Criar Tabela.

    bancoDados.execSQL("CREATE TABLE IF NOT EXISTS  questions(id INT(3),perguntas VARCHAR)");

    // Inserir Dados. ( Crl+d para duplicar INSERT INTO ).

   // bancoDados.execSQL("INSERT INTO questions(id,perguntas) VALUES (1,'Posso ser cromado 1')");
   // bancoDados.execSQL("INSERT INTO questions(id,perguntas) VALUES (2,'Posso ser cromado 2')");


    // Puxar os dados da Tabela.

    bt_perguntar.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {

    Cursor cursor = bancoDados.rawQuery("" +
                    "SELECT perguntas " +
                    "FROM questions " +
                    "ORDER BY RANDOM() " +
                    "LIMIT 1;",
            null);


    int indicePerguntas = cursor.getColumnIndex("perguntas");

    cursor.moveToFirst();
    while (cursor != null){

        text_pergunta.setText(cursor.getString(indicePerguntas));
        cursor.moveToNext();

        //Log.i("RESULTADO - Pergunta ",cursor.getString(indicePerguntas));
    }

        }
    }); 

Log error.

The idea is to work like this:

Answer 1

Just wear it inside the Cursor that one query that will work and you can use the cursor:

    Cursor cursor = bancoDados.rawQuery("" +
            "SELECT perguntas " +
            "FROM questions " +
            "ORDER BY RANDOM() " +
            "LIMIT 1;", 
            null);