Bonsoir,

j'ai un problème avec SQLite au niveau d'une requête.

Voici la requête :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
 
    public Cursor selectObs(String obs)
    {
 
    	String Query = "SELECT nom, espece, description" +
				" FROM " + DBHelper.TABLE_OBSERVATIONS+
				" WHERE nom LIKE " + obs ;
 
    	Cursor mCursor = ExecuteQuery(Query, null);
 
    	return mCursor;
et la structure de la table pour donner une idée :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
 
private static final String CREATE_BDD = "CREATE TABLE " + TABLE_OBSERVATIONS + " (" +
			"nom TEXT,"+
			"espece TEXT NOT NULL, "+
			"description TEXT NOT NULL, "+
			"image TEXT NOT NULL, " +
			"latitude REAL NOT NULL, " +
			"longitude REAL NOT NULL);";
appellée par ce code :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
 
String obs = recherche.getText().toString();
    	db = new DBAdapter(getApplicationContext());
    	try
    	{
    	resultatRecherche = db.selectObs(obs);
    	}
    	//nombreObs = db.compteElements();
    	catch (Exception e)
    	{
    		Log.e("Noresi","Erreur", e);
    	}
et voici le log d'erreur :

06-05 21:16:43.375: E/Noresi(1854): Erreur
06-05 21:16:43.375: E/Noresi(1854): android.database.sqlite.SQLiteException: no such column: sanglier: , while compiling: SELECT nom, espece, description FROM table_observation WHERE nom LIKE sanglier
06-05 21:16:43.375: E/Noresi(1854): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
06-05 21:16:43.375: E/Noresi(1854): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)
06-05 21:16:43.375: E/Noresi(1854): at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:143)
06-05 21:16:43.375: E/Noresi(1854): at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)
06-05 21:16:43.375: E/Noresi(1854): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:127)
06-05 21:16:43.375: E/Noresi(1854): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:94)
06-05 21:16:43.375: E/Noresi(1854): at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:53)
06-05 21:16:43.375: E/Noresi(1854): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)
06-05 21:16:43.375: E/Noresi(1854): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1564)
06-05 21:16:43.375: E/Noresi(1854): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1538)
06-05 21:16:43.375: E/Noresi(1854): at noresi.inter.DBAdapter.ExecuteQuery(DBAdapter.java:51)
06-05 21:16:43.375: E/Noresi(1854): at noresi.inter.DBAdapter.selectObs(DBAdapter.java:105)
06-05 21:16:43.375: E/Noresi(1854): at noresi.inter.Ecran_rechercher.recherche(Ecran_rechercher.java:121)
06-05 21:16:43.375: E/Noresi(1854): at noresi.inter.Ecran_rechercher$4.onClick(Ecran_rechercher.java:100)
06-05 21:16:43.375: E/Noresi(1854): at android.view.View.performClick(View.java:3511)
06-05 21:16:43.375: E/Noresi(1854): at android.view.View$PerformClick.run(View.java:14105)
06-05 21:16:43.375: E/Noresi(1854): at android.os.Handler.handleCallback(Handler.java:605)
06-05 21:16:43.375: E/Noresi(1854): at android.os.Handler.dispatchMessage(Handler.java:92)
06-05 21:16:43.375: E/Noresi(1854): at android.os.Looper.loop(Looper.java:137)
06-05 21:16:43.375: E/Noresi(1854): at android.app.ActivityThread.main(ActivityThread.java:4424)
06-05 21:16:43.375: E/Noresi(1854): at java.lang.reflect.Method.invokeNative(Native Method)
06-05 21:16:43.375: E/Noresi(1854): at java.lang.reflect.Method.invoke(Method.java:511)
06-05 21:16:43.375: E/Noresi(1854): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
06-05 21:16:43.375: E/Noresi(1854): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
06-05 21:16:43.375: E/Noresi(1854): at dalvik.system.NativeStart.main(Native Method)

Je ne comprends même pas qu'une telle erreur puisse arriver. No such column ? Alors que j'ai enregistré une observation dont le nom est sanglier juste avant...

Merci