I have a table whose columns have numbers:
Table name "Valores"
id Nombre 11 18 12.3
01 Juan 10 08 15
02 Rosa 23 51 61
03 Pepe 35 18 11
I want to know the amount you have chosen any name in the column. Example to Rosa in the column 12.3 is 61. I made the following statements:
columna = (EditText) findViewById(R.id.eT_columna);
valor = (EditText) findViewById(R.id.eT_valor);
String stColumna = columna.getText().toString();
public void consulta (View v){
//Determinación del valor
Cursor fila_valores = bd_valores.rawQuery(
"select "+ stColumna + " from Valores where Nombre", null);
if (fila_valores.moveToFirst()) {
valor.setText(fila_valores.getString(0));
}
bd_valores.close();
}
to run the application I get as a result 12.3 (correct value 61). What is my mistake ?. Thank You (sorry for my English)
I found the solution to the problem:
columna = (EditText) findViewById(R.id.eT_columna);
Nombre = (EditText) findViewById(R.id.eT_Nombre);
valor = (EditText) findViewById(R.id.eT_valor);
String stColumna = columna.getText().toString();
String stNombre = Nombre.getText().toString();
public void consulta (View v){
//Determinación del valor
Cursor fila_valores = bd_valores.rawQuery(
"select "+ '"' + stColumna +'"'+ " from Valores where Nombre=" + "'"+stNombre+"'", null);
if (fila_valores.moveToFirst()) {
valor.setText(fila_valores.getString(0));
}
fila_valores.close();
}
thank you for your help.