Syntax Error in SQLITEDATABASE in Android

Question

In My database I want to retrieve a row from my database . For this I write a query :

Cursor mCursor = db.query("Author_table", column_name, "Author_name=?" , params, null , null , null) ;

By this I want to do the following query : "Select AID from Author_table where Author_name = Sultan" . But I have got anexception in SQLiteDatabase in android . Please suggest me what to do ??

Better yet, look at the exception and try to understand it and fix it. (And post a question here when all else fails) — keyser
– keyser, Commented Oct 10, 2012 at 13:34
The exception shows that There is no table named "Author_table" .But I am sure that the table exists . From this I guess that there is some error in query syntax . — osimer pothe
– osimer pothe, Commented Oct 10, 2012 at 13:35
can u show the code for creating table? are you using open helper or plain sql commands? — kjurkovic
– kjurkovic, Commented Oct 10, 2012 at 13:48
I have used SQLiteDatabase Browser to create that database . — osimer pothe
– osimer pothe, Commented Oct 10, 2012 at 13:51

kjurkovic · Accepted Answer · 2012-10-10 13:57:56Z

Something like this should work:

Cursor c = db.query("Author_table", new String[] {"AID"}, "Author_name=?", new String[] {"Sultan"}, null, null, null);

EDIT

SQLOpenHelper

import java.io.File;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Environment;

public class OpenHelper extends SQLiteOpenHelper {

    private static final String DATABASE_NAME = "test.db";
    private static final int DATABASE_VERSION = 8;

    private static final String CREATE_TABLE_USER = "create table USER( "
            + "username varchar(256) not null, " + "sex varchar(1) not null, "
            + "password varchar(64) not null, " + "active int not null"
            + ");";

    public OpenHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_TABLE_USER);
    }

    @Override
    public void onOpen(SQLiteDatabase db) {
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

        if (oldVersion < 8) {
            // db update goes here and in onCreate() (for newly installed apps)
        }
    }

}

toadzky · Accepted Answer · 2012-10-10 13:33:32Z

0

Wrap string values in single quotes. Your query should look like

Select AID from Author_table where Author_name = 'Sultan';

instead of

Select AID from Author_table where Author_name = Sultan;

answered Oct 10, 2012 at 13:33

toadzky

3,8461 gold badge18 silver badges26 bronze badges

Comments

Sardor Dushamov · Accepted Answer · 2012-10-10 13:38:51Z

0

Try this query

Cursor cursor = db.query("Author_table", new String[] { "AID" },
                    "Author_name LIKE ?", new String[] { "%Sultan%" }, null, null,null);

answered Oct 10, 2012 at 13:38

Sardor Dushamov

1,6674 gold badges17 silver badges45 bronze badges

Collectives™ on Stack Overflow

Syntax Error in SQLITEDATABASE in Android

3 Answers 3

EDIT

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

EDIT

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related